Title	When Watched
Using Indexes on Tables Variables in SQL Server	7/29/2009
SQL Server System Functions	6/19/2009
Filtered Indexes in SQL Server 2008	6/1/2009
What is the Spool Operator?	5/27/2009
Insert Statement Operators	5/27/2009
Composable DML in SQL Server 2008	5/19/2009
Unpivot Data with a Cross Join in SQL Server	5/15/2009
Unpivot Data Using the UNPIVOT Function in SQL Server	5/15/2009
PIVOT using the PIVOT statement	5/15/2009
Basic MERGE statements in SQL Server 2008	5/15/2009
PIVOT using the CASE statement	5/15/2009
What is an Index Seek Operator?	5/14/2009
Useful Sql Server Full Text Search System Views	5/12/2009
Try Catch Blocks and Return Values within SMO	5/7/2009
What is the Group By Operator?	5/6/2009
Introduction to the Reporting Services Design Environment	3/31/2009
Enabling C2 Auditing in SQL Server	3/25/2009
Using a UDF in a Computed Columns	3/23/2009
SQL Server Authentication Modes	3/16/2009
Using the TIMESTAMP data type in SQL Server	3/5/2009
Security Options for SQL Compact Database	2/4/2009
XP_cmdshell Execution in SQL Server 2005 / 2008	1/21/2009
Using the Tables Collection in SMO	1/19/2009
The Key Lookup Operator in SQL Server Query Plans	1/15/2009
The Execution Plan for TOP N	1/14/2009
Row Value Constructors in SQL Server 2008	12/15/2008
Using Checkpoints in SSIS	10/29/2008
Replaying a SQL Server Profiler Trace	10/29/2008
SQL Server Profiler Templates	10/29/2008
Reusing a Saved SQL Server Profiler trace	10/29/2008