Microsoft has formally launched its highly-anticipated SQL Server 2022 and, at first look, it’d seem like extra of a pitch for Azure. With enhancements to safety and efficiency options, in addition to a number of Azure-friendly functionalities, SQL Server 2022 customers can actually anticipate a renewed expertise from their SQL Server situations.
SEE: The Essential Microsoft SQL Server Training Bundle (TechRepublic Academy)
In this report, we’ll cowl extra particulars of the SQL Server 2022 launch together with unique commentary from Asad Khan, Vice President of SQL Products and Services at Microsoft.
Jump to:
Fast info on Microsoft SQL Server 2022
Microsoft SQL Server 2022 presents customers numerous new options with a cloud-friendly emphasis. The new answer presents enhancements in question efficiency with Query Store on by default. It additionally has easier availability choices for multi-write places, enabled by automating the “last-writer wins” rule. Additionally, the immutable, tamper-evident SQL Ledger helps the eventualities that blockchain has promised however not often delivered.
SEE: The Microsoft SQL Server and T-SQL Course for Beginners (TechRepublic Academy)
Like the brand new T-SQL capabilities that add JSON help, these options are all obtainable on-premises. But a lot of the emphasis with this launch is on integrating with the next cloud companies which can be a part of Microsoft’s Intelligent Data Platform:
- Azure SQL Managed Instance: Primarily used for catastrophe restoration and replicated information failover.
- Azure Synapse Analytics: For monitoring and managing information modifications.
- Microsoft Purview: Used to scan, classify, monitor and management information by yourself SQL Servers for compliance and information governance.
- Microsoft Defender for SQL: Useful for safety and authentication, even with on-premises servers
- Azure Active Directory: Allows you to make use of the Azure portal to handle SQL Server wherever you run it.
Why a lot concentrate on Azure and the cloud?
With such a robust concentrate on cloud compatibility and Microsoft Azure specifically, it’s straightforward to imagine that SQL Server 2022 is just proper for present Azure customers. However, this new launch is just not about inducing organizations to maneuver to Azure, Asad Khan instructed TechRepublic: It’s about giving everybody the advantages of improvements within the cloud with out having emigrate.
“What we wanted to do with SQL 2022 was blur the line between whether you are running SQL in Azure or whether you are running outside. And when I say outside, it could be a customer data center, it could be AWS, it could be GCP. It could be anywhere.”
SEE: Top cloud and software migration instruments (TechRepublic)
As an instance of how SQL Server 2022 works past Azure environments, Defender for SQL can monitor your SQL Server workloads on-premises or in different clouds and warn you about varied efficiency and safety points. There’s additionally integration with Azure Storage; the article storage help means you possibly can connect with any S3-compatible storage supplier, together with AWS.
Creating an optimum SQL Server expertise for all customers
SQL Server is constructed from the identical codebase no matter how you employ it. Whether you’re utilizing Azure in your personal information middle, in a VM, in a container, on the edge with Azure SQL Edge’s subset options, via the Azure SQL Managed Instance, or via DB companies, new and improved SQL Server options are exhibiting up in every single place.
“If I do an improvement in the query processing, [or] if I improve the storage capability, or [if] I do something for Polybase or virtualization, it goes to all the deployment options,” Khan defined.
However, some options take extra work to make obtainable exterior the cloud. Azure SQL Database had an immutable ledger some years in the past, and Microsoft determined to convey an identical characteristic to SQL Server 2022. You can now create a cryptographically hashed, audited ledger desk that makes it apparent if somebody makes an attempt to tamper with the info.
You may also make an append-only desk if you want to show to somebody who would possibly or may not belief you that the info hasn’t been altered. An airplane producer thought of utilizing Ledger in SQL Edge on its planes to offer a trusted report for the FAA, Khan revealed to us. “We are able to solve 80% of the blockchain scenarios through this.”
Making cloud information restoration obtainable to cloud and on-prem customers
But there are additionally companies in Azure, which SQL Server connects to natively, that aren’t going to be as simply obtainable on different infrastructure. “We realized that unless we break this barrier between the cloud and on-prem, [then] all the innovation that we are doing in the cloud, our on-prem customers will never get,” mentioned Khan.
The Microsoft staff is regularly in search of options to bridge the hole between Azure and on-premises SQL Server customers. One integration that proved very fashionable within the preview model of SQL Server 2022 was utilizing Azure SQL Managed Instance for DR (catastrophe restoration), which is now quite simple to arrange utilizing a wizard and comes with no additional licensing value.
SEE: Best information restoration software program (TechRepublic)
Although you’ll be charged for Azure assets like storage for the databases you replicate to the cloud, you don’t have to funds for the same old per-core SQL license. That’s as a result of Microsoft now treats this as a 3rd DR choice alongside the free learn reproduction and free passive situations already included within the SQL Server license.
Even organizations which have determined to maintain SQL Server on their very own infrastructure fairly than shifting it to the cloud are considering cloud DR due to the prices of standing up a failover server in a separate information middle area; some would possibly already use a internet hosting supplier to do precisely that.
The hyperlink to Managed Instance makes use of the identical distributed availability teams database admins will already be utilizing for DR, so you possibly can check out cloud DR alongside any present DR infrastructure to see should you can substitute that infrastructure if you’re prepared, or when your contract runs out. “[If] you are using a PaaS service for the DR, it comes for free,” Khan identified: “Why would you not do it?”
Plus, the reproduction you get in Azure isn’t passive: It’s read-only, however it’s information you possibly can learn and use for analytics. “You can do queries against it; you can do Power BI against it because now you’re in the cloud,” added Khan.
SQL Server integrations with analytics on the forefront
If you need to go additional with analytics — an space the place Khan notes a lot of the innovation is occurring within the cloud — you may also combine with Azure Synapse, a service initially developed for Azure Cosmos DB, which regularly streams the change feed out of your database right into a information lake.
Within the info lake, you need to use your alternative of cloud analytics instruments to work with information with out impacting your operational database or ready for ETL batch jobs to run. Again, this makes use of present SQL Server capabilities. In this case, the self-hosted integration runtime is already utilized by Azure Data Factory.
SEE: Best ETL instruments and software program (TechRepublic)
If you’re already replicating your database into Azure SQL Managed Instance for operational causes, you possibly can hyperlink that to Azure Synapse fairly than shifting information to the cloud twice, as soon as within the proprietary SQL Server format and as soon as in an open format that you need to use with both SQL or Spark runtimes. On the opposite hand, you would possibly need to allow each connections.
“There are fine-tuning knobs in each,” Khan identified. “For Synapse Link, you can choose which database and which tables you want the analytics on, whereas for a DR scenario, you typically pick it at a database level. We didn’t want to say ‘you can only do analytics on the databases you have picked for DR’”. Think of the connections as Lego blocks you possibly can combine and match to construct the system you want, he prompt.
SEE: Hiring equipment: Microsoft Power BI developer (TechRepublic Premium)
That type of flexibility makes the hyperlink to Managed Instance greater than only a easy approach to do DR. It additionally enables you to check the efficiency of SQL Server on Azure and get aware of working with a cloud service via your present database instruments like SQL Server Management Studio and the remainder of the Azure portal.
If organizations discover the flexibility to do Power BI and analytics queries in opposition to their information within the cloud helpful sufficient, which may give them the boldness to maneuver to the cloud. With the database replicated in Azure already, that’s so simple as failing over to Managed Instance.
How can I get began with SQL Server 2022?
SPLA, Microsoft Cloud Solution Providers and OEMs will get entry to this software in January 2023. According to Microsoft, this second group accounts for lower than 20% of the SQL Server enterprise.
For most organizations, SQL Server 2022 is obtainable now, beginning on November 16, 2022. You can entry the brand new software instantly from the Microsoft web site and get extra info from their staff there. For newer SQL Server customers, we extremely advocate investing in a Microsoft SQL Server Course for Beginners to get your preliminary footing with the platform.
Read subsequent: Top information governance instruments (TechRepublic)