MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide

Preparing for and Responding to Threats and Attacks

One of the primary jobs of any administrator of a computer system is securing that system from attack. This is true whether you are a SQL Server DBA or a Cisco router administrator. Security is one of your primary concerns because without good security, any other structures you have set up could be deleted, altered, or otherwise compromised.

The following sections will cover a variety of ways that attackers can harm your SQL Server database servers, including both internal and external attacks. We will cover both intentional, malicious attacks and unintentional or incidental mistakes that could harm the integrity of your server.

We will refer to anyone who attempts to change, alter, gain access ...