Title	When Watched
Solve Parameter Sniffing by Using OPTION RECOMPILE	12/9/2011
User Defined Functions Metadata	12/9/2011
Enumerate SQL Server Databases using SMO	12/7/2011
Query Plans with Update Triggers	11/23/2011
Filtered Indexes in SQL Server 2008	10/21/2011
Formatting SSAS Measures	10/17/2011
Handling Division by Zero with NULLIF	9/7/2011
Installing SQL Server 2008 Sample Databases	7/26/2011
Reversing Deadlocking - Part 3	7/26/2011
Basic MERGE statements in SQL Server 2008	7/20/2011
Implementing Hyperlinks in Reporting Services	7/6/2011
Transparent Data Encryption in SQL Server 2008	7/5/2011
Renaming a View - Part 1	2/14/2011
Using Column Sets with Sparse column in SQL Server 2008	1/21/2011
Introduction to Instead of Triggers	1/21/2011
Bypassing Blocking using NOLOCK	1/19/2011
Using Scope_Identity()	1/12/2011
Using SET LANGUAGE	12/16/2010
SSIS Stumpers V1 - Unpivot Example	11/12/2010
SSIS For Loop Container	11/12/2010
Using Variables in a SSIS Package	7/22/2010
Inline Variable Initialization in SQL Server 2008	5/29/2009
Create an Asymmetric Key in SQL Server 2005 / 2008	3/20/2009
What is a Merge Join Operator?	1/8/2009