Title	When Watched
PIVOT using the PIVOT statement	8/12/2011
Performing Updates with Common Table Expressions (CTE)	6/17/2011
Using OpenRowset	2/17/2011
More on Instead of Triggers	1/21/2011
Using Database DDL Triggers	1/21/2011
Using a Server Trigger to Dropping a Database	1/21/2011
Using Column Sets with Sparse column in SQL Server 2008	1/21/2011
Query Plans with Update Triggers	1/21/2011
Introduction to Instead of Triggers	1/21/2011
DBCC InputBuffer - Seeing the Last Executed Command	1/20/2011
Using SET LANGUAGE	1/20/2011
Using the SPACE and REPLICATE String Functions	1/20/2011
Running Jobs Based on Alerts	1/20/2011
Configuring Agent Operators	1/20/2011
Adding SQL Agent Operators Using TSQL	1/20/2011
What is a Scalar UDF?	1/3/2011
Using a UDF in a Computed Columns	1/3/2011
Error Handling with UDF's	1/3/2011
Inline UDF's in SQL Server	1/3/2011
Connecting to SQL Azure Using Various Tools	1/3/2011
Using a UDL File for Database Connectivity Testing	1/3/2011
Understanding the Two Digit Year Cutoff in SQL Server	12/14/2010
Using CONVERT - String Literals to Date Data Types	12/13/2010
Using CAST to Change Data Types	12/10/2010
Using TOP in Queries	12/10/2010
Indexed Views and the NOEXPAND Hint	12/8/2010
Get The Definition of a SQL Object Using Object_Definition	12/8/2010
Using sp_HelpText To View Object Defintions	12/8/2010
Getting Good Performance using SOUNDEX	12/7/2010
Use sp_MSForEachDB Instead of Your Own Loop	12/7/2010