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 data set that contained NULL values was giving him incorrect data. Lets take a look […]
Month: May 2011
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 way and migrate from DTS to SSIS not just import the DTS and execute legacy […]
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 should mention here that I am also now planning a SQL Saturday in Atlanta. At […]