Features
- Cover Type: Paperback with 453 pages
- Published by: Microsoft Press
- Edition: 1st Edition October 27, 2000
- Written in: English
- ISBN 10 Number: 0735611297
- ISBN 13 Number: 978-0735611290
-
Book Dimensions:
8 x 5.6 x 1.3 inches
- Weighs: 1.4 pounds
Product 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)
Product Description
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 fo
Reader ReviewsThis book makes a good administrative tool, particularly for people for whom SQL admin is one of many responsibilities and who therefore can't spend the time for in-depth training. One main flaw in this book is that it pretty much ignores the design aspect of setting up a new database and/or server. For example, the book lacks any information on best practices for the physical layout (files, drives, RAID, etc) or security. It assumes someone (a consultant?) knew what they were doing and set up the server and databases. Personally, I see this as part of the administrator's role. Another major shortfall of this book is that it excludes clustering completely, and as databases are more and more critical to companies, clustering is gaining in popularity. This book is designed as a reference book and it does a decent job as that. The layout, contents, and index make finding what you need very easy. If, however, you want a book to read cover-to-cover in order to learn SQL administration, this is not it.
Search for books at
