Editorial Reviews:
"Microsoft SQL Server 2000 Administrator's Pocket Consultant" is the hands-on, immediate reference you need as you deal with the details of Microsoft SQL Server administration in small, medium, and large organizations. Ideal at the desk or on the go from server to server, this fast-answers guide focuses on what you need to do in specific situations as you support and manage Microsoft SQL Server 2000. Topics covered include SQL basics, administration tools, configuring and tuning, managing the enterprise, database administration, security, backup and recovery, importing and exporting data, data replication, monitoring and profiling, creating tables and indexes, automation and maintenance, and more.
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)
Customer Reviews:
Displaying 6 to 10 of 16 total reviews (Page 2 of 4):
 Concise Good Overview of MSSQL
Overall this is a concise good overview of a complex product. It covers all the basics and in general the author did a good job of writing in plain language. Instead of typical Microsoft mumbo jumbo. I do find fault with the chapter on Security. The author refers to the built in "Guest" user account as a login. Which confuses the issue. I think he was confused about MSSQL's security schema as I am. (The security schema can be thought of in 3 layers: logins, users/serverroles/dbroles, and the actual object& statement permissions.) One last note, last time I checked Microsoft's Technet has a free online copy of this book. The book is still worth the full price I paid for it.  Great reference and study guide for exam 70-228
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.  Decent administrative reference
This 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. Good introduction
This book does not cover any advanced topics. For example, it will not teach you how to program DTS or how to spot performance problems due to bad indexing. It does, however, provide a very rock solid instruction on how to perform 95% of SQL administrative tasks. Cynically speaking, this book will teach you how to become a very successful button pushing SQL monkey. If you want to become something better, than I strongly suggest you buy and master "SQL 2000 Unleashed" and "Microsoft SQL Server 2000 Performance Optimization and Tuning". The best for day-to-day administration
This is the top book for SQL 2000 administration. Mr. Stanek has put together a great book for day-to-day administration of SQL Server 2000. I can't recommend this book strongly enough. It goes beyond the basics and goes a long way answering those questions that you ask yourself everyday and instead of hunting on the Internet every time you need a solution, you should carry this book with you. It shows you the types of tips and real world info that you only get from years of experience. This is like having an expert by your side. The best part about this book is the style in which it is written. Its not too technical and very easy to read. I read this book cover to cover and I have also been using it to help me prep for the exams. This book belongs on every DBA's bookshelf. More Customer Reviews:
Previous Page Next Page
|
(16 reviews)
