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

So many choices: which platform should you choose?

So far in this chapter, we have outlined several deployment scenarios for SQL Server on Linux in Azure. In this section, you will understand your platform choices and some of the decision points to help you decide which is best for your scenario. As a developer, it's important that you consider the platform your application will run on.

Which base operating system?

When using IaaS VMs, you have the choice of selecting the base operating system you want to deploy. While deciding the base system, there are two key elements: the technical requirements and the skills of the organization. The technical requirements of the application are something that can surface pretty easily during the analysis phase of building a system architecture. In this section, I'm going to focus on operations and costs—two things that are often forgotten when developing system architectures.

Operations and maintenance

When working...