vladimircaribb - stock.adobe.com
Microsoft SQL Server 2022 is generally available today, marking the first major update for Microsoft's longstanding on-premises database technology in three years.
A key theme of the Microsoft SQL Server 2022 update is integration with Azure SQL cloud database services, providing a way for organizations to bridge the on-premises to cloud divide.
Microsoft SQL Server was first launched in 1989. Over the last decade in particular, an increasing volume of workloads have moved off premises to the cloud, where Microsoft offers a number of different platforms including Azure SQL Database, and Azure SQL Managed Instance, an offshoot that’s more compatible with SQL Server.
Microsoft SQL Server 2022 has been in preview since 2021, providing organizations with early access. The cloud integrations that are part of the SQL Server 2022 release enable organizations to back up databases to the cloud for disaster recovery.
The updated database is also integrated with other cloud data services, including the Microsoft Purview data governance service and Azure Synapse Analytics.
Microsoft SQL Server competes against other relational databases such as Oracle Database, IBM Db2 and the open source PostgreSQL database.
SQL Server is becoming more tightly integrated into Microsoft's broader ecosystem strategy with the Microsoft Intelligent Data Platform in the cloud, said Gartner analyst Adam Ronthal.
"SQL Server is increasingly Azure-aware for business continuity, easy connectivity to cloud analytics via Synapse and governance with Microsoft Purview," Ronthal said. "This strengthens Microsoft's hybrid cloud story."
One of the new features that Microsoft SQL Server 2022 enables is for organizations to use the cloud for disaster recovery.
Organizations can now choose any Azure cloud region to have an Azure SQL Managed Instance to support disaster recovery for SQL Server 2022.
Organizations often have multiple SQL Server deployments on premises for high availability, but for disaster recovery, they need to move data to a different location. The combination of Azure SQL Managed Instance with SQL Server 2022 now enables organizations to get a read-only replica of their data from which they can recover when needed.
"This was honestly the most used feature even in the preview for SQL Server 2022, because why would you not do it? Anybody who's running in production has to do disaster recovery," said Asad Khan, vice president of SQL products and services at Microsoft.
For the last two years, Microsoft users have been able to use Azure Synapse Analytics for data analytics on cloud data. With SQL Server 2022, Microsoft enabled Azure Synapse to work with data that is stored in the on-premises database.
"Now you can really do real-time analytics on top of all your data," Khan said.
Enabling data governance for data that is on premises as well as in the cloud is another key capability that is supported in Microsoft SQL Server 2022. The Microsoft Purview data governance service can now also give organizations visibility into data and how it is used, whether the data resides in the cloud or on premises.
As part of the cloud-enablement theme that is the foundation of Microsoft SQL Server 2022, the update also integrates with Azure Active Directory to authenticate users with cloud-based access control.
"There is a lot in this release that opens up and that also truly converts a SQL Server into a hybrid play, and many of these things will continue to improve," Khan said.
Logi Symphony combines capabilities from numerous Insightsoftware acquisitions and adds support for generative AI so that users ...
The longtime analytics vendor's suite incorporates LLM technology to make users more efficient by enabling them to use natural ...
Compose SDK for Fusion is a composable set of APIs that enable developers to build customized advanced analytics applications to ...
Many organizations struggle to manage their vast collection of AWS accounts, but Control Tower can help. The service automates ...
There are several important variables within the Amazon EKS pricing model. Dig into the numbers to ensure you deploy the service ...
AWS users face a choice when deploying Kubernetes: run it themselves on EC2 or let Amazon do the heavy lifting with EKS. See ...
With generative AI, knowledge management teams can automate knowledge capture and maintenance processes. Explore how AI can ...
OpenAI and Box founders discuss the rise of generative AI in the enterprise and how it will change knowledge workers' routines ...
The vendor adds a new internal publishing system to its stable of content management tools. It enables users to curate and ...
With its Cerner acquisition, Oracle sets its sights on creating a national, anonymized patient database -- a road filled with ...
Oracle plans to acquire Cerner in a deal valued at about $30B. The second-largest EHR vendor in the U.S. could inject new life ...
The Supreme Court ruled 6-2 that Java APIs used in Android phones are not subject to American copyright law, ending a ...
SAP unveiled products and services to spur cloud migrations, including the new S/4HANA Cloud, private edition; a premium plus ...
At Spend Connect Live, SAP unveiled plans to embed generative AI into its spend management applications and introduced its Spend ...
SAP's Joule is the company's generative AI assistant for its cloud portfolio, but the technology is still in the early stages and...
All Rights Reserved, Copyright 2005 - 2023, TechTarget
Privacy Policy
Cookie Preferences
Do Not Sell or Share My Personal Information
source
