Updated: July 24, 2020 (February 12, 2019)

SQL Server 2019 Data Virtualization

Andrew analyzes and writes about Microsoft's data management, business intelligence, and machine learning solutions, as well as aspects of licensing... more

SQL Server 2019 expands PolyBase to access more data sources, providing real-time data virtualization of non-SQL Server data sources.
Data virtualization, as compared to traditional ETL deployments, simplifies data connections and reduces maintenance and storage costs.
Deployments often require new hardware and maintenance, and some workloads can put extra work on existing servers that may need upgrades.

PolyBase is a built-in SQL Server database feature that simplifies access to external data sources to provide real-time queries, a process called data virtualization. The features support a new trend in the industry that takes advantage of high-performance hardware and advanced analytic tools to create applications normally support by traditional extract, transform, and load (ETL) and data warehouse deployments. However, data virtualization requires new deployment techniques and management; consequently, it may not provide benefit unless real-time access to external data is needed.

Atlas Members have full access

Get access to this and thousands of other unbiased analyses, roadmaps, decision kits, infographics, reference guides, and more, all included with membership. Comprehensive access to the most in-depth and unbiased expertise for Microsoft enterprise decision-making is waiting.

Membership Options

Already have an account? Login Now