Microsoft® SQL Server(TM) 2000 Administrator's Pocket Consultant (IT-Administrator's Pocket Consultant) [Paperback]

William R. Stanek (Author)

Book Description

Publication Date: October 27, 2000 | ISBN-10: 0735611297 | ISBN-13: 978-0735611290 | Edition: 2000 ed.

MICROSOFT® SQL SERVER™ 2000 ADMINISTRATOR’S POCKET CONSULTANT is the ideal concise, immediate reference you’ll want with you at all times as you deal with the details of Microsoft SQL Server 2000 database administration. Whether you handle administration for 50 users or 5000, this hands-on, fast-answers guide focuses on what you need to do to get the job done quickly.

With extensive easy-to-read tables, lists, and step-by-step instructions, it’s the portable, readable guide that will consistently save you time and minimize system downtime by giving you the right information right now.

This hands-on guide gives you the fast answers you need to:

• Grasp the fundamentals. Understand the SQL Server 2000 architecture; learn administration tools, techniques, and concepts; and discover how to modify configuration settings to optimize memory usage, take advantage of parallel processors, and more.
• Complete core tasks. Perform basic tasks to create and manage databases, servers, and server groups; and create logons, configure logon permissions, assign roles, and conduct other essential security measures.
• Administer databases. Manage tables, indexes, and views; query and manipulate data; import and export data; and integrate SQL Server data with other data sources.
• Control distributed data. Administer linked servers and distributed transactions, configure data merging and replication, and supervise data publication and subscription.
• Optimize and maintain databases. Profile and monitor SQL Server, conduct data backup and recovery, and take charge of automation and maintenance.

Editorial Reviews

Amazon.com Review

If specialization is for insects, those of us who have only two legs are bound to need reminders when we sit down to perform a specialized task. For those times in which the specialized task at hand involves the latest version of Microsoft's high-end database management system (DBMS), Microsoft SQL Server 2000 Administrator's Pocket Consultant will provide how-to answers on the double-quick. This small, inch-thick volume fits nicely into a briefcase, and opens flat for easy reference. It makes little attempt to explain how SQL Server works, assuming instead that the reader knows what he or she needs. For example, a quick scan of the index for "Logins, Assigning Roles for Multiple" yields a reference to a page that explains exactly what to do, step by step.

Procedures are a large part of the appeal of this book; value tables and Transact-SQL syntax documentation contribute the rest. A typical value table lists all standard database roles, along with commentary on what sort of user is appropriate for each role. Transact-SQL documentation includes generic "all available options" statements of syntax, followed by usage examples. Deeper explanations of what each option does would make the syntax documentation stronger, but what's here is certainly enough to jog readers' memories and point them to heavier reference material, if they need it. Keep this book handy if your job requires you to hop from DBMS to DBMS. --David Wall

Topics covered:

• Installing and configuring Microsoft SQL Server 2000
• Creating databases
• Controlling access to databases
• Manipulating database contents with Transact-SQL
• Backup, recovery, and performance tuning
• Data Transformation Services (DTS)

About 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.

Product Details

• Paperback: 453 pages
• Publisher: Microsoft Press; 2000 ed. edition (October 27, 2000)
• Language: English
• ISBN-10: 0735611297
• ISBN-13: 978-0735611290
• Product Dimensions: 8 x 5.6 x 1.3 inches
• Shipping Weight: 1.4 pounds
• Average Customer Review: 4.4 out of 5 stars  See all reviews (16 customer reviews)
• Amazon Best Sellers Rank: #1,371,109 in Books (See Top 100 in Books)

Customer Reviews

Most Helpful Customer Reviews

21 of 21 people found the following review helpful:

5.0 out of 5 stars Uterly indispensible, the only sql server ref you need, October 14, 2001

By 

David Worthington - See all my reviews

This review is from: Microsoft® SQL Server(TM) 2000 Administrator's Pocket Consultant (IT-Administrator's Pocket Consultant) (Paperback)

As a web/dba I use sql server, IIS and windows 2000 server extensively. Last year when I was just getting started I discovered this little gem and it was what set me on the right path. I found this book to be utterly indispensible. I actually have two copies that one I use at home when I work in my own projects and one I use at work.

Again in this book as with others in the series I have found single chapters that alone were worth the price of the book, and in a book filled with such chapters you cannot go wrong. The chapter I use the most is 2. In this chapter covers configuring and tuning the sql server database. The chapter starts by looking at guidelines you can use to choose server hardware covering memory, CPU, drives, and more then goes into tools, services and more that you can use to optimize the sql server. In addition to covering the graphical interface, the book covers command-line tools extensive and I found this to be invaluable.

Mr. Stanek includes a best practice tip on page 35 that caused a light bulb to go off in my head and helped me resolve a problem with our databases. This tip covers memory usage in various situations and how you can optimize the memory configuration. The chapter goes on and on like this giving out secrets that other admins didn't want to share with someone like me who was just getting started. In short I think the chapter gave me the equivalent of several years worht of in the field knowledge and since I didn't have years to prove myself this was incredibly helpful.

13 of 13 people found the following review helpful:

5.0 out of 5 stars Definitive SQL Server 2000 guide in a small package, November 19, 2000

By 

James Werner - See all my reviews

This review is from: Microsoft® SQL Server(TM) 2000 Administrator's Pocket Consultant (IT-Administrator's Pocket Consultant) (Paperback)

Hats off to author William Stanek for another fine Pocket Consultant. I have 5 of these books in my library now (Windows NT 4, Windows 2000, Exchange 2000, SQL Server 7 and SQL Server 2000.) Since I picked up the first Pockete Consultant a yaer ago I haven't found a daily administration question that wasn't answered. You'll find that SQL Server 2000 Pocket Consultant is more of the same. The attention to detail and the focus on day to day administration tasks is fantastic!

Mr. Stanek always starts with an overview of the subject of discussion and then digs right in. I've found that this book (and the rest in the series) answer 100% of my questions quickly and meanwhile the 1,000 page luggables used by my colleagues just get them frustrasted. I've made quite a few converts in the office.

The nice thing about these books is the day to day focus. You get what you need to accomplish your task spelled out clearly and concisely in a style that I've found that only Mr. Stanek can deliver. It is refreshing. Now I'm not saying the books are pefrect. If you need to learn from scratch this isn't the answer. Look elsewhere. If you need to brush up and extend your skills to new stuff (like going from SQL 6.5 or SQL 7 to SQL 2000), is a good choice. If you need a book to help with day to day, is a good choice. If you need a book to put in your backpack and carry with you, is a good choice.

Last I want to say thank you to Mr. Stanek. Thank you, I'm looking forward to more. --JW

11 of 11 people found the following review helpful:

5.0 out of 5 stars Great Book, August 16, 2004

By 

W. Meyers "Wally" (New York, NY USA) - See all my reviews
(REAL NAME)   

This review is from: Microsoft® SQL Server(TM) 2000 Administrator's Pocket Consultant (IT-Administrator's Pocket Consultant) (Paperback)

A lot of SQL Server books give you the same information included already in Books Online. SQL Server 2000 Administrator's Pocket Consultant is an excellent complement for Books Online, TechNet and MSDN. It covers similar topics, but it digs in where necessary, provides best practices, tips to the internal operations, explaining how SQL Server actually works, with unique information only available in this book.

I always want to know how things work because it helps me to understand the behaviour of a system. In many cases if you don't know how things work it could drive you to some misunderstandings. Here is where SQL Server Pocket Consultant helps out and Stanek has excellent teaching skills.

The book is very compact and full of information. It's all in the details. Chapter 2 "Configuring and Tuning" is a real gem. It helped so much with server and database tuning. Chapter 5 "SQL Server Security" is excellent on the security details. Chapter 7 provides deep detail of DTS and BCP. The final part of the book is the best, in my opinion. It covers performance, maintenance and optimization.

The book's small size makes it easy to take with you where ever you go and its good enough that you'll want to. Overall excellent guide ot sql server.