Title	When Watched
Shredding XML Elements with the Xquery Value Function	1/11/2012
Secure FTP File Transfer in SSIS	1/7/2012
What is the Spool Operator?	11/2/2011
SQL Server Profiler Templates	2/10/2011
Sparse Columns in SQL Server 2008	1/28/2011
Converting a Text Data Type to an XML Data Type	1/10/2011
Covering a Query That Includes an XML Column	12/30/2010
Views, Indexed Views, and NOEXPAND	12/21/2010
Auditing your SQL Server Logins for Blank Passwords	12/21/2010
Get The Definition of a SQL Object Using Object_Definition	12/1/2010
Using the POWER Function	11/29/2010
SQL Injection Explained	11/26/2010
Creating a Performance Counter Log	11/26/2010
Options for Displaying Query Results in SSMS	11/19/2010
Using the USE Statement	11/17/2010
Row Concatenation Using FOR XML PATH	11/15/2010
Using Indexes on Tables Variables in SQL Server	11/15/2010
The MERGE statement in SQL Server 2008	11/10/2010
Using the STUFF Function	11/5/2010
Getting Good Performance using SOUNDEX	11/5/2010
Using SOUNDEX and DIFFERENCE	11/4/2010
Using the QUOTENAME Function	11/1/2010
Using SELECT to Generate SQL Commands	10/19/2010
Performance Tuning Puzzle - Part 1	10/14/2010
Creating Indexed Views	10/14/2010
Reporting Services Formatting Codes	10/14/2010
Except Operator	10/14/2010
Which Indexes Are Used By My Query?	10/13/2010
What is a Clustered Index Scan?	10/13/2010
What is an Index Scan?	10/13/2010