|
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:
Part 1 - Introduction to Microsoft SQL Server 2005
What's New in Microsoft SQL Server 2005
Microsoft SQL Server 2005 Editions, Capacity Limits & Licensing
Roles & Responsibilities of the Microsoft SQL Server DBA
Part 2 - System Design & Architecture
I/O Subsystem Planning & RAID Configuration
32-bit versus 64-bit Platforms and Microsoft SQL Server 2005
Capacity Planning
Choosing a Storage System for Microsoft SQL Server 2005
Installing & Upgrading Microsoft SQL Server 2005
Configuring Microsoft SQL Server 2005 on the Network
Part 3 - Microsoft SQL Server 2005 Administration
Creating Databases & Database Snapshots
Creating Tables & Views
Creating Indexes for Performance
Enforcing Data Integrity
Backup Fundamentals
Restoring Data
User & Security Management
Part 4 - Microsoft SQL Server 2005 Architecture & Features
Transactions & Locking
Microsoft SQL Server 2005 Memory Configuration
Data Partitioning
Part 5 - SQL Server 2005 Business Intelligence
Replication
Integration Services
Analysis Services
Reporting Services
Notification Services & Service Broker
Part 6 - High Availability
Disaster Recovery Solutions
Failover Clustering Installation & Configuration
Log Shipping & Database Mirroring
Part 7 - Performance Tuning & Troubleshooting
Troubleshooting, Problem Solving, & Tuning Methodologies
Database System Tuning
Using Profiler, Management Studio & Database Engine Tuning Advisor
Dynamic Management Views
Microsoft SQL Server 2005 Scalability Options
Tuning Queries using Hints and Plan Guides
Glossary
Index
|
