Programming Books C Java PHP Python Learn more Browse Programming Books

Sorry, this item is not available in
Image not available for
Image not available

To view this video download Flash Player


Sign in to turn on 1-Click ordering
More Buying Choices
Have one to sell? Sell yours here
Tell the Publisher!
I'd like to read this book on Kindle

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Admin911: SQL Server 2000 [Paperback]

Brian Knight
4.8 out of 5 stars  See all reviews (13 customer reviews)

List Price: $43.95
Price: $41.75 & FREE Shipping. Details
You Save: $2.20 (5%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Only 1 left in stock.
Ships from and sold by Gift-wrap available.
Want it Tuesday, July 15? Choose One-Day Shipping at checkout. Details
Free Two-Day Shipping for College Students with Amazon Student

Shop the new
New! Introducing the, a hub for Software Developers and Architects, Networking Administrators, TPMs, and other technology professionals to find highly-rated and highly-relevant career resources. Shop books on programming and big data, or read this week's blog posts by authors and thought-leaders in the tech industry. > Shop now

Book Description

May 21, 2001 0072130970 978-0072130973 1
SQL Server market - There are currently 15 million users of SQL Server 7. Sales are averaging over 1 million licenses per month. SQL Server 2000, announced 26/9/00, has new features that make upgrading a must for the current installed base; Admin911 the series - This series is the administrator's survival guides. These compact resources will save hundreds of hours of troubleshooting time; New technology - Admin911: SQL Server 2000 provides focused and narrow coverage with optimal solutions to given situations, the exact fixes to problems and tweaks for a specific need in managing SQL Server 2000

Customers Who Bought This Item Also Bought

Editorial Reviews


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

From the Back Cover

Survival Guide for System Administrators

Configure, manage, and optimize SQL Server 2000 for peak performance with help from this unique resource. Inside, you'll find immediate solutions to problems involving database and server settings, multiple instances, startup parameters, service packs, stored procedures, and much more. The book also covers the many administrative features built in to SQL Server 2000, including SQL Server Agent, Enterprise Manager, Multi Server Administration, and System Monitor. Get this book and save yourself hundreds of hours of troubleshooting time.

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 using the system monitor and alerts Optimize T-SQL and stored procedures Scale SQL Server using linked servers and Distributed Partitioned Views (DPVs) Troubleshoot database performance Implement disaster recovery procedures

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-known problems and pitfalls

Product Details

  • Series: Admin911
  • Paperback: 369 pages
  • Publisher: McGraw-Hill Companies; 1 edition (May 21, 2001)
  • Language: English
  • ISBN-10: 0072130970
  • ISBN-13: 978-0072130973
  • Product Dimensions: 0.9 x 7.3 x 9.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 Best Sellers Rank: #3,162,674 in Books (See Top 100 in Books)

More About the Author

Brian Knight, SQL Server MVP, MCITP, MCSE, MCDBA, is the owner and founder of Pragmatic Works. He is also the co-founder of and He runs the local SQL Server users group in Jacksonville (JSSUG). Brian is a contributing columnist at several technical magazines and does regular webcasts at Jumpstart TV. He is the author of 10 SQL Server books. Brian has spoken at conferences like PASS, SQL Connections and TechEd and many Code Camps. His blog can be found at

Customer Reviews

4.8 out of 5 stars
4.8 out of 5 stars
3 star
2 star
1 star
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
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..
Comment | 
Was this review helpful to you?
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
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 !!!
Comment | 
Was this review helpful to you?
7 of 7 people found the following review helpful
5.0 out of 5 stars Buy this today... June 11, 2001
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.
Comment | 
Was this review helpful to you?
7 of 7 people found the following review helpful
4.0 out of 5 stars Good resource July 21, 2003
By Mike
This is an excellent book. The coverage of SQL Server is very solid. However, if you plan to purchase the author's newest book, SQL Server 2000 for Experienced DBAs, DO NOT purchase this book. The newer book covers everything this book covers, in addition to the topic of high availability. Owning both books would be completly redundant, a mistake I personally made.
Comment | 
Was this review helpful to you?
6 of 6 people found the following review helpful
5.0 out of 5 stars a MUST book June 22, 2001
By A Customer
Format:Paperback|Verified Purchase
Normally, I don't buy books from Osborne. But this book blew me away with its tips. This book can save you hundreds of hours in SQL server downtime, and amaze your own DBA colleagues with tips and tricks that are largely undocumented. I won 8 books on SQL servers and this has been one of two books reference whenever there is a problem. Buy it, try it, and you won't regret it.
Comment | 
Was this review helpful to you?
4 of 4 people found the following review helpful
5.0 out of 5 stars Must Have for SQL Server DBA September 3, 2002
This is one of those most have books for any SQL Server DBAs reference library.
Brian Knight covers a LOT of different items and goes into sufficient detail on all topics. Probably the best real world book on SQL Server administration out there. I've worked with SQL Server for over 5 years and have been a senior DBA over a large enterprise SQL Server farm but I still learned a great deal from this book.
Comment | 
Was this review helpful to you?
6 of 7 people found the following review helpful
5.0 out of 5 stars Belongs on Every Bookshelf August 10, 2001
I can't recommend this book strongly enough. It goes beyond the basics that you normally get to show you the types of tips that you only get from years of experience, trial and error etc. This is like having a 10 year veteran by your side. This book will save you hours and hours of frustration, and your systems will run better. The best part about this book is the style in which it is written. Almost conversational - its not too technical and very easy to read. This is a book I have read cover to cover once - now I am on my second trip through - only this time with a pad of paper and a pen. The book belongs on every DBA's bookshelf.
Comment | 
Was this review helpful to you?
Most Recent Customer Reviews
5.0 out of 5 stars A concise and friendly reference
This book is a concise and friendly guide that is great for admins. It proved itself the first time that I had a problem allowing me to quickly find the answer I needed.
Published on February 26, 2002 by Chris Gallelli
5.0 out of 5 stars Paid for itself in the first day
This book is a must have for both administrators and developers. I own several books on SQL Server but none have paid dividends like this one did. Read more
Published on January 15, 2002 by G. Solomon
5.0 out of 5 stars I hate MSSQLServer, but I like this book ^_^
I think it is an EXCELLENT book about SQLServer 2000. There're a lot of incredible skills in it. It's for SQL-DBA and you'll got tired of this book if you are beginner. Read more
Published on November 7, 2001 by jscz_ch
5.0 out of 5 stars My favorite for information
I have several books on SQL Server 2000. This is the best one, because the author gives a personal viewpoint to the material. It is filled with suggestions and explanations. Read more
Published on July 1, 2001 by Lefty
5.0 out of 5 stars Doesn't Insult Your Intelligence!
Finally a book that doesn't insult your intelligence as an administrator. I agree with the other reviewer, this book assumes you know all the basics and jumps right into specific... Read more
Published on June 5, 2001
5.0 out of 5 stars Great Advanced Book With Practical Advice
I've been looking for a long time for a good admin book. I hate buying an entire book just to only have one paragraph on text I didn't know already. Read more
Published on May 26, 2001
Search Customer Reviews
Search these reviews only

Sell a Digital Version of This Book in the Kindle Store

If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store. Learn more


There are no discussions about this product yet.
Be the first to discuss this product with the community.
Start a new discussion
First post:
Prompts for sign-in

Look for Similar Items by Category