Title	When Watched
Using Column Sets with Sparse column in SQL Server 2008	1/26/2011
Row Concatenation Using FOR XML PATH	11/17/2010
Adding and Removing Columns from SQL Server Profiler	4/27/2010
An Introduction to Check Constraints	4/27/2010
SQL Server Login vs Windows Authenticated Logins	2/8/2010
How to Recover From Being Locked Out of a SQL Server 2005 database	2/8/2010
SysAdmin vs DBO vs DB Owner in SQL Server	2/7/2010
XP_cmdshell Execution in SQL Server 2005 / 2008	2/6/2010
Hacking SQL Server	2/5/2010
Tablediff - Compare Data in SQL Server Tables	2/5/2010
Error Handling in Transactions using SET XACT_ABORT	2/5/2010
Using OpenDataSource to Access Remote Data	2/5/2010
Using @@Version and xp_MSVer to Get Your SQL Version	2/5/2010
Using the Identity Function	2/5/2010
Dynamic SQL Using sp_executesql	2/4/2010
Using the StatsDate Function	2/4/2010
Using sp_autostats	2/4/2010
How to Move Database Diagrams in SQL Server 2005-2008	2/4/2010
How to Script Data in SQL2008	2/4/2010
Statistics & Using DBCC Show_Statistics	2/4/2010
Understanding DBCC Show_Statistics	2/4/2010
The Execution Plan for UNION	12/2/2009
Basic MERGE statements in SQL Server 2008	7/14/2009
Using Indexes on Tables Variables in SQL Server	7/14/2009
Filtered Indexes in SQL Server 2008	7/14/2009
Sparse Columns in SQL Server 2008	7/14/2009
Creating Hierarcies with HierarchyId in SQL Server 2008	7/13/2009
Manipulating Hierarchies with HIERARCHYID	7/13/2009
Solve Parameter Sniffing by using RECOMPILE	7/10/2009
Solve Parameter Sniffing By Using OPTIMIZE FOR	7/10/2009