Title	When Watched
Collections Explained	1/5/2012
Conditional SQL Server Backups with SMO	1/5/2012
Fixed DB Roles in SQL Server 2005	12/12/2011
Creating a Certificate in SQL Server 2005 / 2008	9/28/2011
Create a Symmetric Key in SQL Server 2005 / 2008	9/28/2011
Auditing your SQL Server Logins for Blank Passwords	9/12/2011
Dealing with Orphaned Users in SQL Server	9/12/2011
Performing Updates with Common Table Expressions (CTE)	6/16/2011
Using the Database Object in SMO	5/13/2011
Connecting to a SQL Server Database with SMO	5/13/2011
Finding Failed SQL Server Jobs with SMO	5/13/2011
Using OPENXML in SQL Server	5/13/2011
Capture Schema Changes with SMO	5/13/2011
Hacking SQL Server	4/12/2011
Using Checkpoints in SSIS	4/12/2011
Maintaining SQL Server 2005 Databases - Backups	4/12/2011
Automating SQL Express Backups	4/12/2011
Data Driven Text Color with Reporting Services	3/9/2011
Using ClearTrace to Analyze Profiler Results	3/4/2011
Reversing Deadlocking - Part 1	1/19/2011
How to Detect Deadlocking in SQL Server - Part 3	1/19/2011
How to Detect Deadlocking in SQL Server - Part 2	1/19/2011
How to Detect Deadlocking in SQL Server - Part 1	1/19/2011
How to Find Blocked Processes in SQL Server - Part 2	1/19/2011
How to Find Blocked Processes in SQL Server - Part 1	1/19/2011
SQL Server System Functions	12/30/2010
CONVERT - Changing a Date to a String	12/16/2010
Using CONVERT - String Literals to Date Data Types	12/16/2010
Creating and Using Linked Servers	11/18/2010
Installing the Adventureworks 2008R2 Sample Databases	11/18/2010