Data Head

Well, it’s official.  I am a Data Head.  It doesn’t change too much my level of geekiness.  But I may have to rethink one of the answers given during...

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...