SQL Server 2019 AlwaysOn, 3rd Edition

Supporting 24x7 Applications with Continuous Uptime



Bookstore > Books > SQL Server 2019 AlwaysOn, 3rd Edition

Price$35.58 - $39.99
Rating
AuthorPeter A. Carter
PublisherApress
Published2020
Pages267
LanguageEnglish
FormatPaper book / ebook (PDF)
ISBN-101484264789
ISBN-139781484264782
EBook Hardcover Paperback

Get a fast start to using AlwaysOn, the SQL Server solution to high-availability and disaster recovery. This third edition is newly-updated to cover the 2019 editions of both SQL Server and Windows Server and includes strong coverage of implementing AlwaysOn Availability Groups on both Windows and Linux operating systems. The book provides a solid and accurate understanding of how to implement systems requiring consistent and continuous uptime, as well as how to troubleshoot those systems in order to keep them running and reliable. This edition is updated to account for all new major functionality and also includes coverage of implementing atypical configurations, such as clusterless and domain-independent Availability Groups, distributed Availability Groups, and implementing Availability Groups on Azure.

The book begins with an introduction to high-availability and disaster recovery concepts such as Recovery Point Objectives (RPOs), Recovery Time Objectives (RTOs), availability levels, and the cost of downtime. You'll then move into detailed coverage of implementing and configuring the AlwaysOn feature set in order to meet the business objectives set by your organization. Content includes coverage on implementing clusters, building AlwaysOn failover clustered instances, and configuring AlwaysOn Availability Groups.

SQL Server 2019 AlwaysOn is chock full of real-world advice on how to build and configure the most appropriate topology to meet the high-availability and disaster recovery requirements you are faced with, as well as how to use AlwaysOn Availability Groups to scale-out read-only workloads. This is a practical and hands-on book to get you started quickly in using one of the most talked-about SQL Server feature sets.


  1. (3 books)


Similar Books


SQL Server 2019 Administration Inside Out

SQL Server 2019 Administration Inside Out

by Randolph West, Melody Zacharias, William Assaf, Sven Aelterman, Louis Davidson, Joseph D'Antoni

Dive into SQL Server 2019 administration - and really put your SQL Server DBA expertise to work. This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds - all you need to plan, implement, manage, and secure SQL Server 2019 in any production environment: on-premises, cloud, or hybrid. Six experts th...

Price:  $48.15  |  Publisher:  Microsoft Press  |  Release:  2020

Building Custom Tasks for SQL Server Integration Services, 2nd Edition

Building Custom Tasks for SQL Server Integration Services, 2nd Edition

by Andy Leonard

Build custom SQL Server Integration Services (SSIS) tasks using Visual Studio Community Edition and C#. Bring all the power of Microsoft .NET to bear on your data integration and ETL processes, and for no added cost over what you've already spent on licensing SQL Server. New in this edition is a demonstration deploying a custom SSIS ...

Price:  $34.99  |  Publisher:  Apress  |  Release:  2021

Tabular Modeling in Microsoft SQL Server Analysis Services, 2nd Edition

Tabular Modeling in Microsoft SQL Server Analysis Services, 2nd Edition

by Marco Russo, Alberto Ferrari

Create a semantic model and analyze data using the tabular model in SQL Server 2016 Analysis Services to create corporate-level business intelligence (BI) solutions. Led by two BI experts, you will learn how to build, deploy, and query a tabular model by following detailed examples and best practices. This hands-on book shows you how to u...

Price:  $45.42  |  Publisher:  Microsoft Press  |  Release:  2017

SQL Server Execution Plans, 3rd Edition

SQL Server Execution Plans, 3rd Edition

by Grant Fritchey

Every Database Administrator, developer, report writer, and anyone else who writes T-SQL to access SQL Server data, must understand how to read and interpret execution plans. My book leads you right from the basics of capturing plans, through how to interrupt them in their various forms, graphical or XML, and then how to use the informati...

Free ebook  |  Publisher:  Self-publishing  |  Release:  2018

Pro SQL Server 2012 Reporting Services, 3rd Edition

Pro SQL Server 2012 Reporting Services, 3rd Edition

by Brian McDonald, Shawn McGehee, Rodney Landrum

Pro SQL Server 2012 Reporting Services opens the door to delivering customizable, web-enabled reports across your business at reasonable cost. Reporting Services is Microsoft's enterprise-level reporting platform. It is included with many editions of SQL Server, and is something you'll want to take advantage of if you're ru...

Price:  $25.17  |  Publisher:  Apress  |  Release:  2012

Mastering Windows Server 2019, 3rd Edition

Mastering Windows Server 2019, 3rd Edition

by Jordan Krause

Windows Server 2019 has a lot to offer, with a variety of roles, features, toolsets, and server management interfaces that allow interaction with your servers from virtually anywhere in the world. This updated edition comes with four new chapters to provide you with the in-depth knowledge needed to implement and use this operating system ...

Price:  $39.99  |  Publisher:  Packt Publishing  |  Release:  2021

Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes, 2nd Edition

Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes, 2nd Edition

by Ben Forta

Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes offers straightforward, practical answers when you need fast results. By working through the book's 30 lessons of 10 minutes or less, you'll learn what you need to know to take advantage of Microsoft SQL Server's T-SQL language.This handy pocket guide starts with ...

Price:  $17.59  |  Publisher:  SAMS Publishing  |  Release:  2017

Professional Microsoft SQL Server 2012 Integration Services

Professional Microsoft SQL Server 2012 Integration Services

by Brian Knight, Erik Veerman, Jessica M. Moss, Mike Davis, Chris Rock

Microsoft SQL Server 2012 Integration Services (SISS) builds on the revolutionary database product suite first introduced in 2005. With this crucial resource, you will explore how this newest release serves as a powerful tool for performing extraction, transformation, and load operations (ETL). A team of SQL Server experts deciphers this ...

Price:  $32.99  |  Publisher:  Wrox  |  Release:  2012