Title	When Watched
Shredding XML Elements with the Xquery Value Function	1/12/2012
Using Hashbytes in SQL Server 2005 / 2008	1/9/2012
Monitoring Exec Cache in SQL Server - Part 1	12/19/2011
Multistatement UDF's in SQL Server	10/31/2011
Using the File System Task in SSIS	10/25/2011
Inline Variable Initialization in SQL Server 2008	10/18/2011
Solve Parameter Sniffing By Using OPTIMIZE FOR	9/20/2011
Execution Plan Operator Properties	9/20/2011
Solve Parameter Sniffing by Using A Plan Guide	9/6/2011
PIVOT using the PIVOT statement	8/24/2011
Creating a Database Diagram in SSMS	8/24/2011
Introduction to the Reporting Services Design Environment	8/24/2011
The difference between GRANT, DENY and REVOKE in SQL Server	8/1/2011
Modifying SQL Server Settings with SMO	8/1/2011
Compound Assignments in SQL Server 2008	8/1/2011
Using the TIMESTAMP data type in SQL Server	8/1/2011
Using Data Viewers in SSIS	6/15/2011
Using Indexes on Tables Variables in SQL Server	6/15/2011
Using the TSQL Checksum Function	6/15/2011
Blocking, SP_Who, and SysProcesses	1/28/2011
Reversing Deadlocking - Part 1	1/28/2011
Using Column Sets with Sparse column in SQL Server 2008	1/28/2011
Sparse Columns in SQL Server 2008	1/28/2011
Indexed Views and the NOEXPAND Hint	12/8/2010
Joining Tables Part 1	11/19/2010
Using Variables in a SSIS Package	11/9/2010
Using the FORCE ORDER Query Hint	11/9/2010
Query Hints for Unions - CONCAT UNION, HASH UNION, and MERGE UNION	11/9/2010
Using the OPTION FAST Query Hint	11/9/2010
Exploring the Sys.Stats and Sys.StatColumns Tables	11/9/2010