Title	When Watched
Creating Hierarcies with HierarchyId in SQL Server 2008	8/13/2011
Creating and Using Linked Servers	7/27/2011
Preventing SQL Injection With String Filtering	6/29/2011
SQL Server Properties to Avoid	6/29/2011
Query Hints for Unions - CONCAT UNION, HASH UNION, and MERGE UNION	6/24/2011
Using the KILL Statement	6/24/2011
Perfmon Tips - Loading a Log File, Saving an Image, and Zooming	6/24/2011
How to Backup the Transaction Log of a SQL Server Database	6/22/2011
SQL Server Login vs Windows Authenticated Logins	6/22/2011
Aggregrate Queries in SQL Server T-SQL for Beginners	6/21/2011
Handling Division by Zero with NULLIF	6/14/2011
Filtering XML Elements using the Exist Method	6/14/2011
Composable DML in SQL Server 2008	6/14/2011
Using Column Sets with Sparse column in SQL Server 2008	6/14/2011
Using Indexes on Tables Variables in SQL Server	6/14/2011
Joining Tables Part 1	6/13/2011
Writing Simple Select Statements - Part 3	6/13/2011
Writing Simple Select Statements - Part 2	6/13/2011
Writing Simple Select Statements	6/13/2011
Speak Like a T-SQL Developer	6/13/2011
Modifying Data in T-SQL	6/13/2011
Renaming Views - Part 2	6/13/2011
Renaming a View - Part 1	6/13/2011
Detecting Deadlocks with SQL Server Profiler	6/13/2011
Using FOR XML with SQL Server	6/10/2011
The Guest User in SQL Server	6/7/2011
Shredding XML Elements with the Xquery Query Function	6/4/2011
Using OPENXML in SQL Server	6/4/2011
Row Concatenation Using FOR XML PATH	6/4/2011
Using OpenRowset	6/3/2011