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

Supported base operating systems for running SQL Server on Linux in Azure IaaS VMs

When deploying SQL Server on Linux in Azure, you have several platform choices. In this section, I will introduce how to deploy SQL Server on Linux in Azure using an Azure Marketplace image with SQL Server on Linux pre-installed, using an Azure Marketplace image and installing SQL Server on Linux manually, and also container-based deployments. I will wrap up this section with advice on which platform you should choose for your applications.

Using an Azure Marketplace image with SQL Server on Linux pre-installed

When creating Azure VMs to run SQL Server on Linux, the underlying platform becomes a critical choice in terms of deployment and management.

When it comes to deploying SQL Server on Linux in Azure, you can start off by using pre-built Azure Marketplace images. This means that you can select a base operating system with SQL Server on Linux pre-installed. There are Marketplace images with...