Title	When Watched
Shredding XML Attributes with the Xquery Value function	3/11/2012
Filtering XML Elements using the Exist Method	3/11/2012
Shredding XML Elements with the Xquery Value Function	3/11/2012
Shredding XML Elements with the Xquery Query Function	3/11/2012
Handling Division by Zero with NULLIF	3/6/2012
Filtered Indexes in SQL Server 2008	3/6/2012
Preventing SQL Injection With String Filtering	3/6/2012
Error Handling in Transactions Using @@Error	3/6/2012
An Introduction to Check Constraints	3/6/2012
Use sp_MSForEachDB Instead of Your Own Loop	3/6/2012
Applied Fuzzy Lookup	2/17/2012
Using the Fuzzy Lookup Transform	2/17/2012
SSIS Lookup Transform - Lookup Failures	2/17/2012
SSIS Lookup Transform Basics	2/17/2012
Reporting Services Formatting Codes	1/23/2012
Creating an XML Data Source and Dataset in SSRS	1/7/2012
Inline Variable Initialization in SQL Server 2008	10/23/2011
Creating and Using Database Roles in SQL Server	10/23/2011
Unpivot Data with a Cross Join in SQL Server	9/5/2011
Creating a SQL Server 2005 / 2008 Master Key	9/5/2011
Error Handling with UDF's	8/17/2011
Data Access with Scalar UDF's	8/17/2011
Using a UDF in a Computed Columns	8/17/2011
What is a Scalar UDF?	8/14/2011
Converting a Text Data Type to an XML Data Type	8/12/2011
Customizing Stop Word and Stop Lists in Full Text Indexes	8/12/2011
PIVOT using the PIVOT statement	8/12/2011
User Defined Function Tips	8/2/2011
Data Driven Text Color with Reporting Services	7/29/2011
Parameterizing the Execute SQL Task in SSIS	6/26/2011