Synopses & Reviews
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:
- Monitor and troubleshoot queries, databases, and servers
- Help defend against injection attacks, denial of service attacks, worms, and viruses
- Manage security strategies and perform audits
- Detect and resolve data conflicts
- Diagnose faults and recover from database failures and disasters
- Optimize database availability with failover clustering, database mirroring, log shipping, and replication
- Customize a maintenance strategy and automate routine tasks
- Build, debug, and deploy SQL Server Integration Services packages
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:
Details inside. - Official self-paced study guide.
- Practice tests with multiple, customizable testing options and a learning plan based on your results.
- 400+ practice and review questions.
- Case scenarios, practice exercises, and best practices.
- 180-day evaluation version of Microsoft SQL Server 2005 Enterprise Edition.
- Fully searchable eBook of this guide.
For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.
About the Author
Ian McLean was called to the Bar in 1951 and admitted to the Faculty of Advocates, Edinburgh, in 1985. His background includes criminal practice both in England and as a law officer in Northern Nigeria. Between 1970 and 1980 he was a Metropolitan Stipendiary Magistrate, and a Circuit Judge between
1980 and 1997. He has lectured widely both in the UK and on the Continent, and is the author of a number of practitioner books. Peter Morrish was called to the Bar in 1962. His background includes service in the Northern Rhodesia Police, where he acted as a Public Prosecutor, and in the Royal Air
Force, where he gained extensive experience of courts-martial. In addition to an extensive criminal practice, he has held administrative posts in the Metropolitan Magistrates' Court Service, in the old Quarter Sessions courts (County of London, Lancashire, and Middlesex), the Central Criminal Court,
and in the Court of Appeal (Criminal Division). He has lectured in the UK and in the US and is the author of a number of practitioner books. John Greenhill was called to the Bar in 1972. He served in the Metropolitan Magistrates' Courts, rising to Senior Chief Clerk, and Training Officer for the
Metropolitan Area. He is currently based at Straford East Magistrates' Court. He holds an MSc in Criminology from the University of Leicester. Andrew Mimmack has been a Council Member of the Justices' Clerks' Society since 1996, and currently holds the office of Junior Vice President. He is Editor
of The Magistrates' Courts Practice and also delivers training courses for a range of practitioners including lawyers in England and France, Guardians ad litem, Approved Social Workers, Local AuthorityRegistration and Inspection Officers, and others.
Table of Contents
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 Reviewwwwww 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;