Admin911: SQL Server 2000 [Paperback]

Brian Knight (Author)

Book Description

ISBN-10: 0072130970 | ISBN-13: 978-0072130973 | Publication Date: May 21, 2001 | Edition: 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

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"

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

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.3 x 7.4 x 0.9 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: #1,871,676 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 SQLServerCentral.com and JumpstartTV.com. 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 http://www.pragmaticworks.com.

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)   

This review is from: Admin911: SQL Server 2000 (Paperback)

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

This review is from: Admin911: SQL Server 2000 (Paperback)

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 review is from: Admin911: SQL Server 2000 (Paperback)

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.