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

Platform deployment and management for SQL Server in Azure

DevOps and infrastructure as code have been trending in IT development and operations processes for the last several years, enabling developers and operations teams to write code to define the desired state of the infrastructure needed to support applications. Infrastructure as code-based solutions enable developers and operations teams to build repeatable and tested solutions. To enable these processes and scenarios, Microsoft provides the Azure CLI24 and Azure PowerShell25 (the PowerShell Az module). These tools are the foundation for any programmatic interaction with Azure and are available on Windows, Linux, Mac, and Docker.

You can build custom solutions with both the Azure CLI and Azure PowerShell at the command line using imperative techniques, where you execute the commands necessary to build the Azure infrastructure and resources requested. However, to really enable infrastructure as code, you will need to use a...