Welcome to MSDN Blogs Sign in | Join | Help

February 2009 - Posts

SQL Saturdays

SQL Saturdays are events organized by local SQL user groups (mostly) that consist of a one day training event for SQL Server professionals. I've volunteered to speak at the SQL Saturday event in Atlanta. It's being hosted by the good people at Atlanta.MDF. Read More...
Posted Thursday, February 19, 2009 10:18 PM by Tom Mills | 1 Comments

New security patch MS09-004 for SQL Server is out...

A new security patch for SQL Server has been announced. You should pay close attention to this one since it may not be immediately obvious that you have a server that requires this patch. The system I'm working on currently has SQL Server 2005 with Service Read More...
Posted Tuesday, February 10, 2009 5:52 PM by Tom Mills | 0 Comments

Creating a job to re-index all user databases in a Standard Edition instance of SQL Server 2005/2008

Here's another version of the reindex script that supports SQL Server 2005/2008 Standard and Workgroup Editions. It's got the online re-indexing code stripped out. If you're running something else like Workgroup, just change the code that checks for "Standard". Read More...
Posted Tuesday, February 10, 2009 5:40 PM by Tom Mills | 1 Comments
Attachment(s): CreateReindexJobSQLStandard_BlogPost.sql
 
Page view tracker