Admin911: SQL Server 2000
Publisher: McGraw-Hill | ISBN: 0072130970 | edition 2001 | CHM | 369 pages | 3,6 mb
"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 Magazine This 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 hand Code Blue–Things to do when your system is in trouble Bug Alert–Common and little-know problems and pitfalls This 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.