Summary

Microsoft offers a complete yet ever-growing cloud ecosystem for data processing in Azure. In this chapter, we explored all the possible SQL Server and SQL database scenarios. Although there are other technologies, such as Data Factory for ETL processes, machine learning for building predictive models and analytics, and so on, these technologies and features are beyond the scope of this book.

In this chapter, we summarized various scenarios for a data platform that had been placed in the cloud. The first of them, Azure SQL database, is provided as a service for hosting isolated databases. The second option we looked at was Azure SQL Managed Instance, which ensures 100% compatibility with an on-premise SQL Server. The last option we looked at was the very powerful Azure Synapse service, which is used to maintain and load balance a massively parallel data warehouse to fulfil the most demanding performance requirements.

After this, we looked at different hybrid scenarios...