Professional SQL Server 2005 Administration (Wrox Professional Guides)

ISBN: 0470055200
EAN: 2147483647

Year: 2004
Pages: 193

Authors: Brian Knight, Ketan Patel, Wayne Snyder, Jean-Claude Armand, Ross LoForte, Brad McGehee, Steven Wort, Joe Salvatore, Haidong Ji

BUY ON AMAZON

Table of Contents
Back Cover
Professional SQL Server 2005 Administration
Introduction
How This Book Is Structured
What You Need to Use This Book
Conventions
Source Code
Errata
p2p.wrox.com
Chapter 1: SQL Server 2005 Architecture
SQL Server Architecture
Editions of SQL Server
Summary
Chapter 2: SQL Server 2005 Installation Best Practices
Planning the System
Installing SQL Server
Installing Analysis Services
Installing Reporting Services
Burning in the System
Post-Install Configuration
Uninstalling SQL Server
Help from Microsoft Product Support Services
Troubleshooting a Failed Install
Summary
Chapter 3: Upgrading SQL Server 2005 Best Practices
Upgrading to SQL Server 2005
Pre-Upgrade Checks
SQL Server Upgrade Assistant
Backward Compatibility
SQL Server Component Considerations
Post Upgrade Checks
Poor Query Performance After Upgrade
Surface Area Configuration Tool
Update Usage Counters
Summary
Chapter 4: Managing and Troubleshooting the Database Engine
Configuration Tools
Management Studio
Trace Flags
Getting Help from Support
Summary
Chapter 5: Automating SQL Server
Automation Components
SQL Agent Security
Configuring SQL Server Agent
Database Mail
Multiserver Administration
Problem Resolution
Summary
Chapter 6: Integration Services Administration and Performance Tuning
Tour of Integration Services
Administration of the Integration Services Service
Administration of Integration Services Packages
Applying Security to Integration Services
Summary
Chapter 7: Analysis Services Administration and Performance Tuning
Tour of Analysis Services
Administering Analysis Services Server
Administering Analysis Services Databases
Analysis Services Performance Monitoring and Tuning
Management of Analysis Services Storage
Applying Security to Analysis Services
Summary
Chapter 8: Administering the Development Features
The Service Broker
Security Considerations for the Service Broker
Administering the Service Broker
Introduction to CLR Integration
Summary
Chapter 9: Securing the Database Engine
Credentials
Users
Schemas
Permission Context
Encryption
Column-Level Permissions
Summary
Chapter 10: Change Management
DDL Triggers
SQLCMD
Creating Change Scripts
Version Tables
Summary
Chapter 11: Configuring the Server for Optimal Performance
What Every DBA Needs to Know about Performance
What the Developer DBA Needs to Know about Performance
What the Production DBA Needs to Know about Performance
Optimizing the Server
Configuring Server Hardware
CPU
Memory
IO
Summary
Chapter 12: Optimizing SQL Server 2005
The Silent Killer: IO Problems
Table and Index Partitioning
Memory Considerations AND Enhancements
CPU Considerations
Summary
Chapter 13: Monitoring Your SQL Server
Performance Monitor
Monitoring Events
Monitoring with Dynamic Management Views and Functions
Summary
Chapter 14: Performance Tuning T-SQL
Tuning Process
Summary
Chapter 15: Indexing Your Database
What s New for Indexes in SQL Server 2005
Sample Database
Partition Tables and Indexes
Index Maintenance
Database Tuning Advisor
Summary
Chapter 16: Replication
Replication Overview
Implementing Replication
Peer-to-Peer Replication
Replication Monitoring
Summary
Chapter 17: Database Mirroring
Monitoring Database Mirroring
Troubleshooting Database Mirroring
Preparing the Mirror server for Failover
Mirroring Multiple Databases
Database Mirroring and Other High-Availability Solutions
Mirroring Event Listener Setup
Database Snapshots
Summary
Chapter 18: Backup and Recovery
Types of Failure
Overview of Backup and Restore
Planning for Recovery
Developing and Executing a Backup Plan
Managing Backups
Backup and Restore Performance
Performing Recovery
Archiving Data
Disaster Recovery Planning
Summary
Chapter 19: SQL Server 2005 Log Shipping
Log-Shipping Architecture
Log Shipping Process
System Requirements
Deploying Log Shipping
Monitoring and Troubleshooting
Managing Changing Roles
Database Backup Plan
Integrating Log Shipping with other High Availability Solutions
Removing Log Shipping
Log-Shipping Performance
Upgrading to SQL Server 2005 Log Shipping
Summary
Chapter 20: Clustering SQL Server 2005
Clustering and Your Organization
Clustering: The Big Picture
Upgrading SQL Server Clustering
Getting Prepared for Clustering
Clustering Windows Server 2003
Configuring the Microsoft Distributed Transaction Coordinator
Clustering SQL Server 2005
Maintaining the Cluster
Troubleshooting Cluster Problems
Summary
Appendix A: Raymond James Lab Report
Summary
Index
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X