Title	When Watched
Understanding SQL Server Securables	12/22/2011
Creating SQL Server Jobs with SMO	11/28/2011
SQL Injection Explained	10/3/2011
Altering a SQL Server Database Master Key	9/21/2011
Dealing with Orphaned Users in SQL Server	9/12/2011
PIVOT using the PIVOT statement	8/12/2011
Converting a Text Data Type to an XML Data Type	8/10/2011
Basic MERGE statements in SQL Server 2008	7/20/2011
Bypassing Blocking using NOLOCK	7/19/2011
Adding a Custom Subject Line to a Data Driven Subscription	7/19/2011
XP_cmdshell Execution in SQL Server 2005 / 2008	6/28/2011
Parameterizing the Execute SQL Task in SSIS	6/23/2011
Performing Updates with Common Table Expressions (CTE)	6/16/2011
Using Indexes on Tables Variables in SQL Server	6/14/2011
Row Value Constructors in SQL Server 2008	5/27/2011
Unpivot Data Using the UNPIVOT Function in SQL Server	5/16/2011
Using OPENXML in SQL Server	5/13/2011
Using the Database Object in SMO	5/13/2011
Generating SQL Server Scripts using SMO	5/5/2011
Row Concatenation Using FOR XML PATH	5/4/2011
Identifying Bad XML Data in Text Data Types	5/3/2011
Creating Primary Indexes on XML Data Types in SQL Server	5/3/2011
Viewing SQL Server Indexes using SMO	4/28/2011
Reading the SQL Server Error Log with SMO	4/28/2011
What is an Identity Gap?	4/28/2011
Using FOR XML with SQL Server	4/28/2011
Using the For Each ADO Enumerator	4/11/2011
Using Database DDL Triggers	4/7/2011
User Defined Functions Metadata	3/22/2011
Troubleshooting Failed Reporting Services Subscriptions	3/15/2011