MCITP Administrator: Microsoft SQL Server 2005 Optimization and Maintenance (Exam 70-444) Study Guide
Publisher: Sybex | ISBN: 0470127457 | 2007 | PDF + CD | 647 pages | 77MB

Covering Microsoft’s brand-new SQL 2005 administrator exam, this study guide walks you through setting up, maintaining, and troubleshooting database solutions. You’ll review key topics such as defining high-availability solutions, automating administrative tasks, defining security solutions, monitoring and troubleshooting the database server, and designing and executing deployments. Plus, the CD-ROM features leading exam prep software with an assessment test, test engine of case study practice questions, and electronic flashcards.
Your essential guide to Microsoft's new SQL Server 2005 certification

Get the preparation you need for exam 70-444, Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005, one of two required exams in the Microsoft MCITP: Database Administrator certification path. Inside, you'll find:

* Full coverage of all exam objectives in a systematic approach, so you can be confident you're getting the instruction you need for the exam
* Practical hands-on exercises to reinforce critical skills
* Real-world scenarios that put what you've learned in the context of actual job roles
* Challenging review questions in each chapter to prepare you for exam day
* Exam Essentials, a key feature at the end of each chapter that identifies critical areas you must become proficient in before taking exam 70-444
* A handy tear card that maps every official exam objective to the corresponding chapter in the book, so you can track your exam prep, objective by objective

Contents:
Introduction.
Assessment Test.
Chapter 1: Optimizing the Performance of Databases and Database Servers.
Chapter 2: Optimizing the Performance of Queries.
Chapter 3: Optimizing and Implementing a Data Recovery Plan for a Database.
Chapter 4: Designing a Strategy to Monitor a Database Solution.
Chapter 5: Designing a Strategy to Maintain a Database Solution.
Chapter 6: Designing and Managing SSIS Packages.
Chapter 7: Designing a Database Data Management Strategy.
Chapter 8: Designing a Strategy to Manage Replication.
Chapter 9: Protecting Your SQL Server from Attack.
Chapter 10: Designing a Strategy to Manage and Maintain Database Security.