Microsoft SQL Server 7 Dba Survival Guide: A Real-World Solution

by Spenik, Mark

• ISBN13: 9780672312267
• ISBN10: 0672312263
• Edition: 3rd
• Format: Paperback
• Copyright: 1999-01-01
• Publisher: Pearson P T R

Summary

Microsoft SQL Server 7 DBA Survival Guide is organized into several parts that compromise the various jobs and tasks the DBA performs. Learn client/server computing and the role of the database administrator, how to plan and install/upgrading SQL Server, database operation, performance and tuning, and maintaining the shop. This book provides the knowledge and know-how to administer a SQL Server database. Through real-world insight and experience, you'll learn the tips, tricks, and suggestions you need to succeed as a DBA. Checklists and examples for SQL Server DBA tasks are provided, as well as conventions and naming standards. Also included is a section that looks into the tasks that make up a DBA's job description.

Author Biography

Mark Spenik is the manager of Client/Server Technologies at Keiter, Stephens Computer Services, Inc.

Table of Contents

Introduction	p. 1
Introduction	p. 7
Introduction to Client/Server Database Computing	p. 9
The Role of the Database Administrator	p. 23
The World of Microsoft's SQL Server	p. 37
The Evolution of SQL Server	p. 39
SQL Server Overview	p. 51
Installing and Upgrading SQL Server	p. 77
Planning an Installation or Upgrade	p. 79
Installing or Upgrading SQL Server	p. 109
Database Operation	p. 141
Enterprise Management Processes	p. 143
Database Management	p. 173
Managing SQL Server Users and Security	p. 215
Backup and Restore	p. 255
Using BCP	p. 303
Distributed Transaction Coordinator	p. 335
Troubleshooting SQL Server	p. 357
Miscellaneous Topics and New SQL Server Utilities	p. 381
Replication	p. 407
Replication	p. 409
Transactional Replication	p. 439
Snapshot and Merge Replication	p. 463
Performance and Tuning	p. 493
SQL Server Internals - Changes and Enhancements	p. 495
Monitoring SQL Server	p. 505
Configuring and Tuning SQL Server	p. 527
Database Design Issues	p. 557
Understanding Indexes	p. 571
Query Optimization	p. 597
Multi-User Considerations	p. 627
Advanced DBA Topics	p. 657
SQL Essentials	p. 659
Using Stored Procedures and Cursors	p. 681
Using SQL-DMO (Distributed Management Objects)	p. 723
SQL Server 7.0 and the Internet	p. 757
Automating Maintenance and Administration Tasks	p. 797
Developing a SQL Server Maintenance Plan	p. 799
Automating Database Administration Tasks	p. 815
Data Warehousing	p. 857
Introduction to Data Warehousing	p. 859
Using Data Transformation Services (DTS)	p. 879
Introduction to Microsoft SQL Server OLAP Services	p. 911
Appendixes	p. 945
Naming Conventions	p. 947
DBCC Commands	p. 951
SQL Server Resources	p. 977
What's on the CD-ROM	p. 979
Index	p. 983
Table of Contents provided by Blackwell. All Rights Reserved.