<November 2014>
SuMoTuWeThFrSa
2627282930311
2345678
9101112131415
16171819202122
23242526272829
30123456
Overview Ola Hallengren's maintenance routines - Jed Wilson

On August 23, Jed Wilson (blog | twitter) gave an excellent overview of using Ola Hallengren's maintenance routines as an alternative to SQL Server's Maintenance Plans.

Jed covered:

  • overview
  • installation options
  • installed components (table, SP's, functions, SQL Agent jobs) 
  • backup scripts (Full and simple recovery modes)
  • verification
  • index optimization (rebuild, reorg, update stats)
  • Feature comparison between Ola's and Maintenance Plans
  • a Power Shell script for backing up SSAS databases

I particularly liked how he showed us a standard DBA Admin table and naming conventions for consistency from environment to environment in a multi-location/multi-server shop.

He gave a great tip to do Transaction Log backups every three minutes during Index Rebuild operations to keep the transaction log size at a more consistent size.

Ola generously provided Jed with additional resources, demo scripts, and a supplemental Power Point slide deck.

PASS November chapter deck
Developing Data Warehouses in SQL Server 2008 - Arie Jones (AJ)
AJ web | twitter rocked the house going from zero to Cube in 60 minutes! We had a great turn out and several new faces.

Check out the summary and sample SSAS project and slide deck.

There was lots of great discussion after the presentation. We raffled off books, pen drives, Windows 7 Ultimate, a mobile office toolkit, and a magnetic dart board. Please check out our gracious sponsors
fwPASS on facebook
Become an fwPASS facebook fan for the latest news and links to SQL related training events and webinars.
April 2010 PASS chapter deck and resources
2 3> >>|
Rss
Copyright 2010 fwPASS.org, All Rights Reserved