"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.
Rezensionen / Stimmen
"Call on Admin911 to learn what's going on with your network, to understand your options, and to pick the right solutions." -David Chemicoff, Windows 2000 Magazine"
Auflage
Sprache
Verlagsort
Verlagsgruppe
McGraw-Hill Education - Europe
Zielgruppe
Illustrationen
1, black & white illustrations
Maße
Höhe: 233 mm
Breite: 188 mm
Dicke: 27 mm
Gewicht
ISBN-13
978-0-07-213097-3 (9780072130973)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Klassifikation
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.
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.
