Admin911: SQL Server 2000: A Survival Guide for System Administrators (2000) - Softcover

Knight, Brian

Softcover

ISBN 10: 0072130970 ISBN 13: 9780072130973

Publisher: McGraw-Hill Education, 2001

Synopsis

"Call on Admin911 to learn what's going on with your network, to understand your options, and pick the right solutions." --David Chernicoff, Windows 2000 MagazineThis survival guide for SQL Server 2000 administrators explains how to implement preventive problem-solving strategies and minimize downtime. Helpful call-outs throughout the book include:Take Command--Specific command-line utilities relating to the topic at handCode Blue--Things to do when your system is in troubleBug Alert--Common and little-know problems and pitfallsThis book will also help you:*Manage SQL Server, including memory and security*Optimize and automate administration using SQL Server Agent and other tools*Debug Jobs*Monitor and tune SQL Server unsing the system monitor and alerts*Optimize T-SQL and stored procedures*Scale SQL Server using linked servers and Distributed Partitioned Views*Troubleshoot database performance*Implement disaster recovery procedures.

About this title

About the Author

Harshad Nadkami (Redmond, WA) is a Senior Database Administrator at Microsoft Corp, specializing in performance tuning, and repairing database corruption. Before going to Microsoft, he spent many years as a DBA and SQL Server Development specialist with major corporations. He is currently pursuing simultaneous graduate degrees in Information Systems and Finance. His certifications include MCSE and MCDBA.

From the Back Cover

Survival Guide for System Administrators

Configure, manage, and optimize SQL Server 2000 for peak performance with help from this unique resource. Inside, you'll find immediate solutions to problems involving database and server settings, multiple instances, startup parameters, service packs, stored procedures, and much more. The book also covers the many administrative features built in to SQL Server 2000, including SQL Server Agent, Enterprise Manager, Multi Server Administration, and System Monitor. Get this book and save yourself hundreds of hours of troubleshooting time.

• Manage SQL Server, including memory and security
• Optimize and automate administration using SQL Server Agent and other tools
• Debug jobs
• Monitor and tune SQL Server using the system monitor and alerts
• Optimize T-SQL and stored procedures
• Scale SQL Server using linked servers and Distributed Partitioned Views (DPVs)
• Troubleshoot database performance
• Implement disaster recovery procedures

TAKE COMMAND--Specific command-line utilities relating to the topic at hand

CODE BLUE--Things to do when your system is in trouble

BUG ALERT--Common and little-known problems and pitfalls

Edition details

• Publisher: McGraw-Hill Education
• Publication date: 2001
• Language: English
• ISBN 10: 0072130970
• ISBN 13: 9780072130973
• Binding: Paperback
• Number of pages: 388