Microsoft SQL Server 2000 Administrator's Pocket Consultant
Author(s): William R. Stanek
Pages: 496
Publication Date: September 2000
ISBN: 0-7356-1129-7
Publisher:
Microsoft Press
Book's Synopsis:
Microsoft SQL Server 2000 Administrator's Pocket Consultant is a concise, immediate reference which suits the need of readers who have to deal with the details of
Microsoft SQL Server 2000 database administration on a daily basis. This guide focuses on what readers need to do to get the job done quickly, whether they handles administration for 50 users or 5000. With extensive tables, lists, and step-by-step instructions, this guide was intended to save readers time and minimize system downtime by giving the right information right now.
This guide should gives readers the fast answers they need to:
- Grasp the fundamentals. Understand the SQL Server 2000 architecture; learn administration tools, techniques, and concepts; and learn how to modify configuration settings to optimize memory usage, take advantage of parallel processors, and more.
- Complete core tasks. Perform basic tasks to create and manage databases, servers, and server groups; and create logons, configure logon permissions, assign roles, and conduct other essential security measures.
- Administer databases. Manage tables, indexes, and views; query and manipulate data; import and export data; and integrate SQL Server data with other data sources.
- Control distributed data. Administer linked servers and distributed transactions, configure data merging and replication, and supervise data publication and subscription.
- Optimize and maintain databases. Profile and monitor SQL Server, conduct data backup and recovery, and take charge of automation and maintenance.
Intended Audience:
This book makes a good administrative tool, particularly for people for whom database administration is one of many responsibilities and who therefore can't spend the time for in-depth training.
Reviews:
Amazon.com
| Quote: |
 "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."
 "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."
|
View / Download Microsoft SQL Server 2000 Administrator's Pocket Consultant -- the book is no longer free, only a sample chapter is available online.
