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 data management experience. He is a partner with Linchpin People and is the principal of Tyleris Data Solutions.

Tim has spoken at international and local events including the SQL PASS Summit, SQLBits, SQL Connections, along with dozens of tech fests, code camps, and SQL Saturday events. He 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, 855 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, 3,557 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, 414 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, 528 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, 558 reads

Posted in Tim Mitchell on 4 May 2008