Title	When Watched
Using Login Auditing in SQL Server	9/30/2010
Creating a Plan Guide for a Parameterized Statement	9/1/2010
GUID or INT for Primary Key - A Mostly Unbiased Discussion	7/28/2010
Forced Parameterization for Queries in a Database	7/28/2010
Using Variables in a SSIS Package	7/20/2010
Basic MERGE statements in SQL Server 2008	6/24/2010
The MERGE statement in SQL Server 2008	6/24/2010
What is a Merge Join Operator?	6/24/2010
Tooltips in Execution Plans	6/24/2010
What is the Scalar Operator in a SQL Query Plan?	6/24/2010
Execution Plan Operator Properties	6/24/2010
Solve Parameter Sniffing By Using Local Variables	6/24/2010
Retrieving a List of Reports from Reporting Services	5/13/2010
Building a Report Viewer Application - Part 1	5/13/2010
Viewing an Execution Plan	3/11/2010
What is a Nested Loop Join Operator?	3/11/2010
Multi Statement Query Plans	3/11/2010
Delete Statement Operators	3/11/2010
Advanced Foreign Key Configuration	3/11/2010
Working with Foreign Keys	3/11/2010
Computed Columns - Part 1	3/11/2010
Using DatePart and DateName	3/11/2010
PIVOT using the CASE statement	2/24/2010
Using Scope_Identity()	2/11/2010
Dynamic SQL Using sp_executesql	1/11/2010
Migrating From DTS to SSIS - Part 1	1/6/2010
Using TOP in Queries	1/6/2010
Tablediff - Compare Data in SQL Server Tables	12/16/2009
Generating a Graphical Query Plan	9/10/2009
SSIS Lookup Transform Basics	7/22/2009