Working with Azure SQL Database
In this chapter, we will learn how to provision and deploy Azure SQL Database and Azure SQL Managed Instance. We will also learn how to choose an option from multiple options when performing a migration to the SQL platform as a service (PaaS) platform. A web API will store data on Azure SQL Database.
In this chapter, we’re going to cover the following main topics:
- Exploring PaaS options for deploying SQL Server in Azure
- Exercise 1 – deploying a single SQL database
- Exercise 2 – deploying Azure SQL Database elastic pools
- Exercise 3 – deploying SQL Managed Instance
- Exercise 4 – connecting Azure SQL Database to an ASP.NET app