Microsoft SQL Server 2005 Administrator's Companion

( 1 )

Overview

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
Paperback (REV)
$41.15
BN.com price
(Save 31%)$59.99 List Price
Other sellers (Paperback)
  • All (45) from $1.99   
  • New (7) from $9.76   
  • Used (38) from $1.99   
Sending request ...

More About This Book

Overview

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 booktech@oreilly.com.

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

Acknowledgments;
Contributing Authors;
Introduction;
How to Use this Book;
What’s in This Book;
About the CD;
Computer System Requirements;
Support;
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.3 Views;
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;
Glossary;
About the Authors;

Read More Show Less

Customer Reviews

Average Rating 1
( 1 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(1)
Sort by: Showing 1 Customer Reviews

  • Anonymous

    Posted Wed Oct 20 00:00:00 EDT 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)