Data Virtualization in SQL Server
ABSTRACT
SQL Server's data virtualization stack has evolved throughout the past decade, allowing you to integrate SQL Server with a variety of external systems, such as Oracle, MongoDB, Cosmos DB, Azure Blob Storage, and AWS S3. In this talk, we will briefly cover the history of data virtualization in SQL Server and focus on how we can write T-SQL queries to access data from heterogeneous sources, both in SQL Server 2025 and in prior versions. Finally, we will look at several interesting use cases for data virtualization in the modern data environment.
ADDITIONAL MEDIA
On August 30, 2022, I gave this talk to the DBA Fundamentals group. You can get the recording on the DBA Fundamentals group's YouTube channel.
On August 13, 2019, I delivered the prior version of this talk at the Triangle SQL Server User Group's Advanced DBA special interest group. You can get the recording on my YouTube channel.
SLIDES
Click here to access the slides for this presentation.
The slides are licensed under Creative Commons Attribution-ShareAlike.
DEMO CODE
Click here to access demo code for this presentation.
The source code is licensed under the terms offered by the GPL.
LINKS & FURTHER INFO
- I have a multi-part blog series covering this topic in great detail.
- One thing I have not covered in my series is multi-node Polybase. David Benoit has covered this in a great blog post.
- Check out the SQL Data Warehouse feedback site if you have suggestions on how to make Polybase better. You can also see current issues with Polybase on that site as well.