SQL Server on Azure Virtual Machines: A hands-on guide to provisioning Microsoft SQL Server on Azure VMs

Product Description

Learn how to combine SQL Server’s analytics with Azure’s flexibility and hybrid connectivity to achieve industry-leading performance and manageability for your cloud database.
Key Features

Understand platform availability for SQL Server in Azure
Explore the benefits and deployment choices offered by SQL IaaS
Get to grips with deploying SQL Server on the Linux development ecosystem

Book Description
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.
What you will learn

Choose an operating system for SQL Server in Azure VMs
Use the Azure Management Portal to facilitate the deployment process
Verify connectivity and network latency in cloud
Configure storage for optimal performance and connectivity
Explore various disaster recovery options for SQL Server in Azure
Optimize SQL Server on Linux
Discover how to back up databases to a URL

Who this book is for
SQL Server on Azure VMs is for you if you are a developer, data enthusiast, or anyone who wants to migrate SQL Server databases to Azure virtual machines. Basic familiarity with SQL Server and managed identities for Azure resources will be a plus.
Table of Contents

Introduction to SQL
Getting started with SQL Server in Azure VMs
Hero capabilities for SQL Server on Azure VMs
SQL Server on Linux in Azure VMs
Performance
Moving workloads to SQL Server in Azure VMs
Hybrid scenarios

About the Author

Joseph D’Antoni is a Principal Consultant at Denny Cherry and Associates Consulting. He is recognized as a VMWare vExpert and a Microsoft Data Platform MVP and has over 20 years of experience working in both Fortune 500 and smaller firms. He has worked extensively on database platforms and cloud technologies and has specific expertise in performance tuning, infrastructure, and disaster recovery.
Louis Davidson is a data architect for CBN in Virginia Beach, VA; telecommuting for many years from Cleveland, TN (which is not even as glamourous as it sounds.) Louis has written and contributed to many books on SQL Server topics over the past 20 years. His most prominent work has been five editions of his book entitled: “”Pro SQL Server Relational Database Design and Implementation”” for Apress in 2016, with a new version forthcoming in 2020. Louis has been a speaker at many SQL Saturday events, and has helped organize events in Nashville and Chattanooga, TN.
SQLHA, LLC founder, consultant, trainer, author, and business continuity, infrastructure, and virtualization expert Allan Hirt has been working with SQL Server since 1992 when it was still a Sybase product as well as clustering in Windows Server since the late 1990s when it was known as Wolfpack. Currently a dual Microsoft MVP (Data Platform; Cloud and Datacenter Management) as well as a VMware vExpert, Allan works with all sizes of customers no matter if they are on premises or in the public cloud and delivers training and speaks at events over the world.
John is an experienced data platform professional having spent over a decade working with the Microsoft data and cloud platform technologies. In this