Brian Knight

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

Komponist: Knight, Brian

• Broschiertes Buch

Produktbeschreibung

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

Produktdetails

• Admin911
• Verlag: McGraw Hill LLC
• 2000
• Seitenzahl: 388
• Erscheinungstermin: Januar 2001
• Englisch
• Abmessung: 233mm x 188mm x 27mm
• Gewicht: 767g
• ISBN-13: 9780072130973
• ISBN-10: 0072130970
• Artikelnr.: 20971286

Inhaltsangabe

Chapter 1: Architecture and Installation.
Chapter 2: Managing SQL Server.
Chapter 3: Optimizing and Automating SQL Server Administration.
Chapter 4: Monitoring and Tuning SQL Server.
Chapter 5: Automating Administrative Tasks.
Chapter 6: Optimizing and Troubleshooting SQL Server.
Chapter 7: Disaster Planning and Recovery.
Chapter 8: Scaling SQL Server.
Chapter 9: SQL Server Replication.
Appendix A: System Tables and Undocumented DBCC Commands.
Appendix B: Extended Stored Procedures.