|
Microsoft SQL Server 2005 Administrator's Pocket Consultant (Pro-Administrator's Pocket Consultant) |  | Author: William R. Stanek
Publisher: Microsoft Press
Category: Book
List Price: $29.99
Buy Used: $2.00
as of 3/11/2010 09:01 CST details
You Save: $27.99 (93%)
New (37) Used (31) from $2.00
Seller: SourceMedia
Rating:  19 reviews
Sales Rank: 109609
Media: Paperback
Pages: 576
Number Of Items: 1
Shipping Weight (lbs): 1.7
Dimensions (in): 8 x 5.4 x 1.4
MPN: 9780735621077
ISBN: 0735621071
Dewey Decimal Number: 005.7585
EAN: 9780735621077
ASIN: 0735621071
Publication Date: November 2, 2005
Availability: Usually ships in 1-2 business days
| |
| Features:
|
| Also Available In:
|
| Similar Items:
| |
| Editorial Reviews:
Product Description
Heres the utterly practical, pocket-sized reference for IT professionals who need to administer, optimize, and maintain Microsoft SQL Server 2005 in their organization. This unique guide provides essential details for using Microsoft SQL Server 2005 to help protect and manage your companys datawhether automating tasks; creating indexes and views; performing backups and recovery; replicating transactions; tuning performance; managing server activity; importing and exporting data; or performing other key tasks. Featuring quick-reference tables, lists, and step-by-step instructions, this handy, one-stop guide provides fast, accurate answers on the spotwhether youre at your desk or in the field!
|
| Customer Reviews:
Showing reviews 1-5 of 19
 THE ONE SQL SERVER BOOK EVERYONE SHOULD HAVE May 22, 2006
Dale Wagner (Albuquerque, NM USA)
24 out of 24 found this review helpful
I picked up Stanek's SQL Server 2005 Administrator's Pocket Consultant and Windows Server 2003 Inside Out at the same time, and have found them both to be excellent. If there's one SQL Server book every developer, programmer and administrator should have, it's this one--I haven't found a better one and I've read half a dozen so far. Stanek has a gift for getting to the point, explaining the most complex concepts in ways that are easy to understand. He seems to pack a 1,000 pages of info into 550 pages. SQL Server 2005 Administrator's Pocket Consultant has a strong focus on security, configuration, optimization, and troubleshooting. Throughout the book, there's excellent coverage of T-SQL and I prefer the way T-SQL is covered in context in this book to the way it's covered in the separate T-SQL book I bought (and no longer use). Beyond core database administration, which this book covers better than any other book, it also covers full-text search, indexes, integration services (creating packages), linked servers, distributed transactions, replication, publications, etc. The maintenance chapters are some of the strongest with complete coverage of profiling, monitoring, optimizing, backup, recovery, log shipping, database mirroring, automation, etc. Thank you Mr. Stanek for an excellent book.
Microsoft SQL Server 2005 Administrator's Pocket Consultant January 31, 2006
Martin Bell (MVP) (UK)
22 out of 23 found this review helpful
With a new set of tools, Administering SQL 2005 is quite different to previous versions this book provides a very useful overview of the new graphical administration programs, as well as detailing many of the commonly used administration stored procedures.
The book is very readable and I especially like the side notes, which come in Note, Tip, Caution, Real World and Best Practice forms. These give very useful practical information, which will help you avoid some the common problems that get posted to online newsgroups.
The book covers all aspects of administering SQL Server 2005 and will provide a handy reference to anyone whose function it is to maintain a SQL 2005 system.
Martin Bell (SQL Server MVP)
1/28/2006
Terrific resource! November 3, 2006
H. Weisskopf
17 out of 17 found this review helpful
Picked this up a few months back and have practically read it cover to cover already during our SQL upgrade/transition. In large part thanks to this book, I didn't run into any problems planning for or implementing our deployment. Chapters 2 on deploying SQL was a great help, as was the first chapter overview. Chapters 3 and 4 provide comprehensive details on configuration and tuning.
Excellent coverage of views and available stored procedures. Excellent coverage of database mirroring with full details on deploying, planning, and implementing. Also excellent coverage of log shipping and using log shipping with database mirroring.
With our servers up and running I spent a lot of time lately in chapter 8 to 10. Chapter 8 is on logins, users, roles, and permissions. Chapter 9 is on schemas, tables, view, and indexes. Chapter 10 is on importing, exporting, and transforming data. It's all covered clearly and concisely.
Next I'm working my way to profiling and monitoring for optimization and then to getting our backup plans final. This is all covered in chapters 13 to 15 and what I've read so far has been extremely helpful. This is a terrific resource.
EXCELLENT BOOK FOR ADMINISTRATORS AND DEVELOPERS January 10, 2007
N. Burke
19 out of 20 found this review helpful
Sometimes when I read reviews people have written I wonder if they've actually read the book or simply thumbed through it in a bookstore or did a search of the pages. This is an excellent book and I've found it to be extremely helpful in setting up and configuring SQL Server 2005. This book isn't meant to be an allinone monster book, its a concise, focused book covering the core of SQL Server 2005, particularly for administrators but also extremely helpful for developers who are setting up sql boxes too. If you are developing databases for SQL Server 2005 you'll need a focused development book too especially if you are doing datawarehousing or datamart work or reporting services.
I got more out of this book's 548 pages than books nearly twice as big. The book has T-SQL examples throughout and I've used them for administration. The book has excellent coverage of SQL security, nearly 100 pages of security information covered in Chapter 3 "Managing Security, Access, and Network Configuration" and in Chapter 8 "Managing SQL Server 2005 Security". Excellent coverage of log shipping and database mirroring. The book covers schemas for administration perspectives but not in a database development perspective.
I used this book to gain a solid understanding of SQL Server 2005 setup, configuration and management. I refer to it all the time.
This is a great book for your everyday needs and I use it all the time. Highly recommended.
GREAT MANUAL! December 26, 2006
S. James Phillips
17 out of 18 found this review helpful
After reading this book, I felt like I had to stand up or at least applaud. It was really a masterpiece: extremely concise yet pretty comprehensive, easy to understand, and expertly organized. The pocket consultant series by Microsoft claims to be "The practical, portable guide that delivers immediate answers" and it absolutely is. This book is to computer manuals what iPods are to digital music. Compact, powerful, and easy to use.
The book is designed for both new and experienced professionals. Someone who has never used SQL Server before and will get as much out of it as someone who's been using it for a long while. Unlike some books, he doesn't talk down to you and respects the fact that you can learn things if shown how to use them.
This book doesn't just cover SQL Server, but also covers SQL itself. In fact, I really don't consider this just a SQL Server manual. It's really a SQL Server/SQL Command Guide, covering pretty much every aspect of daily administration, configuration, and tuning of SQL Server through the GUI and commands.
The index and table of contents is well organized so you can focus on the sections you want to learn more about.
The ideal book for anyone who works with or wants to work with SQL Server whether admin or not.
Showing reviews 1-5 of 19
|
|
|
CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED ‘AS IS’ AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME. Copyright 2008, SQL Server 2005 Books. All Rights Reserved. In association with Amazon.com | |
