BackCover

Back Cover

Configure and manage SQL Server 2000 for peak performance and high availability using the undocumented administrative and troubleshooting techniques offered inside this focused reference. SQL Server expert Brian Knight gives you details on system and platform architecture, settings, security, file management, replication, automation, backups, clustering, and restoration. The book also explains how to maximize built-in administrative tools, develop maintenance plans to prevent downtime, and optimize overall system performance. Concise and practical, this essential resource will save you hundreds of hours of troubleshooting time.

  • Manage SQL Server using best practices
  • Implement security measures and enable C2-level auditing
  • Automate tasks using T-SQL stored procedures, the Query Analyzer, and Multi Server Administration
  • Monitor SQL Server by setting trace flags, creating alerts, enabling the black box, and more
  • Plan for disaster recovery by using full, differential, and transaction log backups
  • Replicate SQL Server data
  • Scale SQL Server using linked servers, distributed partition views, and indexed views
  • Prevent downtime with failover clustering and other high availability solutions
  • Optimize Windows 2000 networks for SQL Server

About the Author

Brian Knight, MCSE, MCDBA, is the cofounder of SQLServerCentral.com. He is on the board of directors for the Professional Association for SQL Server (PASS) and is a senior SQL Server database consultant at Fidelity National Financial. He is a contributing columnist for SQL Server Magazine, a weekly columnist for SQLServerCentral.com, and the author of Admin911: SQL Server 2000 from McGraw-Hill/Osborne.




SQL Server 2000 for Experienced DBAs
ppk on JavaScript, 1/e
ISBN: 72227885
EAN: 2147483647
Year: 2005
Pages: 126

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net