Admin911: SQL Server 2000

Brian Knight, "Admin911: SQL Server 2000 "
McGraw-Hill Companies; 1 edition (May 21, 2001) | ISBN: 0072130970 | 369 pages | PDF | 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.