Synopses & Reviews
Designed for database administrators and system engineers, this guide provides real-world, task-based information and best practices for the day-to-day management of SQL Server 2000. It draws on the combined knowledge and experience of Microsoft Consulting Services (MCS), Microsofts Internal Technical Support Group, and the SQL Server Developer Teamillustrating both the theory behind and the field-tested practices for improving database operations. Get specific instructions and recommendations for server monitoring, backup, verification of scheduled events, capacity planning, developer and end user support, and other key proceduresexploiting the lessons learned from real enterprise settings to improve team responsiveness and effectiveness and help avoid common errors. All PATTERNS & PRACTICES guides arereviewed and approved by Microsoft engineering teams, consultants, partners, and customersdeliver accurate, real-world information thats technically validated and tested.
- Proven--based on field experience
- Authoritative--offers the best advice available
- Accurate--technically validated and tested
- Actionable--provides the steps to success
- Relevant--addresses real-world problems based on customer scenarios
About the Author
Developed by senior editors and content managers at Microsoft Corporation.
Table of Contents
; Content Lead; Key Authors; Reviewers; Chapter 1: Guide Overview; 1.1 Introduction; 1.2 Audience; 1.3 Prerequisites; 1.4 Executive Summary; 1.5 Structure; 1.6 What is the Microsoft Operations Framework?; 1.7 MOF Quadrants and Service Management Functions; 1.8 Chapter Introductions; 1.9 Style Conventions; Chapter 2: Change, Configuration, and Release Management; 2.1 Introduction; 2.2 Process Flowchart; 2.3 Managing Change; 2.4 The Process of Change; 2.5 Change and Release Management; 2.6 Configuration Management; 2.7 Summary; Chapter 3: Security Administration; 3.1 Introduction; 3.2 Basic Security Issues; 3.3 Roles, Permissions, and Passwords; 3.4 Standard Security Design; 3.5 User and Account Management Issues; 3.6 Managing a Secured Environment; 3.7 Summary; Chapter 4: System Administration; 4.1 Introduction; 4.2 The DBA Team; 4.3 Administrative Topics; 4.4 Administrative Schedules; 4.5 Advanced Administrative Topics; 4.6 Summary; Chapter 5: Monitoring and Control; 5.1 Introduction; 5.2 Process Flowchart; 5.3 Approaches to Monitoring; 5.4 Reacting to Problems; 5.5 Summary; Chapter 6: Capacity and Storage Management; 6.1 Introduction; 6.2 Process Flowchart; 6.3 System Classification; 6.4 Capacity Management; 6.5 Summary; Chapter 7: Problem and Incident Management; 7.1 Introduction; 7.2 Process Flowcharts; 7.3 Problem Management; 7.4 Problems That Appear As Database Problems; 7.5 Summary; Chapter 8: Service Management; 8.1 Introduction; 8.2 Process Flowchart; 8.3 Negotiating the SLA; 8.4 Delivery of Service; 8.5 Service Levels; 8.6 Summary;