Title	When Watched
Querying Full Text Indexes Using the FormsOf method	1/4/2012
Execution Plan Operator Properties	9/20/2011
Reversing Deadlocking - Part 1	9/19/2011
PIVOT using the PIVOT statement	8/16/2011
Unpivot Data Using the UNPIVOT Function in SQL Server	5/18/2011
Using OPENXML in SQL Server	5/18/2011
Introduction to SQL Server XML Schemas, Part 1	5/18/2011
Secure FTP File Transfer in SSIS	12/1/2010
Performing Updates with Common Table Expressions (CTE)	11/9/2010
Multistatement UDF's in SQL Server	11/3/2010
Using the FORCE ORDER Query Hint	11/3/2010
Aggregrate Queries in SQL Server T-SQL for Beginners	11/3/2010
Using the FORCESEEK Query Hint	11/3/2010
Using ASCII, CHAR, UNICODE, and NCHAR	11/3/2010
Using the QUOTENAME Function	11/3/2010
Using the STR Function	11/3/2010
Using SOUNDEX and DIFFERENCE	11/3/2010
Applied Fuzzy Lookup	9/29/2010
Using the Fuzzy Lookup Transform	9/29/2010
Change Data Capture with SSIS	8/19/2010
Techniques for Deploying SSIS Packages	7/23/2010
Looping Through and Loading Files with SSIS	6/11/2010
Creating a SQL Server Data Source and Dataset in SSRS	5/28/2010
Using TableDirect with SQL Compact	5/26/2010
Using the @@Rowcount Function	5/12/2010
Using Scope_Identity()	5/12/2010
Using @@ServerName and ServerProperty	5/12/2010
Using the ServerProperty Function	5/12/2010
Using the DatabasePropertyEx Function	5/12/2010
Generating a Graphical Query Plan	5/12/2010