Admin911: SQL Server 2000 (Paperback)

~ (Conductor) "To understand the power and behavior of SQL Server 2000, it's helpful to look at its roots..." (more)
Key Phrases: linked server name, numbers for the identity column, sysadmin rights, Enterprise Manager, Query Analyzer, System Monitor (more...)

Editorial Reviews

Review

"Call on Admin911 to learn what's going on with your network, to understand your options, and to pick the right solutions." -David Chemicoff, Windows 2000 Magazine"

Product Description

"Call on Admin911 to learn what's going on with your network, to understand your options, and pick the right solutions." --David Chernicoff, Windows 2000 Magazine This survival guide for SQL Server 2000 administrators explains how to implement preventive problem-solving strategies and minimize downtime. Helpful call-outs throughout the book include: Take Command--Specific command-line utilities relating to the topic at hand Code Blue--Things to do when your system is in trouble Bug Alert--Common and little-know problems and pitfalls This book will also help you: *Manage SQL Server, including memory and security *Optimize and automate administration using SQL Server Agent and other tools *Debug Jobs *Monitor and tune SQL Server unsing the system monitor and alerts *Optimize T-SQL and stored procedures *Scale SQL Server using linked servers and Distributed Partitioned Views *Troubleshoot database performance *Implement disaster recovery procedures.

See all Editorial Reviews

Product Details

• Paperback: 369 pages
• Publisher: McGraw-Hill Companies; 1 edition (May 21, 2001)
• Language: English
• ISBN-10: 0072130970
• ISBN-13: 978-0072130973
• Product Dimensions: 9.1 x 7.4 x 1 inches
• Shipping Weight: 1.4 pounds (View shipping rates and policies)
• Average Customer Review: 4.8 out of 5 stars  See all reviews (13 customer reviews)
• Amazon.com Sales Rank: #605,227 in Books (See Bestsellers in Books)

Customer Reviews

Most Helpful Customer Reviews

7 of 7 people found the following review helpful:

4.0 out of 5 stars Great book, but not so much 911 in it really, March 25, 2002

By	John Ness (Oberbueren, Switzerland) - See all my reviews (REAL NAME)

If you're thinking of buying this book, because you've tried everything in Microsoft's online manual "Microsoft SQL Server 7.0 Performance Tuning Guide" and are still having some performance problems, then this book could be your solution.

It helped me solve some of the problems I was having with our productive server and helped me understand some basics a bit better than before. It does not contain everything you need to know, but gives you some ideas how you have to look for further information and what you have to look for.

It contains some good reference material, but not all of the hidden features. As with every book under 1000 pages this is not THE bible for the DBA but is a complementary book that will provide some invaluable information not found elsewhere. This book was well worth the price..

7 of 7 people found the following review helpful:

5.0 out of 5 stars SQL Server 2000 Database Admin MUST HAVE !!!, March 20, 2002

By	"jimthedba" (Falls Church, VA United States) - See all my reviews

SQL Server 2000 Administration headaches? ... Well if you need a rapid reference on system administrative functions that could not only save your company $$$ on downtime and system availability but improve your response to difficult situations this is a DBA must have. I have purchased more books attempting to get reliable information and tips to make my Administration of SQL Server Database systems robust, reliable, and rapid on response I have finally found the information I needed in "One" book. I would recommend this book for Mid to Senior level Database Administrators and as a guide for training Junior level DBA's to prevent bad habits and teach the proper habits of monitoring, managing and maintaining SQL Server databases overall. Oh and the nice touch is that TIPS: and CAUTION: notices throughout the book educate the creative "out of the box" approach to proper system risk management. I hope Mr. Knight considers sharing his talent with future Administrative Guides !!!

7 of 7 people found the following review helpful:

5.0 out of 5 stars Buy this today..., June 11, 2001

By	Rodney D. Trent "Rod Trent" (Middletown, OH United States) - See all my reviews (REAL NAME)

This is the top book for SQL 2000 administration. Mr. Knight has excelled in putting together a book that is sensible, readable, and highly critical for day-to-day administration of SQL Server 2000. Folks are always asking for my opinion on a book to help them get over some of the advanced tasks of SQL Server. This is it! It goes a long way answering those questions that you ask yourself everyday. Instead of hunting on the Internet every time you need a solution, carry this book with you.