Title	When Watched
Filtering XML Elements using the Exist Method	12/28/2011
Handling Division by Zero with NULLIF	9/7/2011
Creating a Database Diagram in SSMS	8/23/2011
Converting a Text Data Type to an XML Data Type	8/10/2011
Unpivot Data Using the UNPIVOT Function in SQL Server	5/16/2011
Quickly Creating XML Schemas in SQL Server 2005 / 2008	5/9/2011
Viewing SQL Server Indexes using SMO	4/28/2011
Using FOR XML with SQL Server	4/27/2011
Identifying Bad XML Data in Text Data Types	4/25/2011
Row Concatenation Using FOR XML PATH	4/22/2011
Using the For Each ADO Enumerator	3/24/2011
Introduction to SQL Server XML Schemas, Part 1	3/15/2011
Using OPENXML in SQL Server	3/15/2011
Tablediff - Compare Data in SQL Server Tables	3/8/2011
Covering a Query That Includes an XML Column	12/28/2010
Using the QUOTENAME Function	11/1/2010
Using ASCII, CHAR, UNICODE, and NCHAR	10/27/2010
Using LOOP, MERGE, and HASH Join Hints	9/22/2010
SQL Azure - Adding and Dropping Databases	6/24/2010
Firewall Configuration for SQL Azure	6/14/2010
Connecting to a SQL Compact Database	5/13/2010
Overview of Data Driven Subscriptions in Reporting Services	3/15/2010
Using TOP in Queries	1/7/2010
How to Script Data in SQL2008	12/24/2009
Introduction to Statistics	12/10/2009
Speak Like a SSIS Developer	8/29/2009
Shredding XML Elements with the Xquery Value Function	8/29/2009
Windows and SQL Server 2005 Clustering Architecture	5/15/2009
PIVOT using the CASE statement	5/15/2009