Title	When Watched
Secure FTP File Transfer in SSIS	4/24/2012
Looping Through and Loading Files with SSIS	12/28/2011
Handling Division by Zero with NULLIF	9/7/2011
Compound Assignments in SQL Server 2008	7/29/2011
Loading Binary Files into SQL Server Using SSIS	7/23/2011
Applied Fuzzy Lookup	7/23/2011
Using the Aggregrate Transform for Group Bys in SSIS	7/23/2011
Parameterizing the Execute SQL Task in SSIS	7/23/2011
Reversing Deadlocking - Part 1	7/19/2011
How to Fix a Bookmark Lookup	5/26/2011
Unpivot Data Using the UNPIVOT Function in SQL Server	5/16/2011
Quickly Creating XML Schemas in SQL Server 2005 / 2008	5/9/2011
Generating SQL Server Scripts using SMO	5/5/2011
Create SQL Server Logins with SMO	4/29/2011
Using ClearTrace to Analyze Profiler Results	3/2/2011
Automating Nightly Builds	2/16/2011
Creating a Performance Counter Log	2/1/2011
How to Do a Split Backup in SQL Server	1/31/2011
Bypassing Blocking using NOLOCK	1/19/2011
Reversing Deadlocking - Part 3	1/13/2011
Reversing Deadlocking - Part 2	1/12/2011
Using SELECT to Generate SQL Commands	10/19/2010
Controlling Plan Guides	8/31/2010
Detecting Deadlocks with SQL Server Profiler	8/18/2010
The MERGE statement in SQL Server 2008	8/18/2010
Updating Statistics - Part 1	8/18/2010
Using the StatsDate Function	8/18/2010
Decrease Replication Latency By Configuring Batches	8/18/2010
Using OPTION RECOMPILE for Statement Level Recompilation	8/18/2010
Performance Tuning Quiz #3 - Part 2	8/18/2010