| Course Overview |
| Module Introduction |
| Navigation Overview |
| Lab Information |
| Designing a SQL Server Systems Infrastructure Security Policy |
| Module Introduction |
| Integrating with Enterprise Authentication Systems |
| Lesson Introduction |
| Considerations for Determining the Enterprise Authentication Method |
| Implementing Server-Level Security with Active Directory |
| Guidelines for Implementing a Server-Level Security Policy |
| Security Impact on High-Availability Solutions |
| Best Practices for Integrating with Enterprise Authentication Systems |
| Self Test |
| Developing Windows Server-Level Security Policies |
| Lesson Introduction |
| Guidelines for Developing a Password Policy |
| Guidelines for Protecting Passwords and Applications |
| Guidelines for Determining Service Accounts Permissions |
| Guidelines for Identifying Required Windows Services |
| Best Practices for Interacting with Network Firewalls |
| Considerations for Planning the Physical Security of the Server |
| Self Test |
| Developing a Secure Communication Policy |
| Lesson Introduction |
| Guidelines for Choosing Network Libraries |
| Encryption Methods |
| Guidelines for Choosing an Appropriate Encryption Method |
| SQL Server 2005 Endpoints |
| Guidelines for Using Endpoints to Secure Communication |
| Selecting an Appropriate Communication Policy |
| Self Test |
| Defining SQL Server Security Monitoring Standards |
| Lesson Introduction |
| Guidelines for Identifying What to Monitor |
| Guidelines for Determining the Classification System for Alerts |
| Guidelines for Determining the Notification Policy |
| Determining the Classification System and Notification Policy |
| Self Test |
| Lab A: Designing a SQL Server Systems Infrastructure Security Policy |
| Lesson Introduction |
| Scenario |
| Exercise: Developing Microsoft Windows Server-Level Security Policies |
| Exercise: Developing a Secure Communication Policy |
| Exercise: Integrating SQL Server Security |
| Lab Review |
| Lab B: Validating a Systems Infrastructure Security Policy |
| Lesson Introduction |
| Scenario |
| Exercise |
| Lab Review |
| Module Summary |
| Glossary |
| Module Introduction |