SQL Server 2000 for Experienced DBAs

0 avg rating
( 0 ratings by Goodreads )
 
9780072227888: SQL Server 2000 for Experienced DBAs

SQL Server guru Brian Knight will save you plenty of time and money in labor, frustration, and SQL Server downtime. Provides undocumented troubleshooting tips and tricks and is a quick reference on system administrative functions essential for DBAs. Explains architecture, optimization techniques, automation, management, security, and more.

"synopsis" may belong to another edition of this title.

From the Back Cover:

“This comprehensive coverage will be invaluable to both the new administrator and the experienced database engineer alike. Brian takes his seasoned knowledge and lays it out in a way that is easy to understand and easy to implement.” –Rod Trent, Windows Management MVP

Maintain a reliable, scalable, secure SQL Server 2000 environment

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.

Essential Skills for Database Professionals

  • Manage SQL Server using best practices
  • Implement security measures and enable C2-level auditing
  • Automate tasks using T-SQL stored procedures, 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 (Green Cove Springs, FL), MCSE, MCDBA, is on the Board of Directors for the Professional Association for SQL Server (PASS) and runs the local SQL Server users group in Jacksonville. Brian is a contributing columnist for SQL Magazine and also maintains a weekly column for the database website SQLServerCentral.com. He is the author of Admin911: SQL Server 2000 (Osborne/McGraw-Hill) and co-author of Professional SQL Server DTS (Wrox Press). Brain is a Senior SQL Server Database Consultant at Alltel in Jacksonville and spends most of his time deep in DTS and SQL Server.

"About this title" may belong to another edition of this title.

Top Search Results from the AbeBooks Marketplace

1.

Brian Knight
Published by McGraw-Hill Osborne Media (2003)
ISBN 10: 0072227885 ISBN 13: 9780072227888
New Paperback Quantity Available: 1
Seller
Ergodebooks
(RICHMOND, TX, U.S.A.)
Rating
[?]

Book Description McGraw-Hill Osborne Media, 2003. Paperback. Book Condition: New. 1. Bookseller Inventory # DADAX0072227885

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 99.39
Convert Currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, Rates & Speeds

2.

Knight, Brian
Published by McGraw-Hill Osborne Media (2003)
ISBN 10: 0072227885 ISBN 13: 9780072227888
New Paperback Quantity Available: 1
Seller
Booked Again
(Summit, NJ, U.S.A.)
Rating
[?]

Book Description McGraw-Hill Osborne Media, 2003. Paperback. Book Condition: New. New item. Bookseller Inventory # QX-003-58-1629001

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 149.87
Convert Currency

Add to Basket

Shipping: US$ 10.00
Within U.S.A.
Destination, Rates & Speeds

3.

Brian Knight
Published by McGraw-Hill Osborne Media (2003)
ISBN 10: 0072227885 ISBN 13: 9780072227888
New Paperback Quantity Available: 1
Seller
Irish Booksellers
(Rumford, ME, U.S.A.)
Rating
[?]

Book Description McGraw-Hill Osborne Media, 2003. Paperback. Book Condition: New. book. Bookseller Inventory # 0072227885

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 289.99
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds