Title	When Watched
How to Use the SQL Server 2008 Audit Object	12/21/2010
Indexed Views and the NOEXPAND Hint	12/10/2010
Using TOP in Queries	12/10/2010
Create SQL Server Logins with SMO	11/16/2010
Using the STUFF Function	11/10/2010
Performing Updates with Common Table Expressions (CTE)	11/10/2010
Basic MERGE statements in SQL Server 2008	11/10/2010
Using SOUNDEX and DIFFERENCE	11/3/2010
Using the OPTION FAST Query Hint	9/13/2010
Exploring the Sys.Stats and Sys.StatColumns Tables	9/8/2010
Using Index Hints in a Query	9/2/2010
Creating a Plan Guide for a Parameterized Statement	9/1/2010
Introduction to Plan Caching and SysCacheObjects	8/19/2010
Understanding Facts and Dimensions in SQL Server	8/9/2010
Forced Parameterization for Queries in a Database	7/28/2010
Using Variables in a SSIS Package	7/19/2010
How to Backup a SQL Server Database	7/8/2010
Understanding Recovery Models	7/7/2010
Configuring Network Settings for SQL Server	6/25/2010
Solve Parameter Sniffing By Using Local Variables	6/24/2010
Reporting Service Subscriptions & The DBA	5/26/2010
Performance Tuning Quiz #3 - Part 1	5/25/2010
Introduction to SQL Azure	5/19/2010
Performance Tuning Quiz #2 - Part 1	5/18/2010
Performance Tuning Puzzle - Part 2	5/5/2010
Performance Tuning Quiz - Part 3	5/5/2010
Adding and Removing Columns from SQL Server Profiler	4/26/2010
How to Detect Deadlocking in SQL Server - Part 1	4/19/2010
GUID or INT for Primary Key - A Mostly Unbiased Discussion	4/12/2010
NewID vs NewSequentialID - Understanding Your UniqueIdentifier Options	4/9/2010