| 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 |