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 ...
Get MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.