Subscribe to this blog
Tim Mitchell
Archives: May 2008
Using IN with possible NULL values
There is a little quirk with NULLs when using the NOT IN qualifier. I use the term "quirk" loosely here because the behavior is exactly as intended, though it may not be obvious. The following query shows a trivial example:
At first glance, one might think that we'll see… Read more
2 comments, 431 reads
Posted in Tim Mitchell on 29 May 2008
A little fun with SSIS Expression Language
The SSIS expression language is a powerful yet enigmatic entity. Once you get used to its syntax - which is part C#, part T-SQL and part *WTH?!?* - it's actually somewhat fun to use. However, one thing it is lacking (as far as I can tell - correct me if… Read more
6 comments, 1,497 reads
Posted in Tim Mitchell on 8 May 2008
SQL Backup 5 (Red Gate)
So after many months of trudging through native SQL Server backups for new mission-critical application I'm deploying, I have decided to do some evaluations and cost/benefit analyses on aftermarket SQL Server backup products. I've started off with SQL Backup 5 from Red Gate. No disclaimers here - I have no… Read more
0 comments, 189 reads
Posted in Tim Mitchell on 6 May 2008
Photos from SQL Saturday
Check out the photos from SQL Saturday 3 - Jacksonville:
0 comments, 137 reads
Posted in Tim Mitchell on 6 May 2008
SQL Saturday Jacksonville
0 comments, 168 reads
Posted in Tim Mitchell on 4 May 2008