Title	Published Date
SQL Server 2005 / 2008 XML Data Type	10/13/2008
Using FOR XML with SQL Server	10/13/2008
Introduction to SQL Server XML Schemas, Part 1	10/13/2008
Introduction to SQL Server XML Schemas, Part 2	10/13/2008
Using OPENXML in SQL Server	10/13/2008
Quickly Creating XML Schemas in SQL Server 2005 / 2008	10/13/2008
Converting a Text Data Type to an XML Data Type	10/13/2008
Identifying Bad XML Data in Text Data Types	10/13/2008
Creating Primary Indexes on XML Data Types in SQL Server	10/13/2008

Title	When Watched
Unpivot Data with a Cross Join in SQL Server	8/30/2011
SSIS Configurations	4/7/2011
SSIS Control Flow Basics	4/7/2011
Expression Language Basics	11/21/2010
Using the QUOTENAME Function	11/1/2010
Understanding SQL Server Securables	10/19/2010
How to Detect Deadlocking in SQL Server - Part 1	4/19/2010
Using sp_repldone To Mark All Pending Transactions as Replicated.	3/31/2010
Configure Replication Agents to Log to Output Files	2/24/2010
Decrease Replication Latency By Configuring Batches	2/24/2010
Error Handling in Transactions using SET XACT_ABORT	1/19/2010
Creating and Using Linked Servers	9/29/2009
Using FOR XML with SQL Server	10/15/2008
XML Execution Plans	9/24/2008
Text Query Plans	9/24/2008
Applied Fuzzy Lookup	9/24/2008
Introduction to SQL Server Management Studio	9/24/2008
Using the For Each ADO Enumerator	9/24/2008
Creating a Database with SMO	9/24/2008
Using Database DDL Triggers	9/24/2008
SQL Server Table Scans	9/24/2008