Microsoft SQL Server 2000 Administrator's Pocket Consultant [no longer freely available]

FreeTechBooks.com
Free Online Computer Science and Programming Books, Textbooks, and Lecture Notes

FreeTechBooks.com Homepage » Information Systems

Posted: Sun Jul 16, 2006 7:49 pm by ndaru

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."

Neutral

"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.

Last edited by ndaru on Thu Oct 09, 2008 6:38 pm; edited 2 times in total

Posted: Wed Oct 01, 2008 7:40 pm by ebookey

The link above is now dead:

Quote:

We are sorry, the page you requested cannot be found.

Posted: Thu Oct 09, 2008 6:36 pm by ndaru

Apparently it is. Thanks for the notice.