Pro SQL Server Always On Availability Groups

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 exciting 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.

Provides tips, tricks and best practices for deploying availability groups Inspires the confidence to manage and monitor availability groups Helps with troubleshooting problems in a mission-critical environment

Autorentext
Uttam Parui is a Senior Premier Field Engineer at Microsoft based out of Charlotte, North Carolina. He has worked at Microsoft for more than 15 years and started working with the SQL Server product since SQL Server 6.5. As a Premier Field Engineer, he delivers SQL Server consulting and support for designated strategic Fortune 500 customers. Also, he has been developing content, speaking at events, as well as authoring books, white papers, and articles related to SQL Server administration, high availability, disaster recovery, and more. Uttam is the coauthor of Microsoft SQL Server 2008 Bible (Wiley Publishing) and technical editor for Pro SQL Server 2008 Failover Clustering (Apress). He has trained and mentored engineers from Microsoft's Customer Support Services and Premier Field Engineering teams, and was one of the first to train and assist in the development of Microsoft's SQL Server support teams in Canada and India. He received his master's degree in Computer Science from the University of Florida at Gainesville.
Vivek Sanil is Senior Premier Field Engineer at Microsoft. Vivek has been working extensively with SQL Server since joining the industry more than 16 years ago. He has been with Microsoft 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.

Inhalt

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 using Secondary Replicas.- Part V: Managing Availability Groups.- Chapter 12: Common Management Tasks.- Chapter 13: Upgrading and Migrating.- Chapter 14: Performing Database Maintenance Tasks.- PartVI: Monitoring and Troubleshooting Availability Groups.- Chapter 15: Monitoring Availability Groups.- Chapter 16: Troubleshooting Availability Groups.- Part VI: Availability Groups in Microsoft Azure.- Chapter 17: Introduction to Microsoft Azure.- Chapter 18: Availability Groups in Microsoft Azure. <p