Title	When Watched
Collections Explained	11/16/2012
SP_Who & SP_Who2	11/15/2012
Working with Foreign Keys	11/15/2012
Speak Like a SSIS Developer	2/26/2011
Using the KILL Statement	2/25/2011
Bypassing Blocking using NOLOCK	1/31/2011
Reversing Deadlocking - Part 2	1/12/2011
Reversing Deadlocking - Part 1	1/12/2011
Creating Hierarcies with HierarchyId in SQL Server 2008	1/10/2011
Using the OPTION HASH GROUP and OPTION ORDER GROUP Query Hints	1/5/2011
What is a Clustered Index Scan?	1/5/2011
What is a Clustered Index Seek?	1/5/2011
Query Hints for Unions - CONCAT UNION, HASH UNION, and MERGE UNION	1/5/2011
Covering a Query That Includes an XML Column	1/5/2011
Using the File System Task in SSIS	12/22/2010
Views, Indexed Views, and NOEXPAND	12/20/2010
CONVERT - Changing a Date to a String	12/16/2010
Understanding the Two Digit Year Cutoff in SQL Server	12/15/2010
Creating a Basic SSAS Cube	12/9/2010
Using Checkpoints in SSIS	12/7/2010
SET vs SELECT For Assigning Values to Variables	12/7/2010
Computed Columns - Part 1	12/7/2010
Using OpenRowset	12/7/2010
Indexed Views and the NOEXPAND Hint	12/7/2010
Applied Fuzzy Lookup	12/7/2010
Using the Fuzzy Lookup Transform	12/7/2010