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

External data sources

External data sources are your path to virtualizing data from other systems. They collate the connectivity metadata into a single database object. Each external data source provides the location, port, credential, and connectivity options required to access the external source. Just like the other objects discussed, external data sources are database scoped, residing in the database chosen as the data hub.

Supported data sources

The number of external data sources has significantly increased in SQL Server 2019 and now supports many relational database management systems, key-value stores (non-relational), and big data file formats for querying data that's resident in Hadoop. The following table summarizes all the external data sources available in SQL Server 2019, highlighting the required security model for that source: