Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Tim Mitchell

Tim Mitchell is a business intelligence consultant, author, trainer, and SQL Server MVP with over a decade of experience. Tim is the principal of Tyleris Data Solutions and is a Linchpin People teammate. Tim has spoken at international, regional, and local venues including the SQL PASS Summit, SQLBits, SQL Connections, SQL Saturday events, and various user groups and webcasts. He is a board member at the North Texas SQL Server User Group in the Dallas area. Tim is coauthor of the book SSIS Design Patterns, and is a contributing author on MVP Deep Dives 2. You can visit his website and blog at or follow him on Twitter at

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, 715 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, 2,970 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, 340 reads

Posted in Tim Mitchell on 6 May 2008

Photos from SQL Saturday

Check out the photos from SQL Saturday 3 - Jacksonville: Read more

0 comments, 379 reads

Posted in Tim Mitchell on 6 May 2008

SQL Saturday Jacksonville

I just wrapped up a high-octane day of SQL Server community education at SQL Saturday in Jacksonville, Florida. This event, the third thus far in a series of training opportunities for SQL Server professionals, is loosely based on the Code Camp model and is billed as a community event. I…

Read more

0 comments, 409 reads

Posted in Tim Mitchell on 4 May 2008