Title	When Watched
SSIS Lookup Transform Basics	12/27/2011
Creating a SQL Server Data Source and Dataset in SSRS	12/27/2011
Understanding SQL Server Securables	12/22/2011
Converting a Text Data Type to an XML Data Type	11/29/2011
Formatting SSAS Measures	11/14/2011
Creating a Certificate in SQL Server 2005 / 2008	10/27/2011
SQL Injection Explained	10/3/2011
Using a UDF in a Computed Columns	8/17/2011
Reversing Deadlocking - Part 3	7/25/2011
PIVOT using the PIVOT statement	5/19/2011
Creating a Basic SSAS Cube	5/18/2011
Unpivot Data Using the UNPIVOT Function in SQL Server	5/18/2011
Using the TSQL Convert Function	12/27/2010
CONVERT - Changing a Date to a String	12/14/2010
Creating a Computed Column as a DATE Data Type	12/6/2010
UNION and UNION ALL	12/2/2010
Using the USE Statement	11/16/2010
The MERGE statement in SQL Server 2008	11/10/2010
Performing Updates with Common Table Expressions (CTE)	11/9/2010
Using the STR Function	11/3/2010
Using SELECT to Generate SQL Commands	10/19/2010
String Handling Functions - Part 5	10/14/2010
String Handling Functions - Part 3	10/13/2010
Capturing Row Counts using Profiler	10/6/2010
SET vs SELECT For Assigning Values to Variables	10/5/2010
Introduction to the CASE Expression	10/4/2010
Using IF and ELSE in TSQL - The Basics of Conditional Logic	9/30/2010
Aggregrate Queries in SQL Server T-SQL for Beginners	9/30/2010
Using Login Auditing in SQL Server	9/28/2010
Query Hints for Unions - CONCAT UNION, HASH UNION, and MERGE UNION	9/14/2010