MCITP Administrator. Microsoft SQL Server 2005 Optimization and Maintenance Study Guide (70-444)

MCITP Administrator: Microsoft SQL Server 2005 Optimization and Maintenance (Exam 70-444) Study Guide

ISBN: 0470127457
EAN: 2147483647

Year: 2004
Pages: 146

Authors: Victor Isakov, Marilyn Miller-White, J. Steven Jones, Andy Warren

BUY ON AMAZON

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
Summary
Exam Essentials
Review Questions
Chapter 9: Protecting Your SQL Server from Attack
Analyzing Your Physical Server Security
Preparing for and Responding to Threats and Attacks
Optimizing a Database Control Strategy to Meet Business Requirements
Summary
Exam Essentials
Review Questions
Chapter 10: Designing a Strategy to Manage and Maintain Database Security
Maintaining a Server-Level Security Strategy
Maintaining a User-Level Security Strategy
Summary
Exam Essentials
Review Questions
Glossary
B
C
D
E
F
G
H
I
K
L
M
N
O
P
Q
R
S
T
U
V
W
Index
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
List of Figures
List of Tables
List of Exercises
List of Sidebars