Search results matching tags 'Best Practices', 'Automation', and 'SQL Programming'http://sqlblog.com/search/SearchResults.aspx?o=DateDescending&tag=Best+Practices,Automation,SQL+Programming&orTags=0Search results matching tags 'Best Practices', 'Automation', and 'SQL Programming'en-USCommunityServer 2.1 SP2 (Build: 61129.1)Database Maintenance Scripting Done Righthttp://sqlblog.com/blogs/kevin_kline/archive/2011/02/18/database-maintenance-scripting-done-right.aspxFri, 18 Feb 2011 13:16:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:33607KKline<br>I first wrote about useful database maintenance scripts on my<a href="http://sqlblog.com/blogs/kevin_kline/archive/2008/03/26/more-sql-server-automation-scripts.aspx" title="Mad skillz in Mad scriptz" target="_blank"> SQLBlog account</a> way back in 2008. Hmmm - now that I think about it, I first wrote about my own useful database maintenance scripts in a journal called SQL Server Professional back in the mid-1990's on SQL Server v6.5 or some such. But I digress...
<a href="http://KevinEKline.com"><img src="http://www.binbin.net/photos/everythingplay/mov/movie-script-note-book.jpg" title="Script" alt="" height="247" width="247"></a>
Anyway, I pointed out a couple useful sites where you could get some good scripts that would take care of preventative maintenance on your SQL Server, such as index defragmentation, updating statistics, and so forth. One of the script kits came directly from Microsoft's internal database management team. But, alas, they haven't published any updates in quite a while. On the other hand, the other set of scripts came from Ola Hallengren, who has done a great job keeping his scripts up to date.
Recently, Ola added support for updating column statistics, both in a generalized update and also updates for only those columns whose statistics have been modified. He's added some other goodies to the latest release, which you can read about here, <a href="http://ola.hallengren.com/Versions.html">http://ola.hallengren.com/Versions.html</a> for all details.
In addition, I'd like to remind you of the white paper I wrote a while back called <a href="http://www.quest.com/documents/landing.aspx?id=10931" title="Free, but registration is required" target="_blank"><em>Automating DBA Processes</em></a>, which covers many aspects of database automation and cherry picks some of the best practices from many different thought leaders, such as Ola, Michelle Ufford <a href="http://sqlfool.com/" target="_blank">(</a><a href="http://sqlfool.com/">blog</a> | @<a href="http://twitter.com/sqlfool">sqlfool</a>) who will be speaking at the <a href="http://www.sqlpass.org/24hours/Spring2011/default.aspx" title="Celebrating Women in Technology with an all-female speaker line up!" target="_blank">24HOP </a>soon, and Allen White (<a href="http://sqlblog.com/blogs/allen_white/archive/tags/PowerShell/default.aspx" target="_blank">blog</a> | <a href="http://twitter.com/sqlrunr">twitter</a>).