Title	When Watched
What is the Spool Operator?	11/2/2011
Using OPENXML in SQL Server	3/15/2011
How to Create an ODBC DSN	2/9/2011
Converting a Text Data Type to an XML Data Type	9/24/2010
Exploring the Sys.Stats and Sys.StatColumns Tables	9/8/2010
Which Indexes Are Used By My Query?	9/7/2010
GUID or INT for Primary Key - A Mostly Unbiased Discussion	4/13/2010
SQL Server Data File Extensions	3/24/2010
Using a UDL File for Database Connectivity Testing	1/25/2010
Introduction to Filegroups And Adding A File to a FileGroup	12/3/2009
Filegroups and Adding a New Filegroup	12/3/2009
The Basics of Windows Services	10/27/2009
Creating Indexed Views	10/23/2009
Creating a Replication Subscription	10/23/2009
Using the Dedicated Admin Connection	10/15/2009
Configuring Network Settings for SQL Server	7/7/2009
Fixed DB Roles in SQL Server 2005	7/7/2009
What is the Distinct Operator?	6/25/2009
Adding a Windows Based Login to SQL Server	6/23/2009
Creating and Using Database Roles in SQL Server	6/23/2009
SQL Server Authentication Modes	6/23/2009
The Execution Plan for UNION	6/23/2009
Automatically Reviewing Your Code With VSTS	6/2/2009
Creating a Performance Counter Log	5/8/2009
Try Catch Blocks and Return Values within SMO	5/7/2009
What is the Group By Operator?	5/6/2009
The difference between GRANT, DENY and REVOKE in SQL Server	2/24/2009
What is a Scalar UDF?	1/29/2009
What is the Scalar Operator in a SQL Query Plan?	1/26/2009
Using the Tables Collection in SMO	1/19/2009