Title	When Watched
What is the Distinct Operator?	11/22/2011
Creating a Certificate in SQL Server 2005 / 2008	11/15/2011
Introduction to SQL Server XML Schemas, Part 1	5/18/2011
What is an Identity Gap?	4/26/2011
Capture Schema Changes with SMO	4/6/2011
How to Create an ODBC DSN	2/9/2011
Using Column Sets with Sparse column in SQL Server 2008	1/26/2011
Adding SQL Agent Operators Using TSQL	1/20/2011
Bypassing Blocking using NOLOCK	1/19/2011
Blocking, SP_Who, and SysProcesses	1/10/2011
Views, Indexed Views, and NOEXPAND	12/20/2010
Using DatePart and DateName	12/17/2010
Using TOP in Queries	12/10/2010
Using sp_HelpText To View Object Defintions	12/7/2010
The MERGE statement in SQL Server 2008	11/10/2010
Using the QUOTENAME Function	11/1/2010
PIVOT using the CASE statement	8/13/2010
Understanding Facts and Dimensions in SQL Server	8/9/2010
Creating Hierarcies with HierarchyId in SQL Server 2008	9/18/2009
Generating a Graphical Query Plan	9/8/2009
How to Detect Deadlocking in SQL Server - Part 3	8/20/2009
How to Detect Deadlocking in SQL Server - Part 2	8/20/2009
How to Detect Deadlocking in SQL Server - Part 1	8/20/2009
Shredding XML Elements with the Xquery Value Function	8/20/2009
Creating an XML Data Source and Dataset in SSRS	8/11/2009
Conditional SQL Server Backups with SMO	8/7/2009
Introduction to the Reporting Services Design Environment	7/30/2009
Creating a Reporting Services Solution, Project, and Report	7/30/2009
Creating a SQL Server Data Source and Dataset in SSRS	7/30/2009
Understanding SQL Server Securables	7/28/2009