Microsoft SQL Server 2000d Dba Survival Guide,9780672320071

Microsoft SQL Server 2000d Dba Survival Guide

by ; ; ; ; ; ; ;
Edition: 4th
ISBN13: 9780672320071
ISBN10: 067232007X
Format: Paperback
Pub. Date: 2001-02-01
Publisher(s): Pearson P T R
Upgraded Edition: Click here!
  • Free Shipping Icon

    This Item Qualifies for Free Shipping!*

    *Excludes marketplace orders.

List Price: $69.98

Rent Book

Select for Price
Add to Cart
There was a problem. Please try again later.

New Book

We're Sorry
Sold Out

Used Book

We're Sorry
Sold Out

eBook

We're Sorry
Not Available

Buy from our Marketplace starting at $17.55

How Marketplace Works:

  • This item is offered by an independent seller and not shipped from our warehouse
  • Item details like edition and cover design may differ from our description; see seller's comments before ordering.
  • Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
  • Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
  • Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.

Summary

Organized into several parts that comprise the various jobs and tasks DBA performs, each chapter of this book offers real-world insight and experience by passing on tips, tricks and suggestions based on what the authors have learned the hard way. It provides checklists and examples for various SQL Server DBA tasks.

Table of Contents

Introductionp. 1
Overview
Role of the Database Administratorp. 7
SQL Server Overviewp. 21
The Evolution of SQL Serverp. 43
Installing and Upgrading SQL Server
Planning an Installation or Upgradep. 51
Installing or Upgrading SQL Serverp. 75
SQL Server Management and Configuration
Enterprise Management Processesp. 109
Configuring and Tuning SQL Serverp. 139
Managing Databasesp. 165
Managing SQL Server Users and Securityp. 203
Database Backup and Recovery
Backup and Recoveryp. 241
SQL Database Maintenance
Developing a SQL Server Maintenance Planp. 291
Automating Database Administration Tasksp. 303
Importing and Exporting Data
Data Transformation Servicesp. 347
Using BCP and Bulk Insertp. 383
Troubleshooting
Troubleshooting SQL Serverp. 419
Architecture and Database Design
Architecture Featuresp. 445
Database Design Issuesp. 455
Performance and Tuning
Understanding Indexesp. 471
Query Optimizationp. 497
Multiuser Considerationsp. 527
Transact-SQL
SQL Essentialsp. 557
Using Stored Procedures and Cursorsp. 587
Advanced DBA Topics
SQL Server 2000 and the Internetp. 631
Monitoring SQL Serverp. 675
SQL Mailp. 693
Using SQL-DMOp. 703
Replication
Replicationp. 739
Transactional Replicationp. 767
Merge Replicationp. 791
Data Warehousing
Introduction to Data Warehousingp. 823
SQL 2000 Analysis Servicesp. 843
Appendixes
Naming Conventionsp. 883
DBCC Commandsp. 887
SQL Server Resourcesp. 913
What's on the CDp. 917
Indexp. 921
Table of Contents provided by Syndetics. All Rights Reserved.

An electronic version of this book is available through VitalSource.

This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.

By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.

Digital License

You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.

More details can be found here.

A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.

Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.

Please view the compatibility matrix prior to purchase.