Pro SQL Server Always On Availability Groups - Uttam Parui

. .

Auteur(s) : Uttam Parui - Vivek Sanil

Editeur : Apress

Langue : Anglais

Parution : 30/09/2016

Format : Moyen, de 350g à 1kg

Expédition : 634

Dimensions : 25.4 x 17.8 x 1.8

ISBN : 9781484220702

Résumé :

In today's fast evolving business and commerce landscape, businesses need to be up all the time. Downtime equates to revenue loss and businesses are looking for ways to increase availability and improve their disaster recovery capability. IT professionals architecting solutions and the IT professionals supporting such solutions are increasingly feeling the heat from businesses to implement cutting edge technologies to achieve uptime goals. A recent incident in which NYSE was shut down caused huge losses as trading could not be done for almost four hours. This incident highlights the importance of high availability and the impact of downtime on business.

There are numerous such incidents happening every day, and IT professionals have to use all the options they have in their arsenal to mitigate such risks. With this in mind, we set out to create this comprehensive book on SQL Always On Availability Groups. We have worked extensively in the field with large enterprise customers and know the challenges and issues faced by businesses and IT professionals. We have tried to share our field experiences and real life scenarios in this book.

SQL Server is gaining database market share every day, and SQL Server Always On is an ex

citing feature being adopted and deployed by more and more Fortune 500 companies to provide high-availability and disaster recovery for their mission-critical SQL Server installations. This makes us believe that there is a sizable technical audience that this book will cater to.

...

Biographie:

since 2005. He currently works in a support and consulting role in a dedicated capacity with a few large fortune 500 customers. He was in Microsoft Customer Support Services prior to this role. Areas of specialty include database engine internals, AlwaysOn, and performance troubleshooting. He has architected and developed numerous Premier Field Engineering workshops that Microsoft delivers to its customers. He has presented at numerous user group sessions. He has also moderated in several worldwide Microsoft Virtual Academy events. ...

Sommaire:

Introduction

Part I: Getting Started

Chapter 1: High Availability and Disaster Recovery concepts

Chapter 2: Introduction to Always On

Part II: Planning Always On Availability Groups

Chapter 3: Concepts and Common Topologies

Chapter 4: Data Synchronization Internals

Chapter 5: Introduction to Windows Server Failover Clustering

Chapter 6: Prerequisites

Part III: Deploying Always On Availability Groups

Chapter 7: Create a Windows Server Failover Cluster

Chapter 8: Create Availability Groups

Chapter 9: Post-Installation Tasks

Part IV: Active Secondary Replicas

Chapter 10: Readable Secondary Replicas

Chapter 11: Database Maintenance Secondary Replicas

Part V: Managing Availability Groups

Chapter 12: Common Management Tasks

Chapter 13: Upgrading and Migrating

Chapter 14: Performing Database Maintenance Tasks

Part VI: Monitoring and Troubleshooting Availability Groups

Chapter 15: Monitoring Availability Groups

Chapter 16: Troubleshooting Availability Groups

Part VII: Availability Groups in Microsoft Azure

Chapter 17: Introduction to Microsoft Azure

Chapter 18: Availability Groups in Microsoft Azure