This 2-in-1 kit includes the official Microsoft study guide, plus practice tests on CD to help you assess your skills. It comes packed with the tools and features exam candidates want most-including in-depth, self-paced training based on final exam content; rigorous, objective- by-objective review; exam tips from expert, exam- certified authors; and customizable testing options. It also provides real-world scenarios, case study examples, and troubleshooting labs for the skills and expertise you can apply to the job. Focusing on implementing and maintaining a SQL Server 2008 database, this official study guide covers installing and configuring SQL Server 2008; managing SQL Server Agent jobs, alerts, and operators; implementing security features; backing up and restoring databases; monitoring and troubleshooting SQL Server; optimizing performance using the Resource Governor and Database Engine Tuning Advisor; and implementing high availability.