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 All-In-One Desk Reference For Dummies®
If you’re in charge of database administration, developing database software, or looking for database solutions for …
book
Professional Microsoft SQL Server 2014 Integration Services
Fill the gap between planning and doing with SSIS 2014 The 2014 release of Microsoft's SQL …
book
Microsoft SQL Server 2014 Unleashed
The industry’s most complete, useful, and up-to-date guide to SQL Server 2014. You’ll find start-to-finish coverage …
book
Microsoft SQL Server 2012 Bible
Harness the powerful new SQL Server 2012 Microsoft SQL Server 2012 is the most significant update …