Title	When Watched
Troubleshooting Failed Reporting Services Subscriptions	12/7/2011
Enumerate SQL Server Databases using SMO	12/7/2011
What is the Distinct Operator?	11/22/2011
Delete Statement Operators	8/22/2011
Multistatement UDF's in SQL Server	7/13/2011
Error Handling with UDF's	7/13/2011
Using a CTE to Update With An Aggregate Expression	6/16/2011
Filtered Indexes in SQL Server 2008	6/16/2011
Creating Hierarcies with HierarchyId in SQL Server 2008	6/16/2011
Composable DML in SQL Server 2008	6/16/2011
Using Column Sets with Sparse column in SQL Server 2008	6/16/2011
Basic MERGE statements in SQL Server 2008	6/16/2011
Performing Updates with Common Table Expressions (CTE)	6/16/2011
Using WITH RECOMPILE With a Stored Procedure - Part 1	11/18/2010
Which Indexes Are Used By My Query?	11/18/2010
What is the Scalar Operator in a SQL Query Plan?	11/18/2010
Introduction to Filegroups And Adding A File to a FileGroup	12/3/2009
Filegroups and Adding a New Filegroup	12/3/2009
Marking a Filegroup Read Only	12/3/2009
Exploring the Tablix’s Table Template in Reporting Services	8/14/2009
Creating an XML Data Source and Dataset in SSRS	8/14/2009
Row Concatenation Using FOR XML PATH	1/28/2009
What is a Hash Match Join Operator?	1/28/2009
Reusing a Saved SQL Server Profiler trace	1/28/2009
Quickly Creating XML Schemas in SQL Server 2005 / 2008	1/28/2009
The execution plan for UNION ALL	1/28/2009
Identifying Bad XML Data in Text Data Types	1/28/2009
Understanding RID Lookups in SQL Query Plans	1/28/2009
Rebuilding SQL Server Indexes Using SMO	1/28/2009
The Guest User in SQL Server	1/28/2009