Title	When Watched
Using Hashbytes in SQL Server 2005 / 2008	1/12/2012
SQL Server Properties to Avoid	7/8/2011
Using the For Each ADO Enumerator	3/25/2011
Tablediff - Compare Data in SQL Server Tables	3/24/2011
Performing Updates with Common Table Expressions (CTE)	11/15/2010
Using ASCII, CHAR, UNICODE, and NCHAR	10/27/2010
Using SELECT to Generate SQL Commands	10/27/2010
String Handling Functions - Part 1	10/19/2010
User Defined Function Tips	7/7/2010
Joining Tables Part 2	7/7/2010
Except Operator	7/7/2010
Ranking Functions - DENSE_RANK (Part 3)	6/16/2010
Using a Script Transform in SSIS	6/15/2010
Using Checkpoints in SSIS	6/15/2010
Handling NULL Values in SSIS Using The Conditional Split Transformation	6/15/2010
GUID or INT for Primary Key - A Mostly Unbiased Discussion	5/4/2010
Working with Defaults and Constraints	5/4/2010
NewID vs NewSequentialID - Understanding Your UniqueIdentifier Options	5/4/2010
Adding and Removing Columns from SQL Server Profiler	5/4/2010
SSIS For Loop Container	5/4/2010
Delete Statement Operators	2/8/2010
Using the Identity Function	2/4/2010
XP_cmdshell Execution in SQL Server 2005 / 2008	2/4/2010
Using OpenRowset	2/2/2010
Using Identity Insert to Insert Rows	2/2/2010
Using the @@Rowcount Function	1/29/2010