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

by Isakov, Victor; Miller-White, Marilyn; Jones, J. Steven; Warren, Andy

• ISBN13: 9780470127452
• ISBN10: 0470127457
• Edition: CD
• Format: Paperback
• Copyright: 2007-07-10
• Publisher: Sybex

Summary

This comprehensive book will guide readers through Microsoft's brand new SQL 2005 administrator exam: PRO: Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005 (70-444).Candidates for this exam are Professional Database Administrators who set up, maintain, and troubleshoot database solutions. They have three or more years dedicated to database work. Topics include: Defining high-availability solutions Automating administrative tasks Defining security solutions Monitoring and troubleshooting the database server Designing and executing deployments Defining the infrastructure (storage, hardware, and number of servers or instances, etc.) Companion CD features leading-edge exam prep software with test engine of case study practice questions and electronic flashcards. Teacher support package provided for classroom use.

Author Biography

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.

Table of Contents

Introduction

Assessment Test

Optimizing the Performance of Databases and Database Servers

Optimizing the Performance of Queries

Optimizing and Implementing a Data Recovery Plan for a Database

Designing a Strategy to Monitor a Database Solution

Designing a Strategy to Maintain a Database Solution

Designing and Managing SSIS Packages

Designing a Database Data Management Strategy

Designing a Strategy to Manage Replication

Protecting Your SQL Server from Attack

Designing a Strategy to Manage and Maintain Database Security

Glossary

Index

Table of Contents provided by Publisher. All Rights Reserved.