O'Reilly logo

MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide by Andy Warren, J. Steven Jones, Marilyn Miller-White, Victor Isakov

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Optimizing a Database Control Strategy to Meet Business Requirements

Protecting your SQL Server does not just mean you are worried about individuals who are seeking to maliciously change or delete your data. It also includes protections from accidental or inadvertent changes that can disrupt your database server or compromise the integrity of your data.

One of the main duties of a DBA is to ensure that any changes that are made to the database server are thoroughly tested and will not damage the environment. This means that all of the following types of changes are properly tested:

  • Schema and other code changes
  • Configuration changes to SQL Server or the Windows host system
  • Patches and service packs by software vendors

To ensure that all changes ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required