Overall, it includes even more game-changing upgrades to query processing, security, and disaster recovery-providing a holistic opportunity for companies to harness data and leverage it for growth.

The system, available in 2022, is part of Microsoft’s broader vision for an end-to-end data platform providing customers with operational databases, analytics and governance, and the ability to seamlessly bridge on-premises deployments to the cloud. Microsoft is hoping to bolster this performance advantage with the newly announced SQL Server 2022, which-with the help of Microsoft and Intel engineers-will be optimized for the Intel 3rd Generation Xeon Scalable processors. “It’s a testament to our engineers, who continually enhance the database engine with built-in query intelligence so that customers can gain performance with no application changes required.” “They asked, ‘What the heck did you guys do?’” laughs Bob Ward, Principal Architect for the Microsoft Azure Data team, which oversees the SQL Server and Azure Data technology architecture.

Sql server versions