Nicht aus der Schweiz? Besuchen Sie lehmanns.de
SQL Server System Administration - Chris Miller, Sean Baird, John Lynn, Michael Hotek, Denis Darveau

SQL Server System Administration

Buch | Softcover
352 Seiten
1998
New Riders Publishing (Verlag)
978-1-56205-955-2 (ISBN)
CHF 46,95 inkl. MwSt
  • Titel ist leider vergriffen;
    keine Neuauflage
  • Artikel merken
PLEASE PROVIDE COURSE INFORMATION

PLEASE PROVIDE
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.

SQL Serverô 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.

Erscheint lt. Verlag 24.12.1998
Sprache englisch
Maße 177 x 228 mm
Gewicht 547 g
Themenwelt Informatik Datenbanken SQL Server
Mathematik / Informatik Informatik Software Entwicklung
ISBN-10 1-56205-955-6 / 1562059556
ISBN-13 978-1-56205-955-2 / 9781562059552
Zustand Neuware
Haben Sie eine Frage zum Produkt?
Mehr entdecken
aus dem Bereich
Der schnelle Einstieg

von Klemens Konopasek

Buch (2018)
Carl Hanser (Verlag)
CHF 55,95
Das umfassende Handbuch. Inkl. Analysis und Reporting Services

von Daniel Caesar; Michael R. Friebel; Hans Georg Selent-Knips

Buch | Hardcover (2020)
Rheinwerk (Verlag)
CHF 69,85