Title	When Watched
Sparse Columns and Column Sets in SQL Server 2008	9/13/2012
Using Column Sets with Sparse column in SQL Server 2008	9/13/2012
Execution Plan Operator Properties	9/20/2011
Using the Fuzzy Lookup Transform	4/11/2011
Views, Indexed Views, and NOEXPAND	4/7/2011
A Quick Look at View Expansion	4/7/2011
Using sp_HelpText To View Object Defintions	4/7/2011
Speak Like a SSIS Developer	4/1/2011
Blocking, SP_Who, and SysProcesses	1/25/2011
Bypassing Blocking using NOLOCK	1/25/2011
Setting A Database to Read Only	1/25/2011
Expression Language Basics	11/18/2010
How to Use the SQL Server 2008 Audit Object	10/25/2010
Using Login Auditing in SQL Server	10/25/2010
String Handling Functions - Part 4	10/15/2010
Understanding SQL Server Securables	9/17/2010
Listing Files in a Backup File/Device	9/15/2010
Differential Backup and Restore of a SQL Server Database (Full Recovery)	9/15/2010
How To Restore Using a Differential Backup & TSQL	9/15/2010
Using the OPTION HASH GROUP and OPTION ORDER GROUP Query Hints	9/15/2010
Which Indexes Are Used By My Query?	9/14/2010
Query Hints for Unions - CONCAT UNION, HASH UNION, and MERGE UNION	9/14/2010
Practice Your Restore Skills	8/27/2010
Forced Parameterization for Queries in a Database	8/27/2010
Explaining The Properties Window in SQL Server Profiler	8/24/2010
Introduction to the Reporting Services Design Environment	7/15/2010
How to Script Data in SQL2008	7/15/2010
How to Detect Deadlocking in SQL Server - Part 1	7/15/2010
How to do a Copy Only Backup of a SQL Server Database	7/15/2010
Building a Report Viewer Application - Part 1	6/29/2010