As far back as SQL Server 7.0, we provided a way to query data outside of SQL Server, even for data sources that were not SQL Server. We called this capability linked servers. We used OLE-DB as a mechanism to allow the query processor to push a query to another data source and bring the results back into SQL Server. There were even OLE-DB drivers to query “file” data such as Excel spreadsheet files. In a way, the concept of a linked server query is data virtualization. Data virtualization means accessing ...
© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2022
B. WardSQL Server 2022 Revealedhttps://doi.org/10.1007/978-1-4842-8894-8_77. Data Virtualization and Object Storage
Bob Ward1
(1)
North Richland Hills, TX, USA
Get SQL Server 2022 Revealed: A Hybrid Data Platform Powered by Security, Performance, and Availability now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
