Title	When Watched
The Execution Plan for UNION	12/2/2011
Using the STUFF Function	11/5/2010
Exploring the Sys.Stats and Sys.StatColumns Tables	10/29/2010
Converting a Text Data Type to an XML Data Type	9/24/2010
Which Indexes Are Used By My Query?	9/10/2010
Understanding Facts and Dimensions in SQL Server	8/10/2010
Clearing the Procedure Cache	7/29/2010
How To Restore Using a Differential Backup & TSQL	7/20/2010
Deployment Options for SQL Compact projects	6/7/2010
Capturing the Output of a Job Step	3/30/2010
Using Identity Insert to Insert Rows	2/4/2010
Understanding DBCC Show_Statistics	12/14/2009
Conditional SQL Server Backups with SMO	8/7/2009
Understanding SQL Server Securables	7/28/2009
Using the Aggregrate Transform for Group Bys in SSIS	6/12/2009
Update SQL Permissions using SMO	6/4/2009
Installing the SQL Server 2008 Data Mining Add-In for Excel	6/4/2009
Insert Statement Operators	5/26/2009
What is an Index Seek Operator?	5/25/2009
Altering a Certificate in SQL Server 2005 / 2008	5/20/2009
PIVOT using the CASE statement	5/18/2009
SQL Injection Explained	5/11/2009
Altering a Symmetric Key in SQL Server 2005 / 2008	5/5/2009
Create a Symmetric Key in SQL Server 2005 / 2008	5/5/2009
Replaying a SQL Server Profiler Trace	4/2/2009
Creating and Modifying Tables in SSMS	3/30/2009
Enabling C2 Auditing in SQL Server	3/25/2009
Using the DTA to Assist in Performance Tuning	3/24/2009
Customizing Stop Word and Stop Lists in Full Text Indexes	3/23/2009
Create an Asymmetric Key in SQL Server 2005 / 2008	3/23/2009