Title	When Watched
Doing a Differential Backup of a SQL Server Database (Simple Recovery)	7/15/2010
Firewall Configuration for SQL Azure	6/24/2010
Solve Parameter Sniffing By Using Local Variables	6/24/2010
Using @@ServerName and ServerProperty	2/18/2010
Using a Server Trigger to Dropping a Database	2/15/2010
Using the StatsDate Function	1/8/2010
Using Top N with Percentages	1/7/2010
The Impact of Stale Statistics	1/6/2010
Using sp_autostats	1/5/2010
SQL Server Internals: Hardware and processes	12/29/2009
Understanding DBCC Show_Statistics	12/14/2009
Filegroups and Adding a New Filegroup	12/3/2009
Marking a Filegroup Read Only	12/3/2009
Introduction to Filegroups And Adding A File to a FileGroup	12/1/2009
Using sp_MSForEachDB With A Filter	11/30/2009
Shared Job Schedules	11/23/2009
Running Jobs Based on Alerts	11/19/2009
Working with SQL Agent Job Categories	11/19/2009
Sharing Job Schedules	11/19/2009
Configuring a Post Snapshot Script	11/13/2009
Introduction to Common Table Expressions	11/13/2009
Using a CTE to Update With An Aggregate Expression	11/13/2009
Building SQL Job Schedules	11/13/2009
Putting Databases Into Single User Mode	10/30/2009
Using SP_Configure	10/30/2009
Creating a Replication Subscription	10/23/2009