Microsoft SQL Server 2019 and hybrid scenarios

While the previous section showed several clear Azure deployments of SQL Server, SQL Server is traditionally hosted on-premises. As data contention grows over time, administrators face the challenge of handling the increased storage space needed for data or for backups, as well as Recovery Time Objectives (RTO) and Recovery Point Objectives (RPO).

Migration to an Azure environment is not always easy or possible. That's why Microsoft incorporated many enhancements in SQL Server to help DBAs succeed when facing these situations. In the following sections, we will go through these enhancements and show you how to use them. Every section contains appropriate situations for using them and also a detailed description of their implementation.

In the next section, we will explore the first hybrid scenario: data files in Azure.

Data files in Azure

Data files in Azure is a topology in which SQL Server runs on-premise or as an Azure...