Summary

In this chapter, we looked at SQL Server 2019 and the various Azure SQL offerings that are available to deploy your data. There are multiple models available, from a very managed PaaS service such as Azure SQL Database, to the manual-lite managed instance, to the manual and customizable IaaS-based Azure SQL VM. The rest of this book will focus on SQL Server on an Azure VM, whether on Windows or Linux.

SQL Server 2019 on Linux provides customers with a choice of platform, allowing them to tailor SQL Server to the needs of their personnel where much of their software is run on the Linux open-source OS. SQL Server is not itself open source, but Microsoft is embracing the OSS community like never before.

In the next chapter, we will look at the different options for deploying a VM on Azure for SQL Server. Choices such as series of VM, storage types, and installation will be covered, taking into consideration the different workload types that may need to be supported.