Title	When Watched
Allowing Users to Execute Traces in SQL Server	1/10/2012
Creating an XML Data Source and Dataset in SSRS	1/9/2012
Using FOR XML with SQL Server	4/19/2011
Introduction to SQL Server XML Schemas, Part 1	4/19/2011
Creating Primary Indexes on XML Data Types in SQL Server	4/19/2011
Using OPENXML in SQL Server	3/15/2011
Introduction to Instead of Triggers	1/21/2011
Blocking, SP_Who, and SysProcesses	1/10/2011
SP_Who & SP_Who2	1/6/2011
Using Scope_Identity()	1/4/2011
DBCC InputBuffer - Seeing the Last Executed Command	12/29/2010
Views, Indexed Views, and NOEXPAND	12/20/2010
Using TOP in Queries	12/10/2010
Exploring CEILING, FLOOR, and ROUND	11/25/2010
Row Concatenation Using FOR XML PATH	11/11/2010
Performing Updates with Common Table Expressions (CTE)	11/9/2010
Using the FORCESEEK Query Hint	10/13/2010
SET vs SELECT For Assigning Values to Variables	10/4/2010
Using the OPTION FAST Query Hint	9/14/2010
Query Hints for Unions - CONCAT UNION, HASH UNION, and MERGE UNION	9/14/2010
Using the IndexProperty Function	5/27/2010
Statistics & Using DBCC Show_Statistics	5/27/2010
Adding a Time Stamp to a File Name in SSIS	3/31/2010
Error Handling in Transactions using SET XACT_ABORT	1/22/2010
How to Script Data in SQL2008	1/6/2010
Using Set Rowcount	1/6/2010
Tablediff - Compare Data in SQL Server Tables	12/17/2009
Filegroups and Adding a New Filegroup	12/6/2009
Windows and SQL Server 2005 Clustering Architecture	12/1/2009
Retrieve Table and Indexes Sizes in SMO	12/1/2009