Title	When Watched
Covering a Query That Includes an XML Column	4/9/2012
Using the KILL Statement	3/31/2012
Adding SQL Agent Operators Using TSQL	3/31/2012
Using the QUOTENAME Function	3/31/2012
Using Index Hints in a Query	3/30/2012
Clearing the Procedure Cache	3/30/2012
Controlling Plan Guides	3/30/2012
Using ASCII, CHAR, UNICODE, and NCHAR	3/30/2012
CONVERT - Changing a Date to a String	3/30/2012
Using sp_HelpText To View Object Defintions	3/30/2012
Bypassing Blocking using NOLOCK	3/30/2012
Views, Indexed Views, and NOEXPAND	3/30/2012
Blocking, SP_Who, and SysProcesses	3/30/2012
Renaming Views - Part 2	3/30/2012
Basic MERGE statements in SQL Server 2008	3/29/2012
Query Hints for Unions - CONCAT UNION, HASH UNION, and MERGE UNION	3/29/2012
Forcing Query Plans to use LOOP, MERGE, and HASH Joins	3/29/2012
Using LOOP, MERGE, and HASH Join Hints	3/29/2012
Performing Updates with Common Table Expressions (CTE)	3/29/2012
Using a CTE to Update With An Aggregate Expression	3/29/2012
Introduction to Common Table Expressions	3/29/2012
Techniques for Deploying SSIS Packages	3/29/2012
Secure FTP File Transfer in SSIS	3/28/2012
Using ClearTrace to Analyze Profiler Results	3/28/2012
Adding Users and Setting Permissions in Reporting Services	3/28/2012
Capturing Row Counts using Profiler	3/28/2012
Adding a Custom Subject Line to a Data Driven Subscription	3/28/2012
Troubleshooting Failed Reporting Services Subscriptions	3/28/2012
Handling NULL Values in SSIS Using The Conditional Split Transformation	3/28/2012
Breakpoints in SSIS	3/28/2012