Order from a Major Online Bookstore
Ultimate Book Price Comparison Engine
Save Your Time And Money
| AnyBook4Less.com | Order from a Major Online Bookstore |
|
| Home | Store List | FAQ | Contact Us | | ||
| Ultimate Book Price Comparison Engine Save Your Time And Money |
||
 |
Title: Microsoft SQL Server 2000 Administrator's Pocket Consultant by William R. Stanek ISBN: 0-7356-1129-7 Publisher: Microsoft Press Pub. Date: 27 September, 2000 Format: Paperback Volumes: 1 List Price(USD): $29.99 |
Average Customer Rating: 4.4 (10 reviews)
Rating: 5
Summary: Definitive SQL Server 2000 guide in a small package
Comment: 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
Rating: 5
Summary: Most useful SQL Server 2000 book I've bought!
Comment: A must have for administrators and developers. I own several books on SQL Server but none have been as good as this one at saving me time and effort. The book is clearly written, not overly technical, and extremely informative. I really like the tips, notes and real world sections. Use this book to help you with day to day issues, almost like having an experienced consultant at your desk!
Rating: 5
Summary: Great reference and study guide for exam 70-228
Comment: I knew nothing about SQL Server 2000 before picking this up. It took me from knowing nothing to knowing a lot. The author has an easy writing style which made it easier for me to learn this subject. I looked at a lot of SQL Server 2000 books and at least from my perspective, this is the one to own. Great information makes it well worth the money.
If you're anything like me, you may be considering this book as a study guide for 70-228. I recently took this exam and passed. This book is without doubt a text you can buy to prepare for the exam. Sure it doesn't cover everything in the exam, but it comes close.
Great chapters on replication and DTS. Very few screen shots. Packs in a lot of material in 450 pages. Absolutely useful for admining.
Here's my exam study sheet... Hope it helps you like it helped me.
Exam objectives not covered:
Installation
Upgrades
IIS virtual directories for XML
Exam objectives covered:
Create a linked server.
Configure SQL Mail and SQLAgentMail.
Configure network libraries.
Configure database options for performance. Considerations include capacity, network connectivity, physical drive configurations, and storage locations.
Attach and detach databases.
Create and alter databases.
Add filegroups.
Configure filegroup usage.
Expand and shrink a database.
Set database options by using the ALTER DATABASE or CREATE DATABASE statements.
Size and place the transaction log.
Managing, Monitoring, and Troubleshooting SQL Server 2000 Databases
Optimize database performance. Considerations include indexing, locking, and recompiling.
Optimize data storage.
Optimize files and filegroups.
Manage database fragmentation.
Modify the database schema.
Perform disaster recovery operations.
Perform backups.
Recover the system state and restore data.
Configure, maintain, and troubleshoot log shipping.
Perform integrity checks.
Troubleshoot transactions and locking
Extracting and Transforming Data with SQL Server 2000
Import and export data.
Develop and manage DTS packages.
Manage linked servers.
Manage OLE DB Providers.
Configure security mapping.
Convert data types.
Configure, maintain, and troubleshoot replication services.
Managing and Monitoring SQL Server 2000 Security
Configure mixed security modes or Windows Authentication.
Create and manage log ons.
Create and manage database users.
Create and manage security roles.
Add and remove users from roles.
Create roles to manage database security.
Enforce and manage security
Set permissions in a database.
Manage security auditing.
Managing, Monitoring, and Troubleshooting SQL Server 2000
Create, manage, and troubleshoot SQL Server Agent jobs.
Configure alerts and operators by using SQL Server Agent.
Optimize hardware resource usage.
Monitor hardware resource usage by using System Monitor.
Resolve system bottlenecks by using System Monitor.
Optimize and troubleshoot SQL Server system activity.
Monitor SQL Server system activity by using traces.
Monitor SQL Server system activity by using System Monitor.
 |
Title: Microsoft Windows Server 2003 Administrator's Pocket Consultant by William R. Stanek ISBN: 0735613540 Publisher: Microsoft Press Pub. Date: 12 March, 2003 List Price(USD): $29.99 |
 |
Title: Microsoft Windows 2000 Administrator's Pocket Consultant, Second Edition by William R. Stanek ISBN: 0735617929 Publisher: Microsoft Press Pub. Date: 14 August, 2002 List Price(USD): $29.99 |
 |
Title: Microsoft IIS 6.0 Administrator's Pocket Consultant by William R. Stanek ISBN: 0735615608 Publisher: Microsoft Press Pub. Date: 02 April, 2003 List Price(USD): $29.99 |
 |
Title: Microsoft Windows 2000 and IIS 5.0 Administrator's Pocket Consultant by William R. Stanek ISBN: 073561024X Publisher: Microsoft Press Pub. Date: 04 April, 2001 List Price(USD): $29.99 |
 |
Title: Microsoft SQL Server 2000 Administrator's Companion (With CD-ROM) by Marcilina Garcia, Jamie Reding, Edward Whalen, Steve Adrien DeLuca ISBN: 0735610517 Publisher: Microsoft Press Pub. Date: 15 January, 2000 List Price(USD): $59.99 |
Thank you for visiting www.AnyBook4Less.com and enjoy your savings!
Copyright� 2001-2021 Send your comments
