Mein Konto
Login Anmeldung
Alles
Warenkorb
Neuesten Trends
Belletristik
Sachbücher
Kinderbücher
Seltene Bücher
Musik
DVD & Blu-Ray
Kategorie
Wunschlisten
Warenkorb
Alles
Kostenloser Versand
Trustpilot
Unsere Operationen sind klimaneutral

SQL Server System Administration Chris Miller

SQL Server System Administration von Chris Miller

SQL Server System Administration Chris Miller

€5.69
Zustand - Sehr Gut
Nur noch 1
Sehr Gut

Zusammenfassung

PLEASE PROVIDE COURSE INFORMATION

PLEASE PROVIDE

SQL Server System Administration Zusammenfassung

SQL Server System Administration Chris Miller

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.

Inhaltsverzeichnis



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.

Zusätzliche Informationen

GOR002154198
9781562059552
1562059556
SQL Server System Administration Chris Miller
Chris Miller
Gebraucht - Sehr Gut
Broschiert
Pearson Education (US)
19981224
352
N/A
Die Abbildung des Buches dient nur Illustrationszwecken, die tatsächliche Bindung, das Cover und die Auflage können sich davon unterscheiden.
Dies ist ein gebrauchtes Buch. Es wurde schon einmal gelesen und weist von der früheren Nutzung Gebrauchsspuren auf. Wir gehen davon aus, dass es im Großen und Ganzen in einem sehr guten Zustand ist. Sollten Sie jedoch nicht vollständig zufrieden sein, setzen Sie sich bitte mit uns in Verbindung.