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
- Cover Page
- Title Page
- Copyright
- Dear Reader
- Dedication
- Acknowledgments
- About the Authors
- Contents at a Glance
- Contents
- Table of Exercises
-
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
- What's in the Book?
- What's on the Book's CD?
- How Do You Use This Book?
- Hardware and Software Requirements
- Assessment Test
- Answers to Assessment Test
- 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
- 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
- Answers to Review Questions
- Chapter 7: Designing a Database Data Management Strategy
- Chapter 8: Designing a Strategy to Manage Replication
- Chapter 9: Protecting Your SQL Server from Attack
- Chapter 10: Designing a Strategy to Manage and Maintain Database Security
- Glossary
- Index
Product information
- Title: MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide
- Author(s):
- Release date: July 2007
- Publisher(s): Sybex
- ISBN: 9780470127452
You might also like
book
Microsoft® SQL Server® 2008 Step by Step
Teach yourself SQL Server 2008—one step at a time. Get the practical guidance you need to …
book
The Real MCTS SQL Server 2008 Exam 70-433 Prep Kit
SQL Server 2008 is the latest update to Microsoft's flagship database management system. This is the …
book
Professional Microsoft® SQL Server® 2008 Administration
SQL Server 2008 represents a sizable jump forward in scalability, performance, and usability for the DBA, …
book
Microsoft® SQL Server® 2008 Bible
Harness the power of SQL Server, Microsoft’s high-performance database and data analysis software package, by accesing …