Essential SQL Server™ 2000: An Administration Handbook [Paperback]

Buck Woody (Author)

Book Description

Publication Date: January 6, 2002 | ISBN-10: 0201742039 | ISBN-13: 978-0201742039 | Edition: 1

Microsoft markets SQL Server 2000 as the easiest enterprise database to manage -- and increasingly, professionals with no DBA experience are being called upon to manage it. Now, there's an SQL Server 2000 book for them. In Essential SQL Server 2000: An Administration Handbook, Buck Woody gives them the skills they need to survive -- and achieve their goals. Essential SQL Server 2000 begins with an overview of SQL Server 2000's capabilities and versions, and the role of a DBA in managing SQL Server 2000. Next, Woody walks through SQL Server 2000 installation, and the efficient management and operation of SQL Server 2000 systems. The book includes step-by-step coverage of maintenance, including backup; and offers practical, easy-to-follow guidance on recovering from problems with SQL Server 2000 systems and databases. For every technical professional called upon to manage SQL Server 2000 databases, regardless of experience with database administration or SQL Server.

Editorial Reviews

From the Back Cover

With thousands of installations worldwide, Microsoft SQL Server™ 2000 is an industry-leading solution for highly scalable, fast, and reliable database management. This hands-on guide covers the installation, configuration, and administration of SQL Server while providing practical solutions to the daily challenges faced by busy administrators.

Filled with real-world examples, Essential SQL Server™ 2000: An Administration Handbook is a succinct survival guide for both experienced professionals as well as those less familiar with the environment. Whether you are a programmer who takes on database administration or a database administrator who is new to SQL Server 2000, you will find this guide an indispensable resource. The book begins with a review of database basics, then progresses to everyday topics including installation, tools, data access, import/export, commands, automation, maintenance, and tuning. The final chapters cover the more advanced features of SQL Server and provide a sample server sizing exercise and helpful hardware discussion. Chapters are organized to provide easy look-up for solving specific problems, while cover-to-cover, the book provides a complete primer on SQL Server essentials.

Topics covered include:

• Database basics, and the features and flavors of SQL Server 2000
• Installation and tips for upgrading from previous versions
• Data access and connection methods for SQL Server
• Importing and exporting data
• Automating SQL Server and operating system commands
• Strategies for successful database maintenance
• Backing up and restoring SQL databases
• Security aspects of SQL Server
• Introduction to Microsoft Analysis Services with working examples
• Overview of the XML technology in SQL Server

Packed with practical tips and timesaving solutions, Essential SQL Server™ 2000: An Administration Handbook is a must-have guide for every administrator managing the day-to-day SQL Server environment.

0201742039B11282001

About the Author

Buck Woody is a senior database administrator and trainer for BST Consultants, Inc. He holds the Microsoft Certified Professional, Microsoft Certified Systems Engineer, and Microsoft Certified Database Administrator certifications. He is also a successful independent SQL Server and Internet consultant and president of the Tampa SQL Server User Group.

0201742039AB11282001

See all Editorial Reviews

Product Details

• Paperback: 624 pages
• Publisher: Addison-Wesley Professional; 1 edition (January 6, 2002)
• Language: English
• ISBN-10: 0201742039
• ISBN-13: 978-0201742039
• Product Dimensions: 9.2 x 7.4 x 1.4 inches
• Shipping Weight: 2 pounds (View shipping rates and policies)
• Average Customer Review: 5.0 out of 5 stars  See all reviews (1 customer review)
• Amazon Best Sellers Rank: #3,252,962 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

2 of 2 people found the following review helpful:

5.0 out of 5 stars Great Handbook for the DBA, January 24, 2006

By 

Brian Woodrow "Brian" (California) - See all my reviews

This review is from: Essential SQL Server™ 2000: An Administration Handbook (Paperback)

I've managed lots of systems, but I never had to be a DBA before. I found the layout to be a perfect balance of enough information to manage a system and information about the features it has. This was the only resource I needed to set up and take care of our SQL Server 2000 system, great work!