Update:

14-02-2021, the books webpage is no longer online. We switched the download link to a Wayback Machine copy.

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.