Microsoft SQL Server 2005 Administrator's Companion

( 1 )


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 ...

See more details below
Other sellers (Paperback)
  • All (32) from $1.99   
  • New (3) from $5.00   
  • Used (29) from $1.99   
Sending request ...


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.

A Note Regarding the CD or DVD

The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to

Read More Show Less

Editorial Reviews

From Barnes & Noble
The Barnes & Noble Review
If you're responsible for deploying or administering SQL Server 2005, this book's a goldmine. Straight from Microsoft, it delivers authoritative guidance on everything from planning to tuning, high availability to business intelligence.

Microsoft SQL Server 2005 Administrator's Companion offers immense value for DBAs working in any environment, including the most mission-critical. Upfront, it'll help you with capacity planning, then walk you through every facet of installation, upgrading, and network configuration.

It covers all the core DBA fundamentals (creating databases, tables, views, indexes, backup/restore, memory allocation, data partitioning, and so forth). But it includes equally detailed coverage of integration, analysis, reporting, and notification services for business intelligence. And when it's time to implement failover clustering and database mirroring, it'll help you there, too.

Best of all, its final six chapters distill Microsoft's immense experience in tuning and troubleshooting. You deserve that knowledge, don't you? Bill Camarda, from the June 2007 Read Only

Read More Show Less

Product Details

  • ISBN-13: 9780735621985
  • Publisher: Microsoft Press
  • Publication date: 12/13/2006
  • Series: Admin Companion Series
  • Edition description: REV
  • Pages: 1232
  • Product dimensions: 7.50 (w) x 9.20 (h) x 2.32 (d)

Meet the Author

Edward Whalen is an expert in database performance, administration, and backup recovery solutions.

Burzin Patel is a Microsoft program manager focusing on SQL Server application integration and database management.

Marcilina Garcia specializes in performance benchmarks, database design, and configuration.

Stacia Misner, MCITP, MCTS, is a consultant and trainer specializing in Microsoft business intelligence solutions. She has more than 20 years of IT experience and has written several books on SQL Server, including Microsoft SQL Server 2008 Reporting Services Step by Step. Stacia is also one of the first to earn the new SQL Server Analysis Services Maestro certification.

Victor Isakov, MCTS, MCITP, is a certified trainer, author, and expert on SQL Server 2005.

Read More Show Less

Table of Contents

Contributing Authors;
How to Use this Book;
What’s in This Book;
About the CD;
Computer System Requirements;
Talk to Us;
Part I: Introduction to Microsoft SQL Server 2005;
Chapter 1: What’s New in Microsoft SQL Server;
1.1 New Hardware Support;
1.2 Data Availability;
1.3 Performance;
1.4 Enhancements to Existing Features;
1.5 Tools and Utilities;
1.6 Business Intelligence Features;
1.7 Summary;
Chapter 2: Microsoft SQL Server 2005 Editions, Capacity Limits, and Licensing;
2.1 SQL Server 2005 Editions;
2.2 Understanding Windows Platform Support;
2.3 Understanding Processors and Memory Limits;
2.4 Factoring in Head-Room;
2.5 Comparing SQL Server 2005 Editions;
2.6 SQL Server 2005 Capacity Limits;
2.7 Understanding SQL Server 2005 Licensing;
2.8 Licensing Considerations for High-Availability Environments;
2.9 SQL Server 2005 Pricing;
2.10 Summary;
Chapter 3: Roles and Responsibilities of the Microsoft SQL Server DBA;
3.1 Different Kinds of DBA;
3.2 Basic Duties of a DBA;
3.3 DBA Tips, Guidelines, and Advice;
3.4 Summary;
Part II: System Design and Architecture;
Chapter 4: I/O Subsystem Planning and RAID Configuration;
4.1 I/O Fundamentals;
4.2 Redundant Array of Independent Disks (RAID);
4.3 SQL Server I/O Overview;
4.4 Planning the SQL Server Disk Layout;
4.5 Summary;
Chapter 5: 32-Bit Versus 64-Bit Platforms and Microsoft SQL Server 2005;
5.1 CPU Basics;
5.2 Windows Versions;
5.3 SQL Server 2005 Options;
5.4 Taking Advantage of 64-Bit SQL Server;
5.5 Summary;
Chapter 6: Capacity Planning;
6.1 Principles of Capacity Planning;
6.2 CPU Capacity Planning;
6.3 Memory Capacity Planning;
6.4 I/O Capacity Planning;
6.5 Network Capacity Planning;
6.6 Growth Considerations;
6.7 Benchmarking and Load Testing;
6.8 Benchmarking the I/O Subsystem;
6.9 Using MOM for Capacity Planning;
6.10 Summary;
Chapter 7: Choosing a Storage System for Microsoft SQL Server 2005;
7.1 Interconnect and Protocol Technologies;
7.2 Storage Systems;
7.3 Storage Considerations for SQL Server 2005;
7.4 Summary;
Chapter 8: Installing and Upgrading Microsoft SQL Server 2005;
8.1 Preinstallation Planning;
8.2 Installing SQL Server 2005;
8.3 Upgrading to SQL Server 2005;
8.4 Reading the SQL Server 2005 Setup Log Files;
8.5 Uninstalling SQL Server 2005;
8.6 Using SQL Server Surface Area Configuration;
8.7 Summary;
Chapter 9: Configuring Microsoft SQL Server 2005 on the Network;
9.1 Understanding the SQL Server Network Services;
9.2 SQL Native Client (SNAC);
9.3 Configuring Network Protocols;
9.4 Using ODBC Data Source Names (DSN);
9.5 SQL Server Browser Service;
9.6 Network Components and Performance;
9.7 Network Monitoring;
9.8 Summary;
Part III: Microsoft SQL Server 2005 Administration;
Chapter 10: Creating Databases and Database Snapshots;
10.1 Understanding the Database Structure;
10.2 Understanding System Databases;
10.3 Creating User Databases;
10.4 Viewing Database Details;
10.5 Deleting a Database;
10.6 Real-World Database Layouts;
10.7 Using Database Snapshots;
10.8 Summary;
Chapter 11: Creating Tables and Views;
11.1 Table Fundamentals;
11.2 Creating, Modifying, and Dropping Tables;
11.4 System Views;
11.5 Summary;
Chapter 12: Creating Indexes for Performance;
12.1 Index Fundamentals;
12.2 How to Optimally Take Advantage of Indexes;
12.3 Index Types;
12.4 Designing Indexes;
12.5 Creating Indexes;
12.6 Index Maintenance and Tuning;
12.7 Summary;
Chapter 13: Enforcing Data Integrity;
13.1 What Is Data Integrity?;
13.2 Enforcing Integrity with Constraints;
13.3 Summary;
Chapter 14: Backup Fundamentals;
14.1 Why Perform Backups with a Highly Available System?;
14.2 System Failures That Require Backups;
14.3 Purpose of the Transaction Log;
14.4 Microsoft SQL Server Automatic Recovery;
14.5 Recovery Models and Logging;
14.6 Types of Backups;
14.7 Backup and Media Fundamentals;
14.8 Backup Strategy;
14.9 Backing Up System Databases;
14.10 Summary;
Chapter 15: Restoring Data;
15.1 Practicing and Documenting Restore Procedures;
15.2 Restore and Recovery Concepts;
15.3 Restoring Data from Backups;
15.4 Summary;
Chapter 16: User and Security Management;
16.1 Principals;
16.2 Securables;
16.3 Permissions;
16.4 Summary;
Part IV: Microsoft SQL Server 2005 Architecture and Features;
Chapter 17: Transactions and Locking;
17.1 What Is a Transaction?;
17.2 ACID Properties;
17.3 Committing Transactions;
17.4 Transaction Rollbacks;
17.5 Transaction Locking;
17.6 Viewing Locks;
17.7 Locking Hints;
17.8 Blocking and Deadlocks;
17.9 Isolation Levels;
17.10 Summary;
Chapter 18: Microsoft SQL Server 2005 Memory Configuration;
18.1 Buffer Cache;
18.2 SQL Server Memory Allocation;
18.3 Summary;
Chapter 19: Data Partitioning;
19.1 Partitioning Fundamentals;
19.2 Designing Partitions;
19.3 Creating Partitions;
19.4 Viewing Partition Information;
19.5 Maintaining Partitions;
19.6 Using Partitions;
19.7 Partitioning Scenarios;
19.8 Summary;
Part V: Microsoft SQL Server 2005 Business Intelligence;
Chapter 20: Replication;
20.1 Replication Fundamentals;
20.2 Uses of Replication;
20.3 Replication Concepts;
20.4 Types of Replication;
20.5 Components of Replication;
20.6 Configuring Replication;
20.7 Creating a Publication with SQL Statements;
20.8 Creating a Subscription with SQL Statements;
20.9 Configuring an Oracle Publication;
20.10 Managing Replication;
20.11 Monitoring and Tuning Replication;
20.12 Summary;
Chapter 21: Integration Services;
21.1 What Is Integration Services?;
21.2 Designing Packages;
21.3 Deploying Packages;
21.4 Summary;
Chapter 22: Analysis Services;
22.1 What Is Analysis Services?;
22.2 Designing Analysis Services Projects;
22.3 Managing Analysis Services;
22.4 Summary;
Chapter 23: Reporting Services;
23.1 What Is Reporting Services?;
23.2 Authoring Reports;
23.3 Managing Reporting Services;
23.4 Summary;
Chapter 24: Notification Services and Service Broker;
24.1 What Is Notification Services?;
24.2 Developing Notification Services Applications;
24.3 Using Notification Services Applications;
24.4 What Is Service Broker?;
24.5 Implementing Service Broker Applications;
24.6 Managing Service Broker Applications;
24.7 Summary;
Part VI: High Availability;
Chapter 25: Disaster Recovery Solutions;
25.1 What Are High Availability and Disaster Recovery?;
25.2 Fundamentals of Disaster Recovery and Disaster Survival;
25.3 Microsoft SQL Server Disaster Recovery Solutions;
25.4 Summary;
Chapter 26: Failover Clustering Installation and Configuration;
26.1 What Is a Cluster?;
26.2 Clustering Concepts;
26.3 Overview of MSCS;
26.4 Examples of Clustered Systems;
26.5 Planning Your Configuration;
26.6 Installing and Configuring Windows 2003 and SQL Server 2005 Clustering;
26.7 Summary;
Chapter 27: Log Shipping and Database Mirroring;
27.1 Types of Data Loss;
27.2 Log Shipping;
27.3 Database Mirroring;
27.4 Summary;
Part VII: Performance Tuning and Troubleshooting;
Chapter 28: Troubleshooting, Problem Solving, and Tuning Methodologies;
28.1 Troubleshooting and Problem Solving;
28.2 Performance Tuning and Optimization;
28.3 Troubleshooting and Tuning Methodology;
28.4 The Need for Documentation;
28.5 Summary;
Chapter 29: Database System Tuning;
29.1 Monitoring and Tuning Hardware;
29.2 Monitoring and Tuning SQL Server;
29.3 Tuning the Database Layout;
29.4 Tuning the tempdb System Database;
29.5 Summary;
Chapter 30: Using Profiler, Management Studio, and Database Engine Tuning Advisor;
30.1 Overview of SQL Server Tools;
30.2 Using SQL Server Management Studio;
30.3 Using SQL Server Profiler;
30.4 Using the Database Engine Tuning;
30.5 Summary;
Chapter 31: Dynamic Management Views;
31.1 Understanding Dynamic Management Views;
31.2 Using Dynamic Management Views;
31.3 Creating a Performance Data Warehouse;
31.4 Summary;
Chapter 32: Microsoft SQL Server 2005 Scalability Options;
32.1 Scalability Options;
32.2 Scaling Up;
32.3 Scaling Out;
32.4 Summary;
Chapter 33: Tuning Queries Using Hints and Plan Guides;
33.1 Understanding the Need for Hints;
33.2 Microsoft SQL Server 2005 Hints;
33.3 Plan Guides;
33.4 Summary;
About the Authors;

Read More Show Less

Customer Reviews

Average Rating 1
( 1 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Terms of Use.
  • - Barnes & reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing 1 Customer Reviews
  • Anonymous

    Posted October 20, 2010

    No text was provided for this review.

Sort by: Showing 1 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)