Title	When Watched
GUID or INT for Primary Key - A Mostly Unbiased Discussion	2/13/2012
Detecting Deadlocks with SQL Server Profiler	2/13/2012
Configuring Network Settings for SQL Server	2/13/2012
Using Column Sets with Sparse column in SQL Server 2008	2/13/2012
Get the Name - Using the OBJECT_NAME Function	10/19/2011
Using SELECT to Generate SQL Commands	10/19/2011
Reversing Deadlocking - Part 1	7/23/2011
Basic MERGE statements in SQL Server 2008	7/23/2011
Shrinking the Transaction Log with SMO	3/6/2011
SQL Server Profiler Templates	3/6/2011
Using Backup Compression in SQL Server	2/7/2011
Setting A Database to Read Only	1/26/2011
Using the KILL Statement	1/26/2011
Introduction to Instead of Triggers	1/23/2011
Using the Sysprocesses View	1/6/2011
SP_Who & SP_Who2	1/6/2011
SQL Server System Functions	1/6/2011
Covering a Query That Includes an XML Column	12/28/2010
Creating Hierarcies with HierarchyId in SQL Server 2008	12/24/2010
Views, Indexed Views, and NOEXPAND	12/22/2010
Using TOP in Queries	12/12/2010
Creating a Performance Counter Log	11/26/2010
SQL Injection Explained	11/26/2010
Using Indexes on Tables Variables in SQL Server	11/26/2010
Row Concatenation Using FOR XML PATH	11/26/2010
The MERGE statement in SQL Server 2008	11/26/2010
Performing Updates with Common Table Expressions (CTE)	11/9/2010
Filtering XML Elements using the Exist Method	11/9/2010
Getting Good Performance using SOUNDEX	11/6/2010
Using the STUFF Function	11/6/2010