Title	When Watched
Expression Language Basics	2/21/2012
Using the RAND Function	2/21/2012
The Default Trace in SQL Server 2005	2/21/2012
Collections Explained	2/21/2012
Applied Fuzzy Lookup	2/20/2012
Use sp_MSForEachDB Instead of Your Own Loop	2/20/2012
Designing a KPI in Report Services	1/23/2012
Unpivot Data Using the UNPIVOT Function in SQL Server	12/16/2011
PIVOT using the PIVOT statement	12/16/2011
Automating SQL Express Backups	12/15/2011
How to Do a Split Backup in SQL Server	12/15/2011
Managing the Default DB and Language for a SQL Server Login	12/15/2011
Capturing Row Counts using Profiler	11/25/2011
Performing Updates with Common Table Expressions (CTE)	11/25/2011
What is the Spool Operator?	11/25/2011
Hacking SQL Server	11/15/2011
Using Indexes on Tables Variables in SQL Server	10/24/2011
Filtered Indexes in SQL Server 2008	10/24/2011
Using WITH RECOMPILE With a Stored Procedure - Part 2	10/4/2011
Using WITH RECOMPILE With a Stored Procedure - Part 1	10/4/2011
What is the Scalar Operator in a SQL Query Plan?	9/29/2011
SQL Server Properties to Avoid	9/29/2011
Handling Division by Zero with NULLIF	9/9/2011
Solve Parameter Sniffing by Using A Plan Guide	9/9/2011
How to Use the SQL Server 2008 Audit Object	8/26/2011
Enabling C2 Auditing in SQL Server	8/26/2011
Using Login Auditing in SQL Server	8/26/2011
Tooltips in Execution Plans	8/26/2011
Using the DTA to Assist in Performance Tuning	8/25/2011
Using OpenRowset	8/22/2011