Title	When Watched
Filtering XML Elements using the Exist Method	12/31/2011
Secure FTP File Transfer in SSIS	12/16/2011
Inline Variable Initialization in SQL Server 2008	12/5/2011
SQL Server Authentication Modes	12/1/2011
Creating a Certificate in SQL Server 2005 / 2008	11/24/2011
Insert Statement Operators	11/24/2011
Update SQL Permissions using SMO	11/24/2011
Filtered Indexes in SQL Server 2008	11/24/2011
What is the Distinct Operator?	11/24/2011
Query Plans with Update Triggers	11/24/2011
Explaining The Properties Window in SQL Server Profiler	7/15/2011
Sparse Columns and Column Sets in SQL Server 2008	7/14/2011
Table Valued Parameters in SQL Server 2008	6/1/2011
Viewing SQL Server Indexes using SMO	4/28/2011
Using FOR XML with SQL Server	4/27/2011
Using a Script Transform in SSIS	3/27/2011
Running and Scheduling SSIS Packages	2/23/2011
Using the TSQL Checksum Function	1/28/2011
Using SET LANGUAGE	12/20/2010
Views, Indexed Views, and NOEXPAND	12/20/2010
Get the Name - Using the OBJECT_NAME Function	12/5/2010
Using SELECT to Generate SQL Commands	10/19/2010
Using Checkpoints in SSIS	10/6/2010
SET vs SELECT For Assigning Values to Variables	10/5/2010
Using WITH RECOMPILE With a Stored Procedure - Part 1	9/23/2010
Using Index Hints in a Query	9/6/2010
Forced Parameterization for Queries in a Database	8/27/2010
Dynamically Hiding SSRS Report Items	8/23/2010
Using WITH RECOMPILE With a Stored Procedure - Part 2	8/19/2010
SSIS Variables in Parent/Child Packages and Jobs	8/11/2010