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

24 Hours of PASS Questions

I finally found the time to work through the questions from the 24 Hours of PASS session that I did....

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

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