Title	When Watched
Understanding Facts and Dimensions in SQL Server	10/27/2011
Adding Features in SQL Server 2008	9/13/2011
Compound Assignments in SQL Server 2008	7/29/2011
You Can't Do That with UDF's	7/13/2011
Quickly Creating XML Schemas in SQL Server 2005 / 2008	5/9/2011
Creating Primary Indexes on XML Data Types in SQL Server	4/22/2011
Managing the SSIS Service	3/14/2011
Running and Scheduling SSIS Packages	2/23/2011
Renaming a View - Part 1	2/14/2011
Setting A Database to Read Only	1/25/2011
Covering a Query That Includes an XML Column	12/29/2010
UNION and UNION ALL	12/2/2010
Using Indexes on Tables Variables in SQL Server	11/12/2010
Row Concatenation Using FOR XML PATH	11/11/2010
Joining Tables Part 1	9/17/2010
PIVOT using the CASE statement	8/13/2010
Except Operator	7/2/2010
Renaming a Database	3/10/2010
Using DB_ID and DB_Name Functions	3/5/2010
Using the Identity Function	2/16/2010
Error Handling in Transactions Using @@Error	1/15/2010
Adding a Time Stamp to a File Name in SSIS	1/12/2010
Using the StatsDate Function	1/8/2010
PIVOT using the PIVOT statement	1/5/2010
Unpivot Data Using the UNPIVOT Function in SQL Server	1/5/2010
How to Script Data in SQL2008	12/24/2009
How to Move Database Diagrams in SQL Server 2005-2008	12/22/2009
Tablediff - Compare Data in SQL Server Tables	12/16/2009
Copy Database Wizard - Using SMO	11/25/2009
SQL Server Error Logs	10/28/2009