SQL Server 2000 for Experienced DBAs [Paperback]

Brian Knight (Author)

Book Description

Publication Date: March 25, 2003 | ISBN-10: 0072227885 | ISBN-13: 978-0072227888 | Edition: 1

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.

Editorial Reviews

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.

Product Details

• Paperback: 520 pages
• Publisher: McGraw-Hill Osborne Media; 1 edition (March 25, 2003)
• Language: English
• ISBN-10: 0072227885
• ISBN-13: 978-0072227888
• Product Dimensions: 9.1 x 7.4 x 1.1 inches
• Shipping Weight: 1.9 pounds
• Average Customer Review: 3.9 out of 5 stars  See all reviews (7 customer reviews)
• Amazon Best Sellers Rank: #2,364,907 in Books (See Top 100 in Books)

More About the Author

Brian Knight, SQL Server MVP, MCITP, MCSE, MCDBA, is the owner and founder of Pragmatic Works. He is also the co-founder of SQLServerCentral.com and JumpstartTV.com. He runs the local SQL Server users group in Jacksonville (JSSUG). Brian is a contributing columnist at several technical magazines and does regular webcasts at Jumpstart TV. He is the author of 10 SQL Server books. Brian has spoken at conferences like PASS, SQL Connections and TechEd and many Code Camps. His blog can be found at http://www.pragmaticworks.com.

Customer Reviews

Most Helpful Customer Reviews

6 of 7 people found the following review helpful:

5.0 out of 5 stars Number one book on my DBA bookshelf., May 16, 2003

By A Customer

This review is from: SQL Server 2000 for Experienced DBAs (Paperback)

I'm not too sure what the other reviewers are talking about. This book was excellent! True, it does skip certain sections. In the intro it explained certain sections were skipped because you should already know how to do things like create a database if you're reading this book. It's not a great book for using as a overall SQL Server reference but it's the best SQL Server book on my shelf for day-to-day administration problems that I can't find the answers to in Books Online. I love some of the advanced topics that appear no where in BOL.

The clustering and security chapters were my favorite and were farby the most indepth of SQL Injection attacks and clustering attacks that I've ever seen. This book is without a doubt a 5 star book for anyone who has read the rest of the reference books out there and is ready for some more intense info. DBA beginners my not understand some of the topics and think that the author is skipping areas.

3 of 3 people found the following review helpful:

4.0 out of 5 stars little better than the junk out there, April 28, 2003

By A Customer

This review is from: SQL Server 2000 for Experienced DBAs (Paperback)

I was searching for high availability options while implementing SQL servers. On this subject matter, this book is much better than many of 'mastering', 'unleashing' books which dont even talk about those topics. The writing flow is OK, performance suggestions are better, but, still I feel it is not in-depth for an experienced DBA. I would give a 3.5 for this book. It is a useful book, but not a must-have.

3 of 3 people found the following review helpful:

5.0 out of 5 stars Superb!, April 10, 2003

By 

"mikeyasmir" (Seattle, WA) - See all my reviews

This review is from: SQL Server 2000 for Experienced DBAs (Paperback)

This book was filled with great advice to help me in my day-to-day job. It already assumes you know the basics so it may not be the right book for a beginner but once you know the basics, this is your book. The clustering and high availability chapters were especially good with the security one. I've never seen a SQL Server book that's only 500 pages long with this much detailed coverage.