Platinum Sponsor

Database Maintenance Essentials

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 RestoreManaging Maintenance JobsI cover the reasons why maintenance is required and include a number of references to help you enable this maintenance in your environment.
Presented by Steve Jones at SQLBits XI
Tags (no tags)
  • Downloads
    Sorry, there are no downloads available for this session.
  • SpeakerBIO
    steve_jones.jpg
    Steve Jones is currently the editor of SQLServerCentral, employed by Red Gate Software. Steve has been working with SQL Server for two decades at a variety of large and small companies. Steve has spent time as a hiring manager as well as a technical DBA, easily moving back and forth between these positions at different employers. He has managed Windows networks, functioned as a production DBA, development DBA, software developer, and DBA manager. His work has included start-up as well as Fortune 1000 companies in the power, financial, education, and software industries. He currently has his dream job managing the largest SQL Server community on the Internet from his ranch in Colorado and writes a daily editorial at SQLServerCentral.
    http://www.sqlservercentral.com http://voiceofthedba.wordpress.com/feed/
  • Video
    The video is not available to view online.