You are previewing MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide.
O'Reilly logo
MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide

Book Description

This ebook does not provide access to the CD-ROM files.

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.

Table of Contents

  1. Cover Page
  2. Title Page
  3. Copyright
  4. Dear Reader
  5. Dedication
  6. Acknowledgments
  7. About the Authors
  8. Contents at a Glance
  9. Contents
  10. Table of Exercises
  11. Introduction
    1. Introducing the Microsoft Certified IT Professional
    2. How to Become Certified as a MCITP: Database Administrator
    3. Registering for the Exam
    4. Taking the Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005 Exam
    5. Types of Exam Questions
    6. Tips for Taking the Exam
    7. What's in the Book?
    8. What's on the Book's CD?
    9. How Do You Use This Book?
    10. Hardware and Software Requirements
  12. Assessment Test
  13. Answers to Assessment Test
  14. Chapter 1: Optimizing the Performance of Databases and Database Servers
    1. Troubleshooting the Performance of a SQL Server Solution
    2. Troubleshooting Physical Server Performance
    3. Troubleshooting Instance Performance
    4. Troubleshooting Database Performance
    5. Summary
    6. Exam Essentials
    7. Review Questions
    8. Answers to Review Questions
  15. Chapter 2: Optimizing the Performance of Queries
    1. Troubleshooting and Maintaining Query Performance
    2. Troubleshooting Concurrency Issues
    3. Summary
    4. Exam Essentials
    5. Review Questions
    6. Answers to Review Questions
  16. chapter 3: Optimizing and Implementing a Data Recovery Plan for a Database
    1. Diagnosing Causes of Failure
    2. Planning for Fault Tolerance
    3. Recovering from a Failure of SQL Server 2005
    4. Recovering from a Database Failure
    5. Salvaging Good Data from a Damaged Database by Using Restoration Techniques
    6. Summary
    7. Exam Essentials
    8. Review Questions
    9. Answers to Review Questions
  17. Chapter 4: Designing a Strategy to Monitor a Database Solution
    1. Choosing a Performance Monitoring Tool
    2. Choosing the Appropriate Information to Monitor
    3. Defining and Implementing Monitoring Standards for a Physical Server
    4. Summary
    5. Exam Essentials
    6. Review Questions
    7. Answers to Review Questions
  18. Chapter 5: Designing a Strategy to Maintain a Database Solution
    1. Creating and Implementing a Maintenance Strategy for Database Servers
    2. Designing a Database Maintenance Plan
    3. Designing a Strategy to Manage Reporting Services
    4. Summary
    5. Exam Essentials
    6. Review Questions
    7. Answers to Review Questions
  19. Chapter 6: Designing and Managing SSIS Packages
    1. Understanding How SSIS Is Different from DTS
    2. Installing SSIS
    3. Identifying the SSIS Tools
    4. Using SSMS with SSIS
    5. Understanding Control Flow Items and Maintenance Plan Tasks
    6. Understanding Data Flow Sources, Transformations, and Destinations
    7. Scheduling Package Execution
    8. Securing Packages
    9. Using Checkpoints and Restarting Failed Packages
    10. Moving Packages
    11. Debugging Packages
    12. Using SSIS for Performance Monitoring
    13. Configuring Packages
    14. Summary
    15. Exam Essentials
    16. Review Questions
    17. Answers to Review Questions
  20. Chapter 7: Designing a Database Data Management Strategy
    1. Managing Data for Quality
    2. Designing Data Integrity
    3. Summary
    4. Exam Essentials
    5. Review Questions
    6. Answers to Review Questions
  21. Chapter 8: Designing a Strategy to Manage Replication
    1. Designing a Strategy to Manage Data Across Linked Servers
    2. Designing a Replication Strategy
    3. Summary
    4. Exam Essentials
    5. Review Questions
    6. Answers to Review Questions
  22. Chapter 9: Protecting Your SQL Server from Attack
    1. Analyzing Your Physical Server Security
    2. Preparing for and Responding to Threats and Attacks
    3. Optimizing a Database Control Strategy to Meet Business Requirements
    4. Summary
    5. Exam Essentials
    6. Review Questions
    7. Answers to Review Questions
  23. Chapter 10: Designing a Strategy to Manage and Maintain Database Security
    1. Maintaining a Server-Level Security Strategy
    2. Maintaining a User-Level Security Strategy
    3. Summary
    4. Exam Essentials
    5. Review Questions
    6. Answers to Review Questions
  24. Glossary
  25. Index