Microsoft SQL Server DBA Survival Guide

Table of Contents:

• Introduction

Part I: Introduction

• Chapter 1 - Introduction to Client/Server and Database Computing
• Chapter 2 - The Role of the Database Administrator

Part II: The World of Microsoft's SQL Server

• Chapter 3 - The Evolution of SQL Server
• Chapter 4 - SQL Server: The Big Picture

Part III: Planning and Installing/Upgrading SQL Server

• Chapter 5 - Planning an Installation or Upgrade
• Chapter 6 - Installing or Upgrading SQL Server

Part IV: Database Operation

• Chapter 7 - Managing the Enterprise
• Chapter 8 - Managing Devices
• Chapter 9 - Managing Databases
• Chapter 10 - Managing Users
• Chapter 11 - Managing SQL Server Security
• Chapter 12 - Replication
• Chapter 13 - Distributed Transaction Coordinator
• Chapter 14 - Backups
• Chapter 15 - Recovery
• Chapter 16 - Importing and Exporting Data
• Chapter 17 - Troubleshooting SQL Server

Part V: Performance and Tuning

• Chapter 18 - Monitoring SQL Server
• Chapter 19 - Which Knobs Do I Turn?
• Chapter 20 - Database Design Issues
• Chapter 21 - Understanding ches
• Chapter 22 - Understanding the Query Optimizer
• Chapter 23 - Multi-User Considerations
• Chapter 24 - Using Stored Procedures and Cursors

Part VI: Maintaining the Shop

• Chapter 25 - Developing a SQL Server Maintenance Plan
• Chapter 26 - Automating Database Administration Tasks
• Chapter 27 - SQL OLE Integration
• Chapter 28 - New SQL Server Utilities

Part VII: Appendixes

• Appendix A - Naming Conventions
• Appendix B - Using Extended Stored Procedures
• Appendix C - System Procedures
• Appendix D - Function Reference
• Appendix E - DBCC Commands
• Appendix F - System Tables
• Appendix G - Object Manager
• Appendix H - SQL Administrator
• Appendix I - What's on the CD-ROM

Use of this site is subject to certain Terms & Conditions. Copyright (c) 1996-1998 EarthWeb Inc. All rights reserved. Reproduction in whole or in part in any form or medium without express written permission of EarthWeb is prohibited. Read EarthWeb's privacy statement.