MCITP Administrator: Microsoft SQL Server 2005 Optimization and Maintenance (Exam 70-444) Study Guide - page 1
- 1
- 2
- Table of Contents
- Table of Contents
- Back Cover
- MCITP Administrator-Microsoft SQL Server 2005 Optimization and Maintenance (70-444) Study Guide
- MCSE: Microsoft SQL Server 2005 Optimization and Maintenance Study Guide
- Introduction
- Introducing the Microsoft Certified IT Professional
- How to Become Certified as a MCITP: Database Administrator
- Registering for the Exam
- Taking the Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005 Exam
- Types of Exam Questions
- Tips for Taking the Exam
- Whats in the Book?
- Whats on the Books CD?
- How Do You Use This Book?
- Hardware and Software Requirements
- Assessment Test
- Chapter 1: Optimizing the Performance of Databases and Database Servers
- Troubleshooting the Performance of a SQL Server Solution
- Troubleshooting Physical Server Performance
- Troubleshooting Instance Performance
- Troubleshooting Database Performance
- Summary
- Exam Essentials
- Review Questions
- Chapter 2: Optimizing the Performance of Queries
- Troubleshooting and Maintaining Query Performance
- Troubleshooting Concurrency Issues
- Summary
- Exam Essentials
- Review Questions
- Chapter 3: Optimizing and Implementing a Data Recovery Plan for a Database
- Diagnosing Causes of Failure
- Planning for Fault Tolerance
- Recovering from a Failure of SQL Server 2005
- Recovering from a Database Failure
- Salvaging Good Data from a Damaged Database by Using Restoration Techniques
- Summary
- Exam Essentials
- Review Questions
- Chapter 4: Designing a Strategy to Monitor a Database Solution
- Choosing a Performance Monitoring Tool
- Choosing the Appropriate Information to Monitor
- Defining and Implementing Monitoring Standards for a Physical Server
- Summary
- Exam Essentials
- Review Questions
- Chapter 5: Designing a Strategy to Maintain a Database Solution
- Creating and Implementing a Maintenance Strategy for Database Servers
- Designing a Database Maintenance Plan
- Designing a Strategy to Manage Reporting Services
- Summary
- Exam Essentials
- Review Questions
- Chapter 6: Designing and Managing SSIS Packages
- Understanding How SSIS Is Different from DTS
- Installing SSIS
- Identifying the SSIS Tools
- Using SSMS with SSIS
- Understanding Control Flow Items and Maintenance Plan Tasks
- Understanding Data Flow Sources, Transformations, and Destinations
- Scheduling Package Execution
- Securing Packages
- Using Checkpoints and Restarting Failed Packages
- Moving Packages
- Debugging Packages
- Using SSIS for Performance Monitoring
- Configuring Packages
- Summary
- Exam Essentials
- Review Questions
- Chapter 7: Designing a Database Data Management Strategy
- Managing Data for Quality
- Designing Data Integrity
- Summary
- Exam Essentials
- Review Questions
- Chapter 8: Designing a Strategy to Manage Replication
- Designing a Strategy to Manage Data Across Linked Servers
- Designing a Replication Strategy
- 1
- 2
