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.
AcknowledgmentsIntroductionPart 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
|
0121 702 2828 
Published by: MICROSOFT PRESS