Home > Workload Solutions > SQL Server > White Papers > Scaling SQL Server 2022 VMs on Dell Integrated System for Microsoft Azure Stack HCI > New features in Microsoft SQL Server 2022
SQL Server has been a leader in performance, availability, and security. Now, SQL Server 2022 product also delivers the most cloud connected database platform to date.
Azure Arc-enabled SQL Server extends Azure services to SQL Server instances hosted outside of Azure whether in your data center, edge locations, or any public cloud or hosting provider. To onboard a SQL Server to Azure Arc-enabled SQL Server, an agent must be installed. This agent can be deployed during the initial setup for SQL Server 2022 or after it has been running. The agent provides a rich feature set which consists of:
Bi-directional HA/DR between on-premises and Azure SQL with Azure SQL link contributes to platform resiliency. DBAs can use Azure as their DR location or gain additional insights against their read-only data instance with Azure SaaS reporting services. An integrated Distributed Availability Group (DAG) will manage all the data replication. Overall, the feature requires minimal configuration and maintenance.
The SQL engine has also been improved for on-premises workloads. Intelligent Query Processing (IQP) handles daily performance tuning work from an automated, do no harm, perspective. The performance of TempDB has now removed almost all object, metadata, and temp table contention. Internal improvements to the TempDB database for SQL 2022 almost guarantee a performance boost for any environment with no additional code changes.
Another major feature in SQL 2022 includes the ability to read from S3 object storage. DBAs can also backup to and from S3 object storage. As organizations seek to gain a competitive advantage with their intelligent data estate, it is critical to have the ability to access to all types of datasets. SQL Server 2022 combined with Dell ECS, or PowerScale, are the preferred technologies for querying a data lake using a T-SQL surface area. This combination of products and tools yields modern opportunities to store and manage different types of data on-premises and at public cloud scale.
Dell ECS and PowerScale with Microsoft SQL Server 2022 can provide limitless scale to your data estate. With both products existing within the solution architecture, data stewards can do even more with data, provide deeper insights, and foster next-gen solutions. For more information, see the Dell ECS and Microsoft SQL 2022 white paper.