Title	When Watched
Dynamic SQL Using sp_executesql	1/11/2010
Using the StatsDate Function	1/8/2010
Statistics Based on Indexes	12/12/2009
Introduction to Statistics	12/12/2009
Copy Database Wizard - Using SMO	11/25/2009
Building SQL Job Schedules	11/10/2009
Using a CTE to Update With An Aggregate Expression	11/5/2009
Introduction to Common Table Expressions	11/4/2009
SQL Server Error Logs	10/28/2009
Creating Indexed Views	10/21/2009
More on Instead of Triggers	10/19/2009
Computed Columns - Part 1	10/9/2009
Use sp_MSForEachDB Instead of Your Own Loop	10/7/2009
Using OpenDataSource to Access Remote Data	10/5/2009
Creating Hierarcies with HierarchyId in SQL Server 2008	9/21/2009
Valid Data Types of Full Text Search Indexes	8/21/2009
Creating a Reporting Services Solution, Project, and Report	7/30/2009
Creating a SQL Server Data Source and Dataset in SSRS	7/30/2009
Manipulating Hierarchies with HIERARCHYID	7/23/2009
SSIS Lookup Transform - Lookup Failures	7/21/2009
SysAdmin vs DBO vs DB Owner in SQL Server	7/20/2009
Monitoring Exec Cache in SQL Server - Part 1	7/16/2009
Data Access with Scalar UDF's	7/14/2009
Secure FTP File Transfer in SSIS	7/14/2009
Solve Parameter Sniffing by using RECOMPILE	7/8/2009
User Defined Functions Metadata	7/6/2009
Fixed DB Roles in SQL Server 2005	7/3/2009
Configuring Network Settings for SQL Server	7/2/2009
Using Client Statistics	7/1/2009
Basic Formatting with SQL Server Reporting Services	6/29/2009