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.
|
|
|
|
|
|
|
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. Designing a Strategy to Manage Database Security. |
|
|
|
Chapter
10. Designing a Strategy to Maintain Database Security. |
|
|
|
|
|
Victor Isakov, MCITP, is a database architect and Microsoft Certified Trainer who provides consultation and training to various organizations in the public, private, and NGO sectors globally. He has authored a number of books on SQL Server and worked closely with Microsoft to develop the new generation of SQL Server 2005 Certification and Microsoft official curriculum for both Instructor Led Training and e-Learning courses. He also writes articles regularly for devx.com and searchsqlserver.com. Marilyn Miller-White, MCTS, MCITP, MCT, MCDBA, MCSE, is the owner of White Consulting, a New Jersey-based consultancy specializing in database and systems training and solutions. J. Steven Jones, MCDBA, is a senior database architect with over ten years of experience with SQL Server. He is a regular contributor and columnist for sqlservercentral.com. Andy Warren is president of Different Path Consulting and is also a senior trainer with End to End Training.
