Microsoft SQL Server 2000d Dba Survival Guide

by Spenik, Mark; Sledge, Orryn; Fernandez, Kari; Jones, Laura; Viers, Kevin; Rackley, Troy D.; Yagerline, Ann; Yocca, Michael

• ISBN13: 9780672320071
• ISBN10: 067232007X
• Edition: 4th
• Format: Paperback
• Copyright: 2001-02-01
• Publisher: Pearson P T R

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

Introduction	p. 1
Overview
Role of the Database Administrator	p. 7
SQL Server Overview	p. 21
The Evolution of SQL Server	p. 43
Installing and Upgrading SQL Server
Planning an Installation or Upgrade	p. 51
Installing or Upgrading SQL Server	p. 75
SQL Server Management and Configuration
Enterprise Management Processes	p. 109
Configuring and Tuning SQL Server	p. 139
Managing Databases	p. 165
Managing SQL Server Users and Security	p. 203
Database Backup and Recovery
Backup and Recovery	p. 241
SQL Database Maintenance
Developing a SQL Server Maintenance Plan	p. 291
Automating Database Administration Tasks	p. 303
Importing and Exporting Data
Data Transformation Services	p. 347
Using BCP and Bulk Insert	p. 383
Troubleshooting
Troubleshooting SQL Server	p. 419
Architecture and Database Design
Architecture Features	p. 445
Database Design Issues	p. 455
Performance and Tuning
Understanding Indexes	p. 471
Query Optimization	p. 497
Multiuser Considerations	p. 527
Transact-SQL
SQL Essentials	p. 557
Using Stored Procedures and Cursors	p. 587
Advanced DBA Topics
SQL Server 2000 and the Internet	p. 631
Monitoring SQL Server	p. 675
SQL Mail	p. 693
Using SQL-DMO	p. 703
Replication
Replication	p. 739
Transactional Replication	p. 767
Merge Replication	p. 791
Data Warehousing
Introduction to Data Warehousing	p. 823
SQL 2000 Analysis Services	p. 843
Appendixes
Naming Conventions	p. 883
DBCC Commands	p. 887
SQL Server Resources	p. 913
What's on the CD	p. 917
Index	p. 921
Table of Contents provided by Syndetics. All Rights Reserved.