Title	When Watched
How to Restore a SQL Server Database	7/9/2010
How to Backup a SQL Server Database	7/9/2010
Introduction to SQL Azure	5/19/2010
Performance Tuning Quiz #2 - Part 1	5/18/2010
Generating a Graphical Query Plan	5/13/2010
Performance Tuning Puzzle - Part 2	5/1/2010
Performance Tuning Puzzle - Part 1	5/1/2010
Using sp_autostats	1/4/2010
Statistics & Query Optimization	12/23/2009
Introduction to SQL Jobs	11/6/2009
Using Client Statistics	7/1/2009
The Execution Plan for UNION	6/23/2009
Converting a Text Data Type to an XML Data Type	6/19/2009
Query Plans with Update Triggers	6/15/2009
Creating and Using Database Roles in SQL Server	6/2/2009
Composable DML in SQL Server 2008	5/20/2009
PIVOT using the CASE statement	5/15/2009
SQL Injection Explained	5/11/2009
Try Catch Blocks and Return Values within SMO	5/7/2009
Error Handling with UDF's	5/4/2009
How to Find Blocked Processes in SQL Server - Part 2	4/30/2009
How to Find Blocked Processes in SQL Server - Part 1	4/29/2009
Execution Plan Operator Properties	4/24/2009
Solve Parameter Sniffing By Using OPTIMIZE FOR	4/23/2009
Sparse Columns and Column Sets in SQL Server 2008	4/19/2009
Create an Asymmetric Key in SQL Server 2005 / 2008	3/20/2009
Using the DTA to Assist in Performance Tuning	3/19/2009
What are the Statistics IO?	3/12/2009
SQL Server Mixed Mode in SMO	3/11/2009
Using Login Auditing in SQL Server	3/10/2009