You're reading from Introducing Microsoft SQL Server 2019 Reliability, scalability, and security both on premises and in the cloud

Product type Paperback

Published in Apr 2020

Publisher Packt

ISBN-13 9781838826215

Length 488 pages

Edition 1st Edition

Languages

SQL

Tools

SQL Server

Concepts

Database Administration

Authors (8):

Allan Hirt

Dustin Ryan

Mitchell Pearson

Kellyn Gorman

Dave Noderer

Buck Woody

Arun Sirpal

James Rowland-Jones

+4 more

View More author details

Table of Contents (15) Chapters

Preface

About Microsoft SQL Server 2019

1. Optimizing for performance, scalability and real‑time insights

2. Enterprise Security FREE CHAPTER

3. High Availability and Disaster Recovery

4. Hybrid Features – SQL Server and Microsoft Azure

5. SQL Server 2019 on Linux

6. SQL Server 2019 in Containers and Kubernetes

7. Data Virtualization

8. Machine Learning Services Extensibility Framework

9. SQL Server 2019 Big Data Clusters

10. Enhancing the Developer Experience

11. Data Warehousing

12. Analysis Services

13. Power BI Report Server

14. Modernization to the Azure Cloud

SQL Server data files in Azure

This feature enables users to create SQL Server 2019 databases on premises, but the underlying data files (MDF, NDF, and LDF) are bound to Azure Blob storage rather than local storage:

Note

This hybrid technique is only recommended and supported for user databases and not system databases.

Figure 14.7: Saving database across platforms

Figure 4.7: Saving database across platforms

The separation of the compute layer (sqlservr.exe being on premises) and storage layer (Azure Storage) makes the recovery benefits seem more obvious. For example, if you lose the on-premises SQL Server instance, you can set up a new one without any manual data movement. Quite simply, all that is needed is to re-attach the datafiles. Once successfully set up, you can then leverage file-snapshot backups for database files in Azure (see the next section). This feature provides near-instantaneous backups and quick restores, making it a compelling solution for bigger databases.

When using...