Archives

Toad for SQL Server

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 […]

You Want Me to Put That Where???

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 […]

Planes, Trains, and.... Well Actually Just Automobiles.

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 […]

Christmas is a Time of Miracles/New Year's Resolutions

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 […]

Database Views - Using PowerPivot with Problem Databases Part 2

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 […]

Why I'm Paying my Own Way to PASS Summit 2010 and You Should Too.

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 […]

SQL Saturday Dallas #56 Re-Cap

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 […]

Presenting Epiphanies

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 […]

Announcing Project M-Data Analytics

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 […]

Super Secret Project - The Problem

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 […]