SQL Server 2019: Data Virtualization
One of the most eagerly anticipated and widely acclaimed, as well as, potentially game changing new features in SQL Server 2019 is data virtualization. Data virtualization allows you to bring all of your data together when you query it instead of using complex ETL or ELT procedures to physically move the data into one place, The data stays in its original location, but you can query it just as if it was local. Leveraging PolyBase, SQL Server 2019 has the ability to connect to multiple data sources, including Hadoop, Azure Blob Storage, external SQL Server instances, Oracle, Teradata, MongoDB, and any database using ODBC standards. Of course, if your data is in a CSV file, you can query that, too.