Microsoft SQL Server 2005 Administrator's Companion
Get your mission-critical databases up and running quickly with this essential, single-volume guide. This comprehensive administrator’s reference details features and capabilities of SQL Server 2005 - including how to implement business intelligence applications. It delivers the easy-to-follow procedures, practical workarounds, and key troubleshooting tactics you need for on-the-job-results.
Discover how to:
- Perform an installation or upgrade, and configure it on the network
- Plan and configure the I/O subsystem and model system capacity
- Create and maintain databases, tables, views, and indexes
- Administer transactions, deadlocks, and isolation levels
- Manage users with logins, user IDs, schemas, permissions, and roles
- Implement failover clustering, log shipping, and database mirroring for high availability
- Manage and tune snapshot, transactional, and merge replication
- Administer SQL Server Analysis Services and Reporting Services
- Monitor, troubleshoot, and fine-tune performance
Includes a CD with a fully searchable eBook.
CONTENTS:
Acknowledgments Introduction Part I: Introduction to Microsoft SQL Server 2005
- Chapter 1: What’s New in Microsoft SQL Server
- Chapter 2: Microsoft SQL Server 2005 Editions, Capacity Limits, and Licensing
- Chapter 3: Roles and Responsibilities of the Microsoft SQL Server DBAPart II: System Design and Architecture
- Chapter 4: I/O Subsystem Planning and RAID Configuration
- Chapter 5: 32-Bit Versus 64-Bit Platforms and Microsoft SQL Server 2005
- Chapter 6: Capacity Planning
- Chapter 7: Choosing a Storage System for Microsoft SQL Server 2005
- Chapter 8: Installing and Upgrading Microsoft SQL Server 2005
- Chapter 9: Configuring Microsoft SQL Server 2005 on the NetworkPart III: Microsoft SQL Server 2005 Administration
- Chapter 10: Creating Databases and Database Snapshots
- Chapter 11: Creating Tables and Views
- Chapter 12: Creating Indexes for Performance
- Chapter 13: Enforcing Data Integrity
- Chapter 14: Backup Fundamentals
- Chapter 15: Restoring Data
- Chapter 16: User and Security ManagementPart IV: Microsoft SQL Server 2005 Architecture and Features
- Chapter 17: Transactions and Locking
- Chapter 18: Microsoft SQL Server 2005 Memory Configuration
- Chapter 19: Data PartitioningPart V: Microsoft SQL Server 2005 Business Intelligence
- Chapter 20: Replication
- Chapter 21: Integration Services
- Chapter 22: Analysis Services
- Chapter 23: Reporting Services
- Chapter 24: Notification Services and Service BrokerPart VI: High Availability
- Chapter 25: Disaster Recovery Solutions
- Chapter 26: Failover Clustering Installation and Configuration
- Chapter 27: Log Shipping and Database MirroringPart VII: Performance Tuning and Troubleshooting
- Chapter 28: Troubleshooting, Problem Solving, and Tuning Methodologies
- Chapter 29: Database System Tuning
- Chapter 30: Using Profiler, Management Studio, and Database Engine Tuning Advisor
- Chapter 31: Dynamic Management Views
- Chapter 32: Microsoft SQL Server 2005 Scalability Options
- Chapter 33: Tuning Queries Using Hints and Plan GuidesGlossaryAbout the Authors