If you've read SQL Server Magazine, then you know that I write a monthly column about free SQL Server tools called Tool Time. I recently wrote about a set of automation scripts from Microsoft's internal MIS group that automates all sorts of regular tasks they perform on their SQL Server's.
Today, I'd like to share some more scripts brought to my attention by Ola Hallengren. Ola wrote some great scripts for backup, integrity check and index optimization that add to what Microsoft had written. I think that it in some areas has some advantages over Microsoft's solution.
Ola's index optimization stored procedure rebuilds indexes online or offline, index reorganization, statistics update, index reorganization and statistics update or nothing based on fragmentation level and lob existence. This solution was made about 6 months ago and it has been running in a large production environment since then. You can see them at:
http://blog.ola.hallengren.com/blog/_archives/2008/1/1/3440068.html
http://blog.ola.hallengren.com/_attachments/3440068/Documentation.html
Ola has put a lot of time in this and would really appreciate your feedback. You can see more of his work at
http://ola.hallengren.com.
I'd love to hear about any other database automation scripts you may have written. Be sure to let me know so I can share them with the community.
Enjoy!
-Kevin