Summary
This chapter was an introduction to the SQL PaaS offering from Microsoft. We learned about the Azure SQL architecture and the different layers that make up the Azure SQL infrastructure.
We also learned about the request flow through the different layers when a user connects to and queries an Azure SQL Database. We learned how to connect to and query a database from SQL Server Management Studio and the Azure portal.
We learned about the Azure SQL Managed Instance connectivity architecture and learned how to provision a managed instance using PowerShell.
Most importantly, the chapter covered the differences between Azure SQL Server, Azure SQL Database, and Azure SQL Managed Instance.
In the next chapter, we will discuss how to migrate data from an on-premises system to an Azure SQL Database and Azure SQL Managed Instance.