Microsoft launched a collection of knowledge providers enhancements at its Microsoft Ignite digital convention on Nov. 2.
Among the many new information providers is a preview of SQL Server 2022.
SQL Server had its final main milestone replace two years in the past, with the SQL Server 2019 replace. An enormous focus with the 2022 replace for SQL server is a tighter integration with the Microsoft Azure cloud.
In the meantime, Microsoft is giving the Cosmos DB database a collection of incremental updates, together with indexing metrics to assist optimize question efficiency and a brand new Patch API that permits optimized partial doc updates within the database.
“Cosmos DB stays a powerful multimodel nonrelational DBMS [database management system] providing,” mentioned Gartner analyst Adam Ronthal. “In offering a platform with a number of nonrelational APIs, Microsoft positions Cosmos DB as a versatile, fashionable DBMS for cloud-native functions.”
In Ronthal’s view, Microsoft is taking a special strategy with Cosmos DB than a few of its core rivals in offering a multimodel nonrelational platform reasonably than a number of best-fit engineered techniques.
“This supplies a unified strategy which will likely be interesting to organizations seeking to consolidate their information administration panorama,” Ronthal mentioned.
SQL Server 2022 set to spice up Microsoft cloud information providers
Whereas Cosmos DB is a more recent multimodel cloud native database, Microsoft continues to be dedicated to advancing its extra established SQL Server database as properly. Cosmos DB was first launched in 2017, whereas SQL Server’s historical past goes again to 1989, predating the trendy cloud period.
Adam RonthalAnalyst, Gartner
With SQL Server 2022, Microsoft’s purpose is to deliver the relational database platform into its Azure cloud ecosystem.
“SQL Server 2022 is essentially the most cloud-enabled launch of SQL Server but,” Scott Guthrie, govt vp at Microsoft, mentioned throughout an Ignite technical session.
Guthrie famous that SQL Server 2022 provides new enterprise continuity capabilities with a built-in catastrophe restoration integration inside Azure.
The replace additionally provides an integration with Azure Purview, a knowledge governance platform. Guthrie added that it additionally consists of analytics for on-premises operational SQL Server information with Azure Synapse analytics working within the cloud.
Total, Guthrie mentioned Microsoft is seeking to present bidirectional flexibility between its on-premises and cloud information providers.
With the route that Microsoft is taking with SQL Server 2022, Ronthal mentioned it helps to place Azure as a middle of gravity for each analytics and enterprise continuity, whereas offering a holistic strategy to each on-premises and cloud elements.
“Microsoft continues to spend money on deeper integration between on-premises elements and cloud elements, capitalizing on their energy in each arenas,” Ronthal mentioned.