Title	When Watched
Collections Explained	1/26/2012
What is the Spool Operator?	11/2/2011
SQL Server System Functions	10/28/2011
Creating and Using Database Roles in SQL Server	10/19/2011
Inline Variable Initialization in SQL Server 2008	10/18/2011
Handling Division by Zero with NULLIF	9/7/2011
Create an Asymmetric Key in SQL Server 2005 / 2008	8/16/2011
Using the DTA to Assist in Performance Tuning	8/15/2011
Using the TIMESTAMP data type in SQL Server	8/1/2011
Compound Assignments in SQL Server 2008	7/29/2011
Data Driven Text Color with Reporting Services	7/18/2011
XP_cmdshell Execution in SQL Server 2005 / 2008	6/28/2011
Using the TSQL Checksum Function	6/15/2011
Creating a Basic SSAS Cube	6/15/2011
Using Indexes on Tables Variables in SQL Server	6/14/2011
Rebuilding SQL Server Indexes Using SMO	6/3/2011
Unpivot Data Using the UNPIVOT Function in SQL Server	5/16/2011
Viewing SQL Server Indexes using SMO	4/28/2011
Using Checkpoints in SSIS	4/13/2011
Using SELECT to Concatenate Strings Across Rows	11/23/2010
Using the RAND Function	11/23/2010
Options for Displaying Query Results in SSMS	11/18/2010
Using the STUFF Function	11/17/2010
Retrieve Table and Indexes Sizes in SMO	11/12/2010
Row Concatenation Using FOR XML PATH	11/11/2010
Performing Updates with Common Table Expressions (CTE)	11/9/2010
Using the STR Function	11/3/2010
Using the QUOTENAME Function	11/1/2010
Sparse Columns in SQL Server 2008	10/29/2010
Using ASCII, CHAR, UNICODE, and NCHAR	10/27/2010