Home > Workload Solutions > SQL Server > Guides > Dell ObjectScale and Integrated Systems for Data Analytics using Microsoft Azure HCI and SQL 2022 > Solution introduction
Data virtualization is a technology that enables organizations to access and manipulate data from multiple disparate sources as if it were coming from a single unified source. This process works by creating a logical layer of abstraction between data consumers and the underlying data sources.
Data virtualization has become popular among large enterprises because unstructured and semi-structured data is common and processing that data is challenging. Marketing leaders across industries expect the data to be available for easy consumption to speed up their decision-making process.
Data analytics is a rapidly evolving field that plays a crucial role in today’s data-driven era. The processes of data analytics involve the exploration, interpretation, and extraction of valuable insights from raw, structured, and unstructured data to identify trends and perform analysis to answer business questions. This type of analysis allows businesses to gain a deeper understanding of data to derive insights and communicate meaningful data patterns within an organization to improve business outcomes.
The PolyBase feature in Microsoft SQL Server 2022 facilitates data virtualization, enabling users to access and query data from various sources, which helps businesses overcome data integration and analysis challenges.
Dell Integrated System for Microsoft Azure Stack HCI is an ideal platform for delivering maximum performance, scalability, resiliency, and operational efficiency from your data estates. As an integrated system, Azure stack HCI bundles engineering validated, factory-ready hardware configurations, full stack life cycle management, and an integrated collaborative enterprise support model.
Azure Arc is a solution that empowers organizations to adopt a consistent and flexible approach to managing and deploying resources across hybrid and multicloud environments, while leveraging the benefits of Azure services and management tools.
Dell ObjectScale is a software-defined enterprise-grade object storage. Built with a scale-out architecture, ObjectScale clusters expand from a few terabytes to petabytes and beyond without limits on the number of object stores, buckets, or objects stored. Clusters can start as small as three nodes and scale to thousands.
The Dell Validated Design for SQL Server Analytics has been developed to address the needs of organizations deploying advanced analytics. It incorporates the Dell Integrated System for Microsoft Azure Stack HCI platform and ObjectScale storage.
This document provides design guidance for data analytics infrastructure managers and architects by describing a predesigned, validated, and scalable architecture for SQL Server advanced analytics on Dell hardware infrastructure.
The aim of this Dell Validated Design is to provide a Microsoft SQL Server 2022 database solution on Dell Integrated system for Microsoft Azure Stack HCI to IT managers, architects, DBAs, developers, data engineers and data scientists. It is a guide designed for enterprises that plan to run data analytics workloads with SQL Server 2022 using Delta Lake and object storage integration.