Monthly Archives: May 2011

Using “NOT IN” in a query can provide mixed results

The topic came up at work awhile back with using various includes/excludes such as IN, NOT IN, and EXISTS.  A co-worker was working on an ETL process when he discovered that using “NOT IN” in a sub query with a … Continue reading

Share
Posted in Query Tidbits | 1 Comment

Using an Excel Destination in SSIS with x64

My first real experience with SSIS began in late Feb of this year.  I was upgrading a system from SQL 2000 to SQL 2005 (app not yet supported on 2008).  This time around I decided to do things the right … Continue reading

Share
Posted in SSIS - How To | 11 Comments

SQL Saturday 74 – Jacksonville FL

I made a 700+ mile round trip down to Jacksonville FL where I was fortunate enough to get to speak about SQL Server.  This was my third SQL Saturday to present at and my fifth SQL Saturday to attend.   I … Continue reading

Share
Posted in Training/Events | 3 Comments