Essential SQL Server 2000: An Administration Handbook

Paperback (Print)
Used and New from Other Sellers
Used and New from Other Sellers
from $1.99
Usually ships in 1-2 business days
(Save 95%)
Other sellers (Paperback)
  • All (12) from $1.99   
  • New (5) from $25.72   
  • Used (7) from $1.99   
Close
Sort by
Page 1 of 1
Showing 1 – 4 of 5
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$25.72
Seller since 2008

Feedback rating:

(17546)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

New
Brand New, Perfect Condition, Please allow 4-14 business days for delivery. 100% Money Back Guarantee, Over 1,000,000 customers served.

Ships from: Westminster, MD

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
$25.73
Seller since 2007

Feedback rating:

(23367)

Condition: New
BRAND NEW

Ships from: Avenel, NJ

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
$48.65
Seller since 2014

Feedback rating:

(2)

Condition: New
New

Ships from: Idyllwild, CA

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$63.00
Seller since 2010

Feedback rating:

(7)

Condition: New
12-27-01 other 1 BRAND NEW! ONLY Expedited orders are shipped with tracking number! *WE DO NOT SHIP TO PO BOX* Please allow up to 14 days delivery for order with standard ... shipping. SHIPPED FROM MULTIPLE LOCATIONS. Read more Show Less

Ships from: San Jose, CA

Usually ships in 1-2 business days

  • Canadian
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
Page 1 of 1
Showing 1 – 4 of 5
Close
Sort by

Overview

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

Read More Show Less

Editorial Reviews

From The Critics
Explains the everyday tasks performed on the SQL server 2000, and overviews a few of the more advanced features of the database. The author explains methods for accessing data, importing and exporting data, automating tasks, backing up databases, and optimizing performance. Graphical sections in each chapter provide screenshots that illustrate the sequence of steps for carrying out each task. Annotation c. Book News, Inc., Portland, OR (booknews.com)
Read More Show Less

Product Details

  • ISBN-13: 9780201742039
  • Publisher: Addison-Wesley
  • Publication date: 12/28/2001
  • Edition description: BK&CD-ROM
  • Pages: 624
  • Product dimensions: 7.51 (w) x 9.20 (h) x 1.26 (d)

Meet 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

Read More Show Less

Read an Excerpt

This book is written for the technical professional. It's a mix of a little theory and a lot of practical hands-on examples and real-world explanations.

The book is divided into two parts. The first part (Chapters 1-10) deals with the day-to-day things you need to know as a database administrator (DBA).

  • Chapter 1 explains how to use the book. It introduces databases in general and SQL Server in particular. This chapter also explains what a DBA does, and details the various versions of SQL Server 2000.
  • Chapter 2 displays an install of SQL Server 2000 as well as an overview of upgrading a SQL Server 7 or 6.5 database server to SQL Server 2000.
  • Chapter 3 familiarizes you with the tools available for SQL Server 2000. This chapter also shows the tools' changes from earlier versions.
  • Chapter 4 introduces you to methods of accessing data, both from internal SQL Server 2000 tools and by using other programs. This chapter also covers the connection methods for SQL Server 2000.
  • Chapter 5 explains the methods used to import and export data for SQL Server 2000, and how to automate data transfer from existing sources, such as text files or other databases, to another destination.
  • Chapter 6 introduces you to automating SQL and other tasks such as operating system commands to full-scale programming with conditional branching.
  • Chapter 7 focuses on the maintenance of your databases. This is the most important chapter in the book.
  • Chapter 8 explains backing up and restoring SQL Server 2000 databases to disk or tape as well as the recovery models SQL Server uses for its databases and how they affect backups and restoration.
  • Chapter 9 shows how to tune SQL 2000 Server, both with hardware and the nondesign options.
  • Chapter 10 details SQL Server 2000 security.

The second part (Chapters 11-15) contains introductions and overviews to the more advanced features in SQL Server™ 2000. I've also included a sizing exercise for your servers as well as a discussion about hardware.

  • Chapter 11 describes replication and shows a simple replication schema.
  • Chapter 12 gives a basic understanding of Microsoft's Analysis Services. Here you'll see a start-to-finish example of how OLAP cubes work, as well as the process to use Microsoft Excel as an OLAP client.
  • Chapter 13 provides an overview of the
  • Chapter 14 shows how to ask plain-English questions from SQL Server 2000 databases.
  • Chapter 15 explains named instances and how to set them up and connect to them.

The book concludes with two appendixes.

  • Appendix A gives a sample server sizing exercise.
  • Appendix B details hardware for SQL Server 2000.

Read More Show Less

Table of Contents

Preface.

1. Introduction.

Chapter at a Glance.

Overview.

How You Can Use This Book (You Really Should Read This Part).

The DBA Role.

Duties of a DBA.

SQL 2000. Overview.

Versions.

SQL Server Licensing.

Clients.

Resources.

2. Installing/Upgrading SQL 2000.

Chapter at a Glance.

Overview.

Detail. Setup.

Requirements.

Hardware.

Environment.

Graphical. Setup.

Detail Upgrade.

Requirements.

Graphical Upgrade.

Rosetta Stone.

Oracle.

Microsoft Access.

Resources.

3. Tools.

Chapter at a Glance.

Overview.

Detail.

Reference.

Administration.

Data Access.

Monitoring.

Network Configuration.

Graphical.

Books Online.

Enterprise Manager.

Command Line.

osql.

bcp.

Rosetta Stone.

Oracle.

Microsoft Access.

Resources.

4. Accessing Data.

Chapter at a Glance.

Overview.

Detail.

Databases.

Accessing Data.

Graphical.

Creating and Managing a Database.

Using the SQL Tools to Access Data.

ODBC.

Command Line.

Creating and Managing a Database.

Using the SQL Tools to Access Data.

ODBC.

Examples.

Finding Information about a Database.

Microsoft Access Linked Tables.

The Web Assistant.

A Simple Active Server Page.

The Sample Visual Basic Programs.

Rosetta Stone.

Oracle.

Microsoft Access.

Resources.

5. Importing and Exporting Data.

Chapter at a Glance.

Overview.

Detail.

Data Transformation Services.

The bcp Utility.

BULK INSERT.

SELECT INTO.

XML Bulk Insert.

Which Tool to Use?

Graphical.

Data Transformation Services.

Command Line.

bcp.

BULK INSERT.

SELECT INTO.

Examples.

Creating a Scheduled Export of Data with DTS.

Using bcp to Export Data and Create a Format File.

Using SELECT INTO to Import From a Table Based on a Condition.

Using BULK INSERT to Import Only Five Rows of Data.

Rosetta Stone.

Oracle.

Microsoft Access.

Resources.

6. Automation (The SQL Server Agent).

Chapter at a Glance.

Overview.

Detail.

Operators.

Jobs.

Alerts.

Graphical.

Operators.

Jobs.

Alerts.

Command Line.

Operators.

Alerts.

Jobs.

Examples.

Finding Out When You Need More Ram.

Back Up a Database, Zip It, Copy It.

Rosetta Stone.

Resources.

7. Maintenance.

Chapter at a Glance.

Overview.

Detail.

Physical Structure.

The Maintenance Wizard.

DBCC Commands.

Graphical.

The Maintenance Wizard.

Command Line.

Recovering a Suspect Database.

DBCC Commands.

Examples.

Checking the Success of a Maintenance Plan.

Correcting a Suspect Database.

Rosetta Stone.

Oracle.

Microsoft Access.

Resources.

8. Backing Up and Restoring.

Chapter at a Glance.

Overview.

Detail.

Backing Up Databases.

Recovery Models.

Full Backups.

Log Backups.

Large Backups.

Differential Backups.

Backup Locations.

Backup Devices.

Recovery Process.

Graphical.

Creating Backup Devices.

Backing Up a Database.

Restoring a Database.

Backing Up a Log.

Recovering a Database Using a Log Backup.

Command Line.

Creating a Backup Device.

The Backup Command.

The Restore Command.

A Backup and Restore with Logs.

Examples.

Backing Up a Database to a Network Share.

Rosetta Stone.

Oracle.

Microsoft Access.

Resources.

9. Monitoring and Optimization.

Chapter at a Glance.

Overview.

Detail.

Hardware Optimizations.

Index Tuning Wizard.

SQL Profiler.

Current Activity.

sp_monitor.

sp_who.

sp_lock.

Graphical.

Windows Performance Monitor.

Enterprise Manager.

SQL Profiler.

Command Line.

Query Analyzer.

Query Analyzer. sp_monitor.

Query Analyzer. sp_who.

Query Analyzer. sp_lock.

Examples.

Who's Logged On.

Kill a Process.

How Busy Is My Server.

Rosetta Stone.

Oracle.

Microsoft Access.

Resources.

10. Security.

Chapter at a Glance.

Overview.

Detail.

Security Types.

Permissions.

Graphical.

Working with Server Logins.

Working with Database Users.

Working with Roles.

Working with Permissions.

Command Line.

Working with Server Logins.

Working with Database Users.

Working with Roles.

Working with Permissions.

Examples.

Setting Up a Database Permissions Schema.

Recreate Permissions after a Move.

Rosetta Stone.

Oracle.

Microsoft Access.

Resources.

SQL Server 2000 Advanced Features.

11. Replication.

Chapter at a Glance.

Overview.

Detail.

Types of Replication.

Replication Topology.

Graphical.

Setting Up Replication Using the Wizard.

Command Line.

Replication Stored Procedures.

Examples.

Setting the Distributor.

Setting the Publisher.

Setting the Database.

Setting the Publication.

Setting the Articles.

Setting the Agent.

Activating the Replication.

Setting the Subscriber.

Resources.

12. Analysis Services (OLAP).

Chapter at a Glance.

Overview.

Detail.

Analysis Services Evolution.

Uses.

Analysis Services Concepts.

Impacts.

Client Access.

Preparing for Analysis Services.

Cubes.

Graphical.

Installation.

Running the Tutorial.

Command Line.

MDX Sample Application.

Examples.

Viewing Cube Data with Microsoft Excel.

Resources.

13. eXtensible Markup Language.

Chapter at a Glance.

Overview.

Detail.

Structured Documents.

Tags.

XML Documents.

Creating XML.

Graphical.

Setting Up For XML.

Accessing SQL Server 2000 From a Browser URL.

Accessing SQL Server 2000 From a Template Document.

Formatting XML Data with a Style Sheet.

Command Line.

Creating an XML Document with Query Analyzer.

Opening an XML Document As Data.

Examples.

A Simple Visual Basic Program to Create XML Documents From SQL Server 2000.

Resources.

14. English Query.

Chapter at a Glance.

Overview.

Detail.

English Query Uses.

Understanding the Data Structure.

Understanding the Data Content.

Developing the Questions.

The Semantic Model.

Installing the Product.

Visual Studio.

Clients.

Regression Testing.

Graphical.

Installing English Query.

Creating the Project.

Command Line.

Creating a Regression Test.

Examples.

Deploy Completed Model to Web.

Resources.

15. Working with Instances.

Chapter at a Glance.

Overview.

Detail.

What Are Instances?

Reasons.

Properties.

Impacts.

Connecting to Multiple Instances.

Graphical.

Installing a New Instance.

Command Line.

Connecting to the Instance Using OSQL.

Examples.

Connecting to a Named Instance Using ODBC.

Resources.

Appendix A. A Sample Server Sizing Exercise.

RAM.

Storage.

Appendix B. Hardware for SQL Server.

RAM.

CPU.

Storage Devices (Hard Drives).

NIC.

Index. 0201742039T12042001

Read More Show Less

Preface

This book is written for the technical professional. It's a mix of a little theory and a lot of practical hands-on examples and real-world explanations.

The book is divided into two parts. The first part (Chapters 1-10) deals with the day-to-day things you need to know as a database administrator (DBA).

  • Chapter 1 explains how to use the book. It introduces databases in general and SQL Server in particular. This chapter also explains what a DBA does, and details the various versions of SQL Server 2000.
  • Chapter 2 displays an install of SQL Server 2000 as well as an overview of upgrading a SQL Server 7 or 6.5 database server to SQL Server 2000.
  • Chapter 3 familiarizes you with the tools available for SQL Server 2000. This chapter also shows the tools' changes from earlier versions.
  • Chapter 4 introduces you to methods of accessing data, both from internal SQL Server 2000 tools and by using other programs. This chapter also covers the connection methods for SQL Server 2000.
  • Chapter 5 explains the methods used to import and export data for SQL Server 2000, and how to automate data transfer from existing sources, such as text files or other databases, to another destination.
  • Chapter 6 introduces you to automating SQL and other tasks such as operating system commands to full-scale programming with conditional branching.
  • Chapter 7 focuses on the maintenance of your databases. This is the most important chapter in the book.
  • Chapter 8 explains backing up and restoring SQL Server 2000 databases to disk or tape as well as the recovery models SQL Server uses for its databases and how they affect backups and restoration.
  • Chapter 9 shows how to tune SQL 2000 Server, both with hardware and the nondesign options.
  • Chapter 10 details SQL Server 2000 security.

The second part (Chapters 11-15) contains introductions and overviews to the more advanced features in SQL Server™ 2000. I've also included a sizing exercise for your servers as well as a discussion about hardware.

  • Chapter 11 describes replication and shows a simple replication schema.
  • Chapter 12 gives a basic understanding of Microsoft's Analysis Services. Here you'll see a start-to-finish example of how OLAP cubes work, as well as the process to use Microsoft Excel as an OLAP client.
  • Chapter 13 provides an overview of the XML technology in SQL Server 2000.
  • Chapter 14 shows how to ask plain-English questions from SQL Server 2000 databases.
  • Chapter 15 explains named instances and how to set them up and connect to them.

The book concludes with two appendixes.

  • Appendix A gives a sample server sizing exercise.
  • Appendix B details hardware for SQL Server 2000.

0201742039P12042001

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)