Abstract: SQL Server requires a minimal level of maintenance to ensure that the platform functions at an optimum level without any unnecessary outages or problems. This talk will look at the basics of the maintenance operations that should be performed on SQL Server on a regular basis. The topics covered include:

• Managing MDF and LDF Files
• Managing Indexes
• Maintaining Statistics
• Checking for Corruption
• Creating Backups That Will Restore
• Managing Maintenance Jobs

I cover the reasons why maintenance is required and include a number of references to help you enable this maintenance in your environment.
In some presentations I will also cover the Red Gate tools that make this maintenance easier to perform. This is optional.

Level: 100

Length: 60 minutes

Slides: Database Maintenance Essentials (SQL in the City)

Presentations:

You can view my complete speaking schedule here: http://wp.me/P14wgJ-1tV

• Feb 11-13, 2013 – Rocky Mountain Oracle User Group Training Days
• Nov 5, 2012 – SQL in the City Seattle, WA 2012
• Oct 8, 2012 – SQL in the City Boston 2012
• Oct 5, 2012 – SQL in the City Chicago, IL 2012
• Oct 3, 2012 – SQL in the City San Francisco, SA 2012
• Oct 1, 2012 – SQL in the City Austin, TX 2012
• Sept 28, 2012 – SQL in the City New York 2012