Exam Essentials

• 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.