Essential SQL Server(TM) 2000: An Administration Handbook

• Cover Type: Paperback with 624 pages
• Published by: Addison-Wesley Professional January 6, 2002
• Written in: English
• ISBN 10 Number: 0201742039
• ISBN 13 Number: 978-0201742039
• Book Dimensions: 9.3 x 7.2 x 1.2 inches
• Weighs: 2 pounds

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

Reader Reviews
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!