Title	When Watched
Using the Identity Function	2/5/2010
Using the @@Rowcount Function	1/28/2010
Error Handling in Transactions with Begin Try	1/20/2010
Using a CTE to Update With An Aggregate Expression	12/20/2009
Using Hashbytes in SQL Server 2005 / 2008	8/17/2009
What is the Distinct Operator?	6/30/2009
Enumerate SQL Server Databases using SMO	6/30/2009
Creating and Using Database Roles in SQL Server	6/6/2009
Update SQL Permissions using SMO	6/6/2009
Inline Variable Initialization in SQL Server 2008	5/29/2009
What is the Group By Operator?	5/8/2009
Try Catch Blocks and Return Values within SMO	5/8/2009
Generating SQL Server Scripts using SMO	11/14/2008
Create SQL Server Logins with SMO	10/31/2008
Viewing SQL Server Indexes using SMO	10/29/2008
Create Database Objects with SMO	10/23/2008
What is a Clustered Index Scan?	10/23/2008
What is an Identity Gap?	10/23/2008
SQL Server 2005 / 2008 XML Data Type	10/16/2008
What is a Merge Join Operator?	10/16/2008