SQL Server 2000 Administrator's Pocket Consultant (IT-Administrator's Pocket Consultant) | 
 enlarge | Author: William Stanek
Brand: Microsoft
Category: Book
List Price: £22.99
Buy New: £3.24
You Save: £19.75 (86%)
New (10) Used (9) from £2.86
Rating:  3 reviews
Sales Rank: 223545
Platform: No Operating System
Media: Paperback
Pages: 453
Number Of Items: 1
Shipping Weight (lbs): 1.4
Dimensions (in): 8 x 5.6 x 1.3
MPN: 0-7356-1129-7
ISBN: 0735611297
Dewey Decimal Number: 005.7585
UPC: 790145112972
EAN: 9780735611290
ASIN: 0735611297
Publication Date: September 30, 2000
Availability: Usually dispatched within 1-2 business days
Shipping: Expedited shipping available
Condition: New, unread, unused and in perfect condition with no missing or damaged pages, may have a remainder mark. Ships from NY, USA. Your item should arrive in 15-30 days from date of shipment based on your location.
| |
| Similar Items:
|
| Editorial Reviews:
Product Description
MS SQL SERVER 2K
Amazon.co.uk Review
If specialisation is for insects, those of us with only two legs are bound to need reminders when we sit down to perform a specialised task. For times when the specialised task at hand involves the latest version of Microsoft's high-end database management system (DBMS), Microsoft SQL Server 2000 Administrator's Pocket Consultant provides 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, instead assuming 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 big 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)
|
| Customer Reviews:
 Good content, dreadful binding March 31, 2005
Graham Phillips (Cambridge, UK)
3 out of 3 found this review helpful
This book gives simple straightforward answers to commonly encountered questions, and I find I use often. Although most of the information could also be found in Books Online, Stanek presents it in a more user-friendly format. Particularly useful are the detailed step-by-step instructions: how to rename a database (5 steps), how to create a maintenance plan for log shipping (29 steps), etc.. He covers T-SQL commands as well as Enterprise Manager methods.Obviously, when working though any of these processes, you will want to have the book open on your desk. Unfortunately, that is not possible. The publishers have chosen to bind it with a glued spine rather than a proper sewn spine, with the result that the book will not stay open. In fact, it's difficult to part the covers more than 90 degrees at all, and if you force it open then the binding will break and the pages fall out. The index seems comprehensive, the text is well laid out, and I haven't discovered any errors. Despite the apalling binding, it's worth having.
 A must for SQL Server Administrators of all levels November 19, 2004
Mr. N. G. Bloor
2 out of 2 found this review helpful
I have been developing with MSSQL Server for a number of years. This is the best reference book I have read so far.
I think what separates this book from the rest is that it is built on wisdom rather than simple knowledge.
When administrating any system, the questions you need to ask can be as important as the answers. This book helps ask the right questions. For example, Chapter 11 helps to create a backup and recovery plan and encourages the reader to think about the data importance and the infrastructure as well as recommending best practice.
I believe any SQL Server Administrator will become more valuable to their company, if they apply the principles of this book.
My only criticism is it is slightly too big to fit in my pocket. However, there is nothing you'd want to take out of this book.
Remarkably good. March 9, 2001
Andrew R M Clarke (Sudbury, Suffolk United Kingdom)
8 out of 11 found this review helpful
For the working database developer, this is probably all you need. It is terse, and covers all the essential points.
|
|
|
