July 2017
Intermediate to advanced
432 pages
12h 22m
English
book
SQL Server 2016 High Availability Unleashed (includes Content Update Program)
by Paul Bertucc, Raju Shreewastava
Overview
Book + Content Update Program
SQL Server 2016 High Availability Unleashed provides start-to-finish coverage of SQL Server’s powerful high availability (HA) solutions for your traditional on-premise databases, cloud-based databases (Azure or AWS), hybrid databases (on-premise coupled with the cloud), and your emerging Big Data solutions.
This complete guide introduces an easy-to-follow, formal HA methodology that has been refined over the past several years and helps you identity the right HA solution for your needs. There is also additional coverage of both disaster recovery and business continuity architectures and considerations. You are provided with step-by-step guides, examples, and sample code to help you set up, manage, and administer these highly available solutions. All examples are based on existing production deployments at major Fortune 500 companies around the globe.
This book is for all intermediate-to-advanced SQL Server and Big Data professionals, but is also organized so that the first few chapters are great foundation reading for CIOs, CTOs, and even some tech-savvy CFOs.
Learn a formal, high availability methodology for understanding and selecting the right HA solution for your needs
Deep dive into Microsoft Cluster Services
Use selective data replication topologies
Explore thorough details on AlwaysOn and availability groups
Learn about HA options with log shipping and database mirroring/ snapshots
Get details on Microsoft Azure for Big Data and Azure SQL
Explore business continuity and disaster recovery
Learn about on-premise, cloud, and hybrid deployments
Provide all types of database needs, including online transaction processing, data warehouse and business intelligence, and Big Data
Explore the future of HA and disaster recovery
In addition, this book is part of InformIT’s exciting Content Update Program, which provides content updates for major technology improvements! As significant updates are made to SQL Server, sections of this book will be updated or new sections will be added to match the updates to the technologies. As updates become available, they will be delivered to you via a free Web Edition of this book, which can be accessed with any Internet connection. To learn more, visit informit.com/cup.
How to access the Web Edition: Follow the instructions inside to learn how to register your book to access the FREE Web Edition.
*The companion material is not available with the online edition on O'Reilly Learning
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.