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

Knight, Brian

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

Inhaltsangabe

This guide should allow DBAs to manage and troubleshoot SQL Server 2000. It contains a troubleshooting chart for ease of use when finding solutions to problems.

Die Inhaltsangabe kann sich auf eine andere Ausgabe dieses Titels beziehen.

Über die Autorin bzw. den Autor

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.

Von der hinteren Coverseite

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

„Über diesen Titel“ kann sich auf eine andere Ausgabe dieses Titels beziehen.