Admin911 SQL Server 2000: A Survival Guide for System Administrators (2000)
by Brian Knight 2020-12-31 06:51:25
image1
Survival Guide for System AdministratorsConfigure, 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 ins... Read more
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

Less
  • ISBN
  • 9780072130973
Brian Knight is the founder of Pragmatic Works and co-founder of SQLServerCentral.com and JumpstartTV.com. Devin Knight is a SQL Server MVP, the Training Director at Pragmatic Works, and an author on ...
Compare Prices
Available Discount
No Discount available
Related Books