Title	When Watched
Unpivot Data with a Cross Join in SQL Server	8/30/2011
User Defined Function Tips	8/4/2011
Adding a Time Stamp to a File Name in SSIS	7/15/2011
Using Indexes on Tables Variables in SQL Server	6/15/2011
How to Fix a Bookmark Lookup	5/24/2011
Techniques for Deploying SSIS Packages	2/11/2011
String Handling Functions - Part 3	11/3/2010
Using the STR Function	11/3/2010
String Handling Functions - Part 2	10/19/2010
String Handling Functions - Part 1	10/19/2010
Query Hints for Unions - CONCAT UNION, HASH UNION, and MERGE UNION	9/14/2010
Using the OPTION FAST Query Hint	9/13/2010
Introduction to Deploying SSIS Packages	8/24/2010
Change Data Capture with SSIS	8/17/2010
PIVOT using the CASE statement	8/13/2010
Breakpoints in SSIS	8/3/2010
How to do a Copy Only Backup of a SQL Server Database	7/14/2010
Except Operator	7/2/2010
Intersect Operator	7/2/2010
Using Client Statistics	6/18/2010
Capturing the Output of a Job Step	3/30/2010
SQL Server Data File Extensions	3/24/2010
How to Change the Default Path for New Databases	3/19/2010
SSIS Control Flow Basics	2/12/2010
Secure FTP File Transfer in SSIS	7/14/2009
Understanding RID Lookups in SQL Query Plans	4/14/2009
The Key Lookup Operator in SQL Server Query Plans	1/28/2009
The Execution Plan for TOP N	1/28/2009
Parameterizing the Execute SQL Task in SSIS	1/14/2009
SQL Server Login vs Windows Authenticated Logins	1/13/2009