Microsoft SQL Server 2005 Administrator's Pocket Consultant


Portable and precise, this pocket-sized guide delivers immediate answers for the day-to-day administration of SQL Server 2005. Zero in on core support and maintenance tasks using quick-reference tables, instructions, and lists. You’ll get...

See more details below
Paperback (REV)
$29.99 price

Pick Up In Store

Reserve and pick up in 60 minutes at your local store

Other sellers (Paperback)
  • All (44) from $1.99   
  • New (6) from $1.99   
  • Used (38) from $1.99   
Sending request ...


Portable and precise, this pocket-sized guide delivers immediate answers for the day-to-day administration of SQL Server 2005. Zero in on core support and maintenance tasks using quick-reference tables, instructions, and lists. You’ll get the precise information you need to solve problems and get the job done-whether you’re at your desk or in the field!

Get fast facts to:

  • Install, configure, and tune SQL Server
  • Administer servers and server groups
  • Manage and optimize schemas, tables, indexes, and views
  • Create logins, configure permissions, assign roles, and perform other essential security tasks
  • Import, export, and transform data from various sources
  • Implement replication and data merging, and manage data publication and subscription
  • Plan and implement a comprehensive backup and recovery strategy
  • Monitor server activity and resolve performance issues
  • Take charge of automation and maintenance
Read More Show Less

Product Details

  • ISBN-13: 9780735621077
  • Publisher: Microsoft Press
  • Publication date: 11/30/2005
  • Series: Pocket Consultant Series
  • Edition description: REV
  • Pages: 578
  • Sales rank: 1,424,958
  • Product dimensions: 5.68 (w) x 8.02 (h) x 1.40 (d)

Meet the Author

William R. Stanek is a Microsoft MVP with 20+ years of experience in systems management and advanced programming. He is an award-winning author who’s written more than 100 books, including Windows 7 Administrator’s Pocket Consultant and Windows Server 2008 Inside Out. He is the series editor for the Pocket Consultant line of books.

Read More Show Less

Table of Contents

Who Is This Book For?;
How Is This Book Organized?;
Conventions Used in This Book;
Part I: Microsoft SQL Server 2005 Administration Fundamentals;
Chapter 1: Microsoft SQL Server 2005 Administration Overview;
SQL Server 2005 and Your Hardware;
Microsoft SQL Server 2005 Editions;
SQL Server and Windows;
Using the Graphical Administration Tools;
Using the Command-line Tools;
Chapter 2: Deploying Microsoft SQL Server 2005;
SQL Server Integration Roles;
Planning for Your SQL Server 2005 Deployment;
Running and Modifying SQL Server Setup;
Chapter 3: Managing the Surface Security, Access, and Network Configuration;
Getting Started with the Configuration Tools;
Using SQL Server 2005 Surface Area Configuration;
Configuring SQL Server Services;
Managing the Network and SQL Native Client Configuration;
Chapter 4: Configuring and Tuning Microsoft SQL Server;
Accessing SQL Server Configuration Data;
Techniques for Managing SQL Server Configuration Options;
Configuring SQL Server with Stored Procedures;
Part II: Microsoft SQL Server 2005 Administration;
Chapter 5: Managing the Enterprise;
Managing SQL Server Startup;
Using SQL Server Management Studio;
Managing SQL Server Groups;
Managing Servers;
Starting, Stopping, and Configuring SQL Server Agent;
Starting, Stopping, and Configuring the Microsoft Distributed Transaction Coordinator;
Starting, Stopping, and Configuring the Microsoft Search Service;
Working with Full-Text Search;
Managing Full-Text Catalogs;
Managing Server Activity;
Chapter 6: Configuring SQL Server with SQL Server Management Studio;
Managing the Configuration with SQL Server Management Studio;
Determining System and Server Information;
Configuring Authentication and Auditing;
Tuning Memory Usage;
Configuring Processors and Parallel Processing;
Configuring Threading, Priority, and Fibers;
Configuring User and Remote Connections;
Managing Server Settings;
Managing Database Settings;
Adding and Removing Active Directory Information;
Troubleshooting Configuration Problems;
Chapter 7: Core Database Administration;
Database Files and Logs;
Database Administration Basics;
Creating Databases;
Altering Databases and Their Options;
Managing Database and Log Size;
Manipulating Databases;
Tips and Techniques;
Chapter 8: Managing SQL Server 2005 Security;
Overview of SQL Server 2005 Security;
SQL Server 2005 Authentication Modes;
Special Purpose Logins and Users;
Managing Server Logins;
Configuring Server Roles;
Controlling Database Access and Administration;
Managing Database Permissions;
Part III: Microsoft SQL Server 2005 Data Administration;
Chapter 9: Manipulating Schemas, Tables, Indexes, and Views;
Working with Schemas;
Getting Started with Tables;
Table Essentials;
Working with Tables;
Managing Table Values;
Using Views;
Creating and Managing Indexes;
Column Constraints and Rules;
Chapter 10: Importing, Exporting, and Transforming Data;
Working with Integration Services;
Creating Packages with the SQL Server Import and Export Wizard;
Understanding BCP;
BCP Scripts;
Using the BULK INSERT Command;
Chapter 11: Linked Servers and Distributed Transactions;
Working with Linked Servers and Distributed Data;
Managing Linked Servers;
Chapter 12: Implementing Snapshot, Merge, and Transactional Replication;
An Overview of Replication;
Planning for Replication;
Distributor Administration;
Creating and Managing Publications;
Subscribing to a Publication;
Part IV: Microsoft SQL Server 2005 Optimization and Maintenance;
Chapter 13: Profiling and Monitoring Microsoft SQL Server 2005;
Monitoring Server Performance and Activity;
Working with Replication Monitor;
Working with the Event Logs;
Monitoring SQL Server Performance;
Solving Performance Problems with Profiler;
Chapter 14: Backing Up and Recovering SQL Server 2005;
Creating a Backup and Recovery Plan;
Selecting Backup Devices and Media;
Using Backup Strategies;
Creating a Backup Device;
Performing Backups;
Restoring a Database;
Restoring the Master Database;
Mirroring Databases;
Chapter 15: Database Automation and Maintenance;
Overview of Database Automation and Maintenance;
Using Database Mail;
Using SQL Server Agent;
Managing Alerts;
Managing Operators;
Scheduling Jobs;
Automating Routine Server-to-Server Administration Tasks;
Multiserver Administration;
Database Maintenance;
Managing Log Shipping;
Using Mirroring and Log Shipping;
Appendix : William R. Stanek;

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
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 all of 3 Customer Reviews
  • Anonymous

    Posted August 16, 2008

    Excellent Book!

    Definitely a good book to help you administer a SQL Server Database. The chapters are very detailed and the index in the back is well done for those looking for something specific.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted January 30, 2007

    Exceptional Value

    I'm a big fan of William Stanek's Pocket Consultant series. Stanek makes learning about difficult subjects easy by writing clearly and concisely. Plus this is a terrific value as Stanek packs more detail into this 550-page book than books twice the size. The best resource for administration.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted February 3, 2006

    Microsoft SQL Server 2005 Administrator¿s Pocket Consultant

    With a new set of tools, Administering SQL 2005 is quite different to previous versions of SQL Server, this books provides a very useful overview of the new graphical administration programs, as well as detailing many of the commonly used administration stored procedures. The book covers all aspects of administering SQL Server 2005 and will provide a handy reference to anyone whose function it is to maintain a SQL 2005 system. I found the book very readable and I especially like the side notes, which come in Note, Tip, Caution, Real World and Best Practice flavours. These give very useful practical information, which will help you avoid some the common problems that get posted to online newsgroups. Martin Bell (MVP) 28/1/2006

    Was this review helpful? Yes  No   Report this review
Sort by: Showing all of 3 Customer Reviews

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