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

Understand SQL Server physical security.   Understand how to properly physically secure a SQL Server computer and how to ensure that the security meets the needs and guidelines for your organization.

Understand the threat of SQL injection.   Ensure that you understand what SQL injection is and how to protect your server from this threat.

Know about SQL Server viruses and worms.   Know how to recognize and deal with a SQL Server specific worm or virus.

Be prepared for denial-of-service attacks.   Understand how to recognize a denial-of-service attack and how to respond.

Be prepared for internal attacks.   Be sure that you can identify and respond to internal attacks on your SQL Server.

Understand change control environments.   Be sure that you understand the different environments needed in a change control environment and the purpose of each.

Understand the importance of change control procedures being followed.   Know how to determine whether your change control procedures are being followed.

Know how to identify changes.   Know how to identify those objects that are needed for a particular deployment.