Summary

This chapter was an introduction to the SQL Database as a service offering from Microsoft. You learned about the Azure SQL Database architecture and the different layers that make up the Azure SQL Database infrastructure.

You also learned about the request flow through the different layers when a user connects and queries an Azure SQL Database.

You learned to connect and query the database from SQL Server Management Studio and the Azure portal.

Most importantly, the chapter covered the differences between an on-premises SQL Database and an Azure SQL Database, along with the unsupported features on an Azure SQL Database.

In the next chapter, we will discuss how to migrate data from an on-premises system to an Azure SQL Database.