List of Sidebars


Chapter 1: Optimizing the Performance of Databases and Database Servers

Real World Scenario-The Benefits of a Performance Troubleshooting Methodology

Chapter 2: Optimizing the Performance of Queries

Database Tuning Advisor
Statement-Level Compilation
Real World Scenario-Covering Indexes
An Iterative Process
PSS Head Blocker Script
Real World Scenario-Caveat Emptor: Overriding the Optimizer

Chapter 3: Optimizing and Implementing a Data Recovery Plan for a Database

Don’t Forget the SQL Server Agent!
Tail-Log Backups

Chapter 4: Designing a Strategy to Monitor a Database Solution

The Performance Overhead of Monitoring Tools
Real World Scenario-A Holistic Approach to Monitoring Performance
The SQL Server Agent
Defining Operators Using the SQL Server Agent
Windows Management Instrumentation (WMI)
Service Broker

Chapter 5: Designing a Strategy to Maintain a Database Solution

Real World Scenario-Running DBCC Checks in a VLDB Environment
Capacity Planning the reportserver and reportservertempdb System Databases

Chapter 6: Designing and Managing SSIS Packages

Versioning Has Changed
Additional Reading
Real You Need Scenario-Do You Need Checkpoints?
Why Would You Move Packages?
More on Performance Tuning

Chapter 7: Designing a Database Data Management Strategy

Real World Scenario-Clinical Trial Data
Real World Scenario-Reconciling Conflicting Data
Real World Scenario-Creating Clinical Trial Deliverables

Chapter 8: Designing a Strategy to Manage Replication

Linked Server Information
Ad Hoc Distributed Query Solutions: Past and Present

Chapter 9: Protecting Your SQL Server from Attack

Real World Scenario-Build versus Buy
Real World Scenario-Real-Life Virus Response: Slammer

Chapter 10: Designing a Strategy to Manage and Maintain Database Security

Real World Scenario-Tightly Coupled Problems
Real World Scenario-A Structured Release




MCITP Administrator. Microsoft SQL Server 2005 Optimization and Maintenance Study Guide (70-444)
MCITP Administrator: Microsoft SQL Server 2005 Optimization and Maintenance (Exam 70-444) Study Guide
ISBN: 0470127457
EAN: 2147483647
Year: 2004
Pages: 146

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net