|
I wish I knew how to quit you… Well, not really.
In previous articles, I’ve mentioned that I use Toad for SQL Server, but until now I have not really advocated that my readers use it. While I’ve been using Toad for several years, I’ve had a love/hate relationship with it. When I first started […]
In my previous article I mentioned my surprise that many readers were not running the sample code posted on my blog. When I asked a few as to why, the number one answer was that some M2M Admins don’t know which program(s) they can use to query their SQL databases. I don’t know why this […]
Over the holidays and through the first week of this year, I took a journey back home to Michigan. Why did I drive you ask? Well, I wanted to take my Cockatoo Anakin with me. Sometime along the trip he decided that migrating was for the birds. We survived, but he was thrilled after we […]
Santa was geeked to take the pic, but Anakin wasn’t convinced.
Since the holidays are fast approaching, along with the end of the year, I’d like to take a moment to reflect on the previous year, discuss some small miracles that have happened recently, and share my New Year’s Resolutions.
My Girlfriend Missy […]
In the previous post I mentioned the use of views to simplify querying your database in general and PowerPivot in particular.
What are Database Views?
Views are virtual tables, which you can create with a SQL statement. Some of the advantages of using views are:
Simplified Data Access – The view hides the data structure from […]
A few months ago, I wrote an article about how thrilled I was to be going to PASS this year. Some of you may have gotten the impression from that article that I was given a Golden Ticket. I should have been more clear that I had bought a golden ticket, and not just for […]
Ryan, Vic, and yours truly.
SQL Saturday #56 BI Edition went off without a hitch last Saturday. Those who read this blog, probably remember the awesome experience I had at my first SQL Saturday.
Once again, everything went wonderfully. Our event was scaled back this time which translated into fewer hassles. Microsoft and […]
I Love Teaching
As I mentioned earlier this week, I really enjoyed Consona Connect 2010. I had two very important epiphanies while presenting at this event.
I know a LOT more about SQL Server than I did 3 years ago.
Don Rudo introduced me as a SQL server expert, and actually said, “Dave probably knows […]
Presenting M-Data Analytics at Consona Connect 2010
What is M-Data Analytics and how is it going to change the way you use data?
M-Data Analytics is a Data Warehouse. A Data Warehouse is a database that is specially designed for reporting and data analysis. M2M Data is extracted, checked, cleaned, and transformed to a format […]
The Problem
I’ve been working with the Made2Manage product for well over a decade and the single biggest complaint I hear about it is that customers can’t get data out of it. The most common complaints I hear are:
The included reports are too limiting and inadequate for most companies.
The database is a Visual FoxPro/SQL […]
Page 5 of 12« First«...34567...10...»Last »
|
|
Recent Comments