Title	When Watched
PIVOT using the PIVOT statement	2/5/2012
Splitting Delimited Strings	1/16/2012
Quickly Creating XML Schemas in SQL Server 2005 / 2008	1/16/2012
Introduction to SQL Server XML Schemas, Part 1	1/16/2012
Converting a Text Data Type to an XML Data Type	1/16/2012
SQL Server 2005 / 2008 XML Data Type	1/16/2012
Identifying Bad XML Data in Text Data Types	1/16/2012
Using OPENXML in SQL Server	1/16/2012
Introduction to SQL Server XML Schemas, Part 2	1/16/2012
Using FOR XML with SQL Server	1/16/2012
Creating a Basic SSAS Cube	12/31/2011
Using a Script Transform in SSIS	12/31/2011
Speak Like a SSIS Developer	12/31/2011
SSIS Control Flow Basics	12/31/2011
Saving a Trace Definition in SQL Server Profiler	12/29/2011
Inline UDF's in SQL Server	12/29/2011
Understanding SQL Server Securables	12/29/2011
Sparse Columns in SQL Server 2008	12/29/2011
Allowing Users to Execute Traces in SQL Server	12/29/2011
Creating a Database User in SQL Server	12/29/2011
Using the TIMESTAMP data type in SQL Server	12/29/2011
Manipulating Hierarchies with HIERARCHYID	12/29/2011
Creating a Database Diagram in SSMS	12/29/2011
Using the TSQL Checksum Function	12/29/2011
Installing SQL Server 2008 Sample Databases	12/29/2011
Solve Parameter Sniffing by Using OPTION RECOMPILE	12/9/2011
Creating and Modifying Tables in SSMS	11/12/2011
Using Column Sets with Sparse column in SQL Server 2008	11/12/2011
Creating Hierarcies with HierarchyId in SQL Server 2008	11/12/2011
Compound Assignments in SQL Server 2008	11/12/2011