Title	When Watched
Introduction to Statistics	12/9/2009
Introduction to Filegroups And Adding A File to a FileGroup	12/2/2009
Introduction to Common Table Expressions	11/4/2009
Performing Updates with Common Table Expressions (CTE)	10/22/2009
PIVOT using the PIVOT statement	10/22/2009
Handling Division by Zero with NULLIF	10/22/2009
Sparse Columns in SQL Server 2008	10/22/2009
Basic MERGE statements in SQL Server 2008	10/22/2009
PIVOT using the CASE statement	10/22/2009
Enumerate SQL Server Databases using SMO	10/22/2009
Using the Tables Collection in SMO	10/22/2009
SSIS Lookup Transform - Lookup Failures	10/22/2009
Expression Language Basics	10/22/2009
Creating an SMO Dashboard Part 2	10/22/2009
Creating an SMO Dashboard - Part 1	10/22/2009
Capture Schema Changes with SMO	10/22/2009
Collections Explained	10/22/2009
Create Database Objects with SMO	10/22/2009
Creating a Database with SMO	10/22/2009
Connecting to a SQL Server Database with SMO	10/22/2009
SSIS Lookup Transform Basics	10/22/2009
Speak Like a SSIS Developer	10/22/2009
Solve Parameter Sniffing by using RECOMPILE	7/8/2009
Creating and Using Database Roles in SQL Server	6/2/2009
Insert Statement Operators	5/26/2009
Multistatement UDF's in SQL Server	5/25/2009
What is the Spool Operator?	5/25/2009
What is the Count Operator?	5/18/2009
SQL Injection Explained	5/11/2009
Try Catch Blocks and Return Values within SMO	5/7/2009

SSIS

SSAS

SQL server

SSRS

DWH

SMO

TSQL

BI