Title	When Watched
Inline UDF's in SQL Server	9/8/2011
Inline Variable Initialization in SQL Server 2008	9/7/2011
Composable DML in SQL Server 2008	9/7/2011
Compound Assignments in SQL Server 2008	9/7/2011
Using Column Sets with Sparse column in SQL Server 2008	9/7/2011
Handling Division by Zero with NULLIF	9/7/2011
Unpivot Data Using the UNPIVOT Function in SQL Server	8/12/2011
PIVOT using the PIVOT statement	8/12/2011
SQL Server Authentication Modes	8/10/2011
Using the TIMESTAMP data type in SQL Server	8/1/2011
Basic MERGE statements in SQL Server 2008	7/20/2011
Implementing Hyperlinks in Reporting Services	7/6/2011
Configuring Agent Operators	6/29/2011
Use sp_MSForEachDB Instead of Your Own Loop	6/29/2011
Using OpenRowset	6/29/2011
Creating and Using Linked Servers	6/29/2011
SQL Server Data File Extensions	6/29/2011
Rebuilding SQL Server Indexes Using SMO	6/3/2011
Creating Hierarcies with HierarchyId in SQL Server 2008	1/26/2011
Hacking SQL Server	8/26/2010
How to Script SQL Objects	8/17/2010
Putting Databases Into Single User Mode	8/17/2010
Using SP_Configure	8/17/2010
Introduction to Instead of Triggers	8/17/2010
Working with Foreign Keys	8/17/2010
Computed Columns - Part 2	8/17/2010
Computed Columns - Part 1	8/17/2010
Introduction to Plan Caching and SysCacheObjects	8/17/2010