SQL Server System Administration
Published on 24. December 1998
Book
Paperback/Softback
352 pages
978-1-56205-955-2 (ISBN)
Description
SQL Server System Administration assumes that you are familiar with the fundamentals of database administration and have worked with SQL Server in some capacity. This book focuses on the topic of interest to most administrators: keeping data consistently available to users. Unlike other SQL Server books that are wide in scope, discuss SQL Server basics, and have little relevance to the serious SQL Server DBA, SQL Server System Administration provides a hands-on approach that administrators won't find elsewhere. For example, instead of dedicating pages to explaining queries and how they work, this book talks about choosing the correct replication topology and achieving high availability of information.
More details
Language
English
Place of publication
United States
Publishing group
Pearson Education (US)
Target group
College/higher education
Dimensions
Height: 228 mm
Width: 177 mm
Thickness: 17 mm
Weight
547 gr
ISBN-13
978-1-56205-955-2 (9781562059552)
Copyright in bibliographic data is held by Nielsen Book Services Limited or its licensors: all rights reserved.
Schweitzer Classification
Content
SQL Servero System Administration.
About the Authors. About the Technical Reviewers. Dedications. Acknowledgments. Tell Us What You Think!
I. SETUP AND CONFIGURATION.
1. Setup: Troubleshooting and Advanced Topics.
Troubleshooting Setup Problems. Automated Setup. Character Sets and Sort Orders. Sizing the Master Database. Upgrading from Previous Versions of SQL Server. All About Autoconfiguration. Setting Up Client Utilities. Conclusions.
2. Connectivity and Network Configuration.
Server-Side Networking. Client-Side Networking. Configuring ODBC. Examining OLE-DB. Conclusions.
3. Security and Licensing.
Security Philosophy. What to Secure and Why. Cost Justification. The SQL Server 7.0 Security Model. Implementing an Effective Security Model. Troubleshooting Security Problems. Licensing Issues. Conclusions.
II. DAY-TO-DAY MAINTENANCE.
4. Storage Management.
Internal Structures. External Storage: Files and File Groups. Optimizing Storage. Conclusions.
5. The SQL Agent.
Introducing the SQL Agent. Configuring SQL Mail. Configuring the SQL Agent. Adding Operators. Configuring Jobs. Configuring Alerts. Setting Up a Master Server (MSX). Case Studies. Conclusions.
6. Backup and Recovery.
How Backup Works. Configuring Automatic Backup. Backup Strategies. Backup Recommendations. Disaster Recovery. Third-Party Backup Utilities. Conclusions.
7. Database Maintenance.
Preventive Maintenance. Maintaining Performance. Proactive Maintenance with the Database Maintenance Plan Wizard. Recommendations. Conclusions.
III. LESS FREQUENT ACTIVITIES.
8. Data Import/Export.
Exploring Transfer Methods. Using BCP and BULK INSERT. Using Distributed Queries. Using Data Transformation Services (DTS). Conclusions.
9. Replication.
Top Features. Setup and Configuration. Replication Agents. Snapshot Replication. Transactional Replication. The Immediate Updating Subscribers Option of Snapshot and Transactional Replication. Merge Replication. Replication and the New SQL Server Security Roles. Subscribing. Monitoring Replication. Advanced Replication Topics. Conclusions.
10. Achieving High Availability.
Redundant Hardware. Warm Spares. Clustering. Conclusions.
11. Performance Tuning and Optimization.
How to Best Use This Chapter. PT&O Theory. Tools for Monitoring SQL Server and Windows NT. Tracking Down a Performance Problem. Application Optimization Strategies. Server Optimization Strategies. Conclusions.
Index.
About the Authors. About the Technical Reviewers. Dedications. Acknowledgments. Tell Us What You Think!
I. SETUP AND CONFIGURATION.
1. Setup: Troubleshooting and Advanced Topics.
Troubleshooting Setup Problems. Automated Setup. Character Sets and Sort Orders. Sizing the Master Database. Upgrading from Previous Versions of SQL Server. All About Autoconfiguration. Setting Up Client Utilities. Conclusions.
2. Connectivity and Network Configuration.
Server-Side Networking. Client-Side Networking. Configuring ODBC. Examining OLE-DB. Conclusions.
3. Security and Licensing.
Security Philosophy. What to Secure and Why. Cost Justification. The SQL Server 7.0 Security Model. Implementing an Effective Security Model. Troubleshooting Security Problems. Licensing Issues. Conclusions.
II. DAY-TO-DAY MAINTENANCE.
4. Storage Management.
Internal Structures. External Storage: Files and File Groups. Optimizing Storage. Conclusions.
5. The SQL Agent.
Introducing the SQL Agent. Configuring SQL Mail. Configuring the SQL Agent. Adding Operators. Configuring Jobs. Configuring Alerts. Setting Up a Master Server (MSX). Case Studies. Conclusions.
6. Backup and Recovery.
How Backup Works. Configuring Automatic Backup. Backup Strategies. Backup Recommendations. Disaster Recovery. Third-Party Backup Utilities. Conclusions.
7. Database Maintenance.
Preventive Maintenance. Maintaining Performance. Proactive Maintenance with the Database Maintenance Plan Wizard. Recommendations. Conclusions.
III. LESS FREQUENT ACTIVITIES.
8. Data Import/Export.
Exploring Transfer Methods. Using BCP and BULK INSERT. Using Distributed Queries. Using Data Transformation Services (DTS). Conclusions.
9. Replication.
Top Features. Setup and Configuration. Replication Agents. Snapshot Replication. Transactional Replication. The Immediate Updating Subscribers Option of Snapshot and Transactional Replication. Merge Replication. Replication and the New SQL Server Security Roles. Subscribing. Monitoring Replication. Advanced Replication Topics. Conclusions.
10. Achieving High Availability.
Redundant Hardware. Warm Spares. Clustering. Conclusions.
11. Performance Tuning and Optimization.
How to Best Use This Chapter. PT&O Theory. Tools for Monitoring SQL Server and Windows NT. Tracking Down a Performance Problem. Application Optimization Strategies. Server Optimization Strategies. Conclusions.
Index.