Title	When Watched
Using the Fuzzy Lookup Transform	2/9/2012
Performing Updates with Common Table Expressions (CTE)	6/17/2011
Reversing Deadlocking - Part 3	1/13/2011
Blocking, SP_Who, and SysProcesses	1/10/2011
Using the File System Task in SSIS	12/27/2010
Creating Hierarcies with HierarchyId in SQL Server 2008	12/27/2010
Creating a Computed Column as a DATE Data Type	12/8/2010
Creating a Performance Counter Log	12/1/2010
The MERGE statement in SQL Server 2008	12/1/2010
Row Concatenation Using FOR XML PATH	12/1/2010
Expression Language Basics	12/1/2010
Options for Displaying Query Results in SSMS	12/1/2010
Joining Tables Part 1	12/1/2010
Filtering XML Elements using the Exist Method	11/9/2010
Getting Good Performance using SOUNDEX	11/9/2010
Using the STUFF Function	11/9/2010
Using SOUNDEX and DIFFERENCE	11/9/2010
Sparse Columns in SQL Server 2008	10/29/2010
String Handling Functions Part 7	10/26/2010
Using SELECT to Concatenate Strings Across Rows	10/22/2010
Configuring Word Wrap and Virtual Space in SQL Server Management Studio	10/22/2010
String Handling Functions - Part 1	10/11/2010
Using the FORCESEEK Query Hint	10/8/2010
SET vs SELECT For Assigning Values to Variables	10/7/2010
Capturing Row Counts using Profiler	10/7/2010
Using IF and ELSE in TSQL - The Basics of Conditional Logic	9/29/2010
Using the OPTION FAST Query Hint	9/13/2010
Manually Creating and Dropping Statistics	9/9/2010
Multistatement UDF's in SQL Server	8/25/2010
Dynamically Hiding SSRS Report Items	8/24/2010