No Words Wasted Sale
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Visit our stores


    Recently Viewed clear list


    The Powell's Playlist | January 5, 2015

    Tim Johnston: IMG The Powell's Playlist: Songs for Not Sleeping by Tim Johnston



    I once told a medical-profession-type lady that I didn't sleep well, that I awoke all through the night and was awake for hours. "What do you do... Continue »
    1. $18.17 Sale Hardcover add to wish list

      Descent

      Tim Johnston 9781616203047

    spacer
Qualifying orders ship free.
$5.95
List price: $36.25
Used Trade Paper
Usually ships in 5 to 7 business days
Add to Wishlist
available for shipping or prepaid pickup only
Qty Store Section
1 Remote Warehouse Software Engineering- Programming and Languages

More copies of this ISBN

Essential SQL Server 2000: An Administration Handbook

by

Essential SQL Server 2000: An Administration Handbook Cover

 

Synopses & Reviews

Publisher Comments:

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

Book News Annotation:

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)

Synopsis:

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, this is a succinct survival guide for both experienced professionals as well as those less familiar with the environment.

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

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

Product Details

ISBN:
9780201742039
Author:
Woody, Buck
Publisher:
Addison-Wesley Professional
Location:
Boston
Subject:
Programming - General
Subject:
Database Management - General
Subject:
Client-server computing
Subject:
Relational databases
Subject:
Database Management - SQL Server
Subject:
Sql server
Subject:
Programming Languages - SQL
Subject:
Database-SQL
Subject:
Database design
Copyright:
Edition Description:
Trade paper
Series Volume:
no. 00-4754
Publication Date:
December 2001
Binding:
TRADE PAPER
Grade Level:
Professional and scholarly
Language:
English
Illustrations:
Yes
Pages:
624
Dimensions:
9.24x7.40x1.36 in. 2.29 lbs.

Other books you might like

  1. Advanced Transact-SQL For SQL Server... Used Trade Paper $24.00
  2. Client/server programming with Java... Used Trade Paper $5.95
  3. Building Switched Networks:... New Trade Paper $45.50
  4. Data Mining with Microsoft SQL... Used Hardcover $6.50
  5. Multicast Sockets: Practical Guide... New Trade Paper $43.25

Related Subjects

Computers and Internet » Database » Design
Computers and Internet » Database » SQL
Computers and Internet » Software Engineering » Programming and Languages
Computers and Internet » Software Engineering » Software Management

Essential SQL Server 2000: An Administration Handbook Used Trade Paper
0 stars - 0 reviews
$5.95 In Stock
Product details 624 pages Addison-Wesley Professional - English 9780201742039 Reviews:
"Synopsis" by , 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, this is a succinct survival guide for both experienced professionals as well as those less familiar with the environment.
spacer
spacer
  • back to top

FOLLOW US ON...

     
Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.