Book Image

SQL Server on Azure Virtual Machines

By : Joey D'Antoni, Louis Davidson, Allan Hirt, John Martin, Anthony Nocentino, Tim Radney, Randolph West
Book Image

SQL Server on Azure Virtual Machines

By: Joey D'Antoni, Louis Davidson, Allan Hirt, John Martin, Anthony Nocentino, Tim Radney, Randolph West

Overview of this book

Deploying SQL Server on Azure virtual machines allows you to work on full versions of SQL Server in the cloud without having to maintain on-premises hardware. The book begins by introducing you to the SQL portfolio in Azure and takes you through SQL Server IaaS scenarios, before explaining the factors that you need to consider while choosing an OS for SQL Server in Azure VMs. As you progress through the book, you'll explore different VM options and deployment choices for IaaS and understand platform availability, migration tools, and best practices in Azure. In later chapters, you'll learn how to configure storage to achieve optimized performance. Finally, you'll get to grips with the concept of Azure Hybrid Benefit and find out how you can use it to maximize the value of your existing on-premises SQL Server. By the end of this book, you'll be proficient in administering SQL Server on Microsoft Azure and leveraging the tools required for its deployment.
Table of Contents (10 chapters)
8
Index

Use cases for SQL Server on Azure VMs

This section will demonstrate ways to leverage Azure VMs running SQL Server in a hybrid scenario, for scalability, migration, and disaster recovery.

As we mentioned previously in this book, SQL Server 2019 runs on both Windows and Linux, with almost complete feature parity between the two operating systems. You will access SQL Server on Linux using the same set of tools, and many of the common tools for scalability, migration, and disaster recovery, including backup and restore, log shipping, consistency checks, transactional replication, and so on. Even availability groups can be leveraged in a hybrid environment using an asynchronous commit.

The following sections present three sample use cases for Azure VMs in a hybrid environment:

  • As a backup-restore target
  • As an availability group replica
  • As a transactional replication subscriber

The important thing to remember here is that a technology or feature doesn't...