Data Head

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

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

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

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

KB2463332 failed to install

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

workaround for orphaned users

The server principal  is not able to access the database  under the current security context, is the error message appears...

Missing indexes

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

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

ALTER AUTHORIZATION sql to change owner of a database

ALTER AUTHORIZATION changes the ownership of  entities .  Server level entity ownership can be changed to server- level principals. Database level...

Paying for Free

It seems like there is a widespread malaise in the country these days. Everyone's clamoring to cut taxes -but no one wants to have their neighborhood school closed, or...