Data Head

Well, it’s official.  I am a Data Head.  It doesn’t change too much my level of geekiness.  But I may...

How Should We Pay People?

It’s an interesting article on how to pay people from Dan Ariely at Business Week. It’s a look at some...

KB2463332 failed to install

This morning I was working on getting all new inherited SQL Servers patched to current levels of service packs when...

Missing indexes

One of the most common things I encounter when asked to help with performance problems, is wrong or inadequate indexing....

NOT IN or IN?

I have been having a hard time believing my eyes when I noticed that these queries give different results:

1. select...

September 2011 SQL Server 2008 Instance Level Diagnostic Queries

Since it is late September, I thought it would be a good time to release an updated set of Diagnostic...

SQL Saturday in Iowa City This Weekend

In just a few short days, it will be time for SQL Saturday #98 in Iowa City.  If you’ve got...

SQL University SSIS : Named Pipes -- Producer

Yesterday, I set up the premise for using named pipes in SSIS.  Today we are going to get into the...

SSIS Child Errors in Parent Package

If you have a parent package that is looping through a set of files and calling child packages and want...

Start daily programs – More n00bz fun with #Powershell!

When I get in to work in the morning, I like a good cup of coffee waiting for me, a...