---

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