Microsoft SQL Server 2008— Implementation and Maintenance

Microsoft SQL Server 2008— Implementation and Maintenance
0BJECTIVE INSTALLING AND CONFIGURING SQL SERVER 2008 Configure additional SQL Server components. Chapter 1, Lessons 3 and 4 Chapter 5, Lessons 1, 2 and 3 Configure SQL Server instances. Configure SQL Server services. Install SQL Server 2008 and related services. Chapter 1, Lesson 3 Chapter 1, Lesson 3 Chapter 1, Lesson 3 Chapter 5, Lessons 1, 2 and 3 Implement database mail. Configure full-text indexing. MAINTAINING SQL SERVER INSTANCES Manage SQL Server Agent jobs. Manage SQL Server Agent alerts. Manage SQL Server Agent operators. Implement the declarative management framework (DMF). Back up a SQL Server environment. MANAGING SQL SERVER SECURITY Manage logins and server roles. Manage users and database roles. Manage SQL Server instance permissions. Manage database permissions. Manage schema permissions and object permissions. Audit SQL Server instances. Manage transparent data encryption. Configure surface