Ships from: STERLING HEIGHTS, MI
Usually ships in 1-2 business days
Ships from: acton, MA
Usually ships in 1-2 business days
Ships from: acton, MA
Usually ships in 1-2 business days
Ships from: Morden, United Kingdom
Usually ships in 1-2 business days
EXAM PREP GUIDE
Ace your preparation for the skills measured by MCTS Exam 70-444—and on the job. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce what you’ve learned by applying your knowledge to real-world case scenarios and practice exercises. This official Microsoft study guide is designed to help you make the most of your study time.
Maximize your performance on the exam by learning to:
PRACTICE TESTS
Assess your skills with practice tests on CD. You can work through hundreds of questions using multiple testing modes to meet your specific learning needs. You get detailed explanations for right and wrong answers—including a customized learning path that describes how and where to focus your studies.
Your training kit includes:
A Note Regarding the CD or DVD
The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.
Dedication;
Acknowledgments;
Introduction;
Hardware Requirements;
Software Requirements;
Using the CD and DVD;
Microsoft Certified Professional Program;
Technical Support;
Evaluation Edition Software Support;
Chapter 1: Troubleshooting Database and Server Performance;
1.1 Before You Begin;
1.2 Lesson 1: Troubleshooting Physical Server Performance;
1.3 Lesson 2: Troubleshooting Connectivity to a SQL Server Instance;
1.4 Lesson 3: Troubleshooting Database Performance;
1.5 Chapter Review;
1.6 Chapter Summary;
1.7 Key Terms;
1.8 Case Scenario;
1.9 Suggested Practices;
1.10 Take a Practice Test;
Chapter 2: Analyzing Queries;
2.1 Before You Begin;
2.2 Lesson 1: Identifying Poorly Performing Queries;
2.3 Lesson 2: Analyzing a Query Plan to Detect Inefficiencies in Query Logic;
2.4 Lesson 3: Maintaining and Optimizing Indexes;
2.5 Lesson 4: Enforcing Appropriate Stored Procedure Logging and Output;
2.6 Lesson 5: Troubleshooting Concurrency Issues;
2.7 Chapter Review;
2.8 Chapter Summary;
2.9 Key Terms;
2.10 Case Scenario;
2.11 Suggested Practices;
2.12 Take a Practice Test;
Chapter 3: Failure Diagnosis;
3.1 Before You Begin;
3.2 Lesson 1: Diagnosing Database Failures;
3.3 Lesson 2: Diagnosing Physical Server Failures;
3.4 Lesson 3: SQL Server Service Failures;
3.5 Chapter Review;
3.6 Chapter Summary;
3.7 Key Terms;
3.8 Case Scenarios;
3.9 Suggested Practices;
3.10 Take a Practice Test;
Chapter 4: Disaster Recovery;
4.1 Before You Begin;
4.2 Lesson 1: Planning for Fault Tolerance;
4.3 Lesson 2: Recovering from Failure;
4.4 Lesson 3: Recovering from Database Disaster;
4.5 Lesson 4: Salvaging Data from a Damaged Database;
4.6 Chapter Summary;
4.7 Key Terms;
4.8 Case Scenarios;
4.9 Suggested Practices;
4.10 Take a Practice Test;
Chapter 5: Performance Monitoring;
5.1 Before You Begin;
5.2 Lesson 1: Defining and Implementing Monitoring Standards for a Physical Server;
5.3 Lesson 2: Choosing the Appropriate Information to Monitor;
5.4 Chapter Review;
5.5 Chapter Summary;
5.6 Key Terms;
5.7 Case Scenarios;
5.8 Suggested Practices;
5.9 Take a Practice Test;
Chapter 6: Database Maintenance;
6.1 Before You Begin;
6.2 Lesson 1: Creating and Implementing a Maintenance Strategy for Database Servers;
6.3 Lesson 2: Designing a Database Maintenance Plan;
6.4 Lesson 3: Managing Reporting Services;
6.5 Lesson 4: Designing a Strategy to Manage Data Across Linked Servers;
6.6 Chapter Review;
6.7 Chapter Summary;
6.8 Key Terms;
6.9 Case Scenarios;
6.10 Suggested Practices;
6.11 Take a Practice Test;
Chapter 7: SQL Server Integration Services;
7.1 Before You Begin;
7.2 Lesson 1: Constructing SSIS Packages;
7.3 Lesson 2: Securing SSIS Packages;
7.4 Lesson 3: Troubleshooting SSIS Packages;
7.5 Lesson 4: Deploying SSIS Packages;
7.6 Chapter Review;
7.7 Chapter Summary;
7.8 Key Terms;
7.9 Case Scenarios;
7.10 Suggested Practices;
7.11 Take a Practice Test;
Chapter 8: Design Data Integrity;
8.1 Before You Begin;
8.2 Lesson 1: Reconciling Data Conflicts;
8.3 Lesson 2: Making Implicit Constraints Explicit;
8.4 Lesson 3: Assigning Data Types to Control Characteristics of Data Stored in a Column;
8.5 Chapter Review;
8.6 Chapter Summary;
8.7 Key Terms;
8.8 Case Scenarios;
8.9 Suggested Practices;
8.10 Take a Practice Test;
Chapter 9: Business Requirements;
9.1 Before You Begin;
9.2 Lesson 1: Enforcing Data Quality According to Business Requirements;
9.3 Lesson 2: Optimizing a Database Change Control Strategy to Meet Business Requirements;
9.4 Chapter Review;
9.5 Chapter Summary;
9.6 Key Terms;
9.7 Case Scenarios;
9.8 Suggested Practices;
9.9 Take a Practice Test;
Chapter 10: Replication;
10.1 Before You Begin;
10.2 Lesson 1: Designing a Strategy to Manage Replication;
10.3 Chapter Review;
10.4 Chapter Summary;
10.5 Key Terms;
10.6 Case Scenarios;
10.7 Suggested Practices;
10.8 Take a Practice Test;
Chapter 11: Security Strategies;
11.1 Before You Begin;
11.2 Lesson 1: Maintaining a Server-Level Security Strategy;
11.3 Lesson 2: Maintaining a User-Level Security Strategy;
11.4 Chapter Review;
11.5 Chapter Summary;
11.6 Key Terms;
11.7 Case Scenarios;
11.8 Suggested Practices;
11.9 Take a Practice Test;
Chapter 12: Detecting and Responding to Attacks;
12.1 Before You Begin;
12.2 Lesson 1: Auditing the Existing Infrastructure;
12.3 Lesson 2: Protecting Against Threats and Attacks;
12.4 Chapter Review;
12.5 Chapter Summary;
12.6 Key Terms;
12.7 Case Scenarios;
12.8 Suggested Practices;
12.9 Take a Practice Test;
Appendix;
Configuring the Computers;
Glossary;
Answers;
Chapter 1: Lesson Review Answers;
Chapter 1: Case Scenario Answers;
Chapter 2: Lesson Review Answers;
Chapter 2: Case Scenario Answers;
Chapter 3: Lesson Review Answers;
Chapter 3: Case Scenario Answers;
Chapter 4: Lesson Review Answers;
Chapter 4: Case Scenario Answers;
Chapter 5: Lesson Review Answers;
Chapter 5: Case Scenario Answers;
Chapter 6: Lesson Review Answers;
Chapter 6: Case Scenario Answers;
Chapter 7: Lesson Review Answers;
Chapter 7: Case Scenario Answers;
Chapter 8: Lesson Review Answers;
Chapter 8: Case Scenario Answers;
Chapter 9: Lesson Review Answers;
Chapter 9: Case Scenario Answers;
Chapter 10: Lesson Review Answers;
Chapter 10: Case Scenario Answers;
Chapter 11: Lesson Review Answers;
Chapter 11: Case Scenario Answers;
Chapter 12: Lesson Review Answers;
Chapter 12: Case Scenario Answers;
System Requirements;
Hardware Requirements;
Software Requirements;
About the Authors;
Orin Thomas;
Ian McLean;
Exam 70-444: PRO: Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005;
Overview
EXAM PREP GUIDE
Ace your preparation for the skills measured by MCTS Exam 70-444—and on the job. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce what you’ve learned by applying your knowledge to real-world case scenarios and practice exercises. This official Microsoft study guide is designed to help you make ...