Title	When Watched
Monitoring Exec Cache in SQL Server - Part 1	12/20/2011
User Defined Functions Metadata	12/10/2011
Using Client Statistics	12/6/2011
Creating SQL Server Jobs with SMO	11/28/2011
What is the Distinct Operator?	11/22/2011
Creating and Using Database Roles in SQL Server	10/24/2011
Error Handling with UDF's	9/23/2011
Unpivot Data with a Cross Join in SQL Server	8/30/2011
Create an Asymmetric Key in SQL Server 2005 / 2008	8/17/2011
SQL Server Mixed Mode in SMO	8/5/2011
User Defined Function Tips	8/2/2011
Reversing Deadlocking - Part 3	7/25/2011
Sparse Columns and Column Sets in SQL Server 2008	7/13/2011
Setting Deadlock Priority	7/7/2011
Hacking SQL Server	6/27/2011
Preventing SQL Injection With String Filtering	6/27/2011
Performing Updates with Common Table Expressions (CTE)	6/16/2011
Using the TSQL Checksum Function	6/15/2011
Using Indexes on Tables Variables in SQL Server	6/14/2011
Security for SQL Agent Job Execution	6/10/2011
Adding a Custom Subject Line to a Data Driven Subscription	3/11/2011
Tablediff - Compare Data in SQL Server Tables	3/10/2011
Using Column Sets with Sparse column in SQL Server 2008	1/27/2011
SP_Who & SP_Who2	1/6/2011
Using the Sysprocesses View	1/6/2011
Using Scope_Identity()	1/5/2011
DBCC InputBuffer - Seeing the Last Executed Command	12/29/2010
Using SOUNDEX and DIFFERENCE	11/3/2010
Sparse Columns in SQL Server 2008	10/29/2010
Speak Like a SSIS Developer	12/26/2008