Friday, February 3, 2023
  • Events
  • Interviews
  • Jobs
  • Opinion
  • Whitepapers
  • Glossary
  • Community Forum
  • Web Hosting Directory
  • Login
  • Register
Cloud7 News
  • Cloud Computing
  • Web Hosting
  • Data Center
  • Linux
  • Cybersecurity
  • More
    • Network/Internet
    • Windows
    • Software
    • Hardware
    • Blockchain
    • Policy/Legislation
    • How-Tos
    • Troubleshooting
No Result
View All Result
Cloud7 News
  • Cloud Computing
  • Web Hosting
  • Data Center
  • Linux
  • Cybersecurity
  • More
    • Network/Internet
    • Windows
    • Software
    • Hardware
    • Blockchain
    • Policy/Legislation
    • How-Tos
    • Troubleshooting
No Result
View All Result
Cloud7 News
No Result
View All Result

Home > Development > SQL Server 2022 is now available

SQL Server 2022 is now available

Microsoft officially announced the general availability of SQL Server 2022, the most Azure-enabled release of SQL Server yet.


Erdem Yasar Erdem Yasar
November 17, 2022
3 min read
SQL Server 2022 is now available
  • Microsoft announced the general availability of SQL 2022 with continued innovation across performance, security, and availability.
  • SQL 2022’s Azure integration includes managed disaster recovery to Azure SQL Managed Instance, along with near real-time analytics.
  • Via a simple connection to Azure Arc, users now have access to a new cloud-enabled billing model for SQL Server, providing cost efficiency to pay only for what you use.

Microsoft announced the general availability of SQL Server 2022, the latest milestone in the more than 30-year history of SQL Server. Microsoft referred to the latest release as the most Azure-enabled release of SQL Server yet. SQL Server 2022 is a core element of the Microsoft Intelligent Data Platform, which is capable of integrating operational databases, analytics, and data governance, allowing users to adapt in real time, add layers of intelligence to their applications, unlock fast and predictive insights, and govern their data.

The most Azure-enabled SQL Server ever

SQL Server 2022 simplifies driving deeper insights, predictions, and governance from the data with connections to Azure, including Azure Synapse Link and Microsoft Purview. Azure integration includes managed disaster recovery (DR) to Azure SQL Managed Instance, along with near real-time analytics, which makes it possible for database administrators to manage their data estates with greater flexibility. 

Azure-enabled features

Link feature for Azure SQL Managed Instance: SQL Server 2022 is fully integrated with the new link feature in Azure SQL Managed Instance, enabling users to benefit from a PaaS environment applied to disaster recovery to minimize the time spent on setup and management even compared to an IaaS environment. The feature uses a built-in Distributed Availability Group to replicate data to a previously deployed Azure SQL Managed Instance as a DR replica site.

  • Azure Synapse Link for SQL: Azure Synapse Link for SQL Server 2022 provides automatic change feeds to capture the changes within SQL Server and feed them into Azure Synapse Analytics. Synapse Link provides near real-time analysis and hybrid transactional and analytical processing with minimal impact on operational systems. When the data comes to Synapse, users can combine it with various data sources regardless of their size, scale, or format, and run powerful analytics by using Azure Machine learning, Spark, or Power BI.
  • Microsoft Purview integration: Microsoft Purview is a unified data governance and management service. SQL Server is also integrated with Microsoft Purview for greater data discovery, allowing users to break down data silos. Through this integration you will be able to:
    • Automatically scan your on-premises SQL Server for free to capture metadata.
    • Classify your data using built-in and custom classifiers and Microsoft Information Protection sensitivity labels.
    • Set up and control specific access rights to SQL Server.
  • Additional Azure-connected features: SQL Server 2022 has a number of additional Azure-enabled features. A simple connection to the Azure Arc agent, part of the default setup process for SQL Server 2022, enables additional capabilities, including:
    • Single view of all SQL Servers deployed on-premises, in Azure and other clouds.
    • Fully automated technical assessment for SQL Server at no additional cost, to help you optimize your database’s performance, scalability, security, business continuity, and more.
    • Protect your on-premises data using Microsoft Defender for Cloud.
    • Secure identities with Single Sign-On and Azure Active Directory.
    • Pay-as-you-go billing.

Microsoft also announced a new billing model that provides flexibility to innovate quickly. With a simple connection to Azure Arc, a default part of the SQL Server 2022 setup process, users will have access to a new cloud-enabled billing model for SQL Server, providing cost efficiency to pay only for what you use. Pay by the hour for consumption spikes and ad hoc usage without the need for upfront investment.

See more Development News


Tags: Microsoft
Erdem Yasar

Erdem Yasar

Erdem Yasar is a news editor at Cloud7 News. Erdem started his career by writing video game reviews in 2007 for PC World magazine while he was studying computer engineering. In the following years, he focused on software development with various programming languages. After his graduation, he continued to work as an editor for several major tech-related websites and magazines. During the 2010s, Erdem Yasar shifted his focus to cloud computing, hosting, and data centers as they were becoming more popular topics in the tech industry. Erdem Yasar also worked with various industry-leading tech companies as a content creator by writing blog posts and other articles. Prior to his role at Cloud7 News, Erdem was the managing editor of T3 Magazine.

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

I agree to the Terms & Conditions and Privacy Policy.

Next Post
Cisco Talos shares the details of Excel's double-free vulnerability

Cisco Talos shares the details of Excel's double-free vulnerability

Related News

Google is shutting down its website optimization solution

Google is shutting down its website optimization solution

January 27, 2023 1:20 pm
WP to use GitHub as a central communication tool

WordPress to use GitHub as a central communication tool

January 24, 2023 4:00 pm
WordPress.org Project's big picture goals for 2023

WordPress Project’s big picture goals for 2023

January 20, 2023 1:15 pm
Git is patched for two critical vulnerabilities

Git is patched for two critical vulnerabilities

January 19, 2023 12:30 pm
Get free daily newsletters from Cloud7 News Get the Cloud7 Newsletter
Select list(s):

Check your inbox or spam folder to confirm your subscription.

By subscribing, you agree to our
Copyright Policy and Privacy Policy

Get the free newsletter

Subscribe to receive the latest IT business updates straight to your inbox.

Select list(s):

Check your inbox or spam folder to confirm your subscription.

Editor's Choice

What’s new in Linux kernel 6.2 rc6?

10 Best Web Hosting Services of 2023

Ubuntu 22.04 LTS is available for download. What is new?

CERN and Fermilab recommend AlmaLinux

7 best hosting control panels of 2023

How to update Linux Kernel without rebooting?

7 best Linux mail servers of 2023

7 best cPanel alternatives for 2023

7 best Linux web browsers for 2023

7 best CentOS alternatives

7 best Linux server distros of 2023

Interview with Igor Seletskiy on AlmaLinux

How to create a VM on VMware Workstation

Recent News

  • LockBit encryptor source code is updated
  • LibreOffice 7.5 Community is released. What’s new?
  • NTT to add Palo Alto Networks’ solution to its portfolio
  • Gcore announces partnership with Super Protocol
  • Fortinet is expanding its SOC offerings portfolio

Cloud7 News
Cloud7 is a news source that publishes the latest news, reviews, comparisons, opinions, and exclusive interviews to help tech users of high-experience levels in the IT industry.

EXPLORE

  • Web Hosting
  • Cloud Computing
  • Data Center
  • Cybersecurity
  • Linux
  • Network/Internet
  • Software
  • Hardware
  • How-Tos
  • Troubleshooting

RESOURCES

  • Events
  • Interviews
  • Jobs
  • Opinion
  • Whitepapers
  • Glossary
  • Community Forum
  • Web Hosting Directory

Get the Cloud7 Newsletter

Get FREE daily newsletters from Cloud7 delivering the latest news and reviews.

  • About
  • Privacy & Policy
  • Copyright Policy
  • Contact

© 2023, Cloud7 News. All rights reserved.

No Result
View All Result
  • Cloud Computing
  • Web Hosting
  • Data Center
  • Linux
  • Cybersecurity
  • More
    • Network/Internet
    • Windows
    • Software
    • Hardware
    • Blockchain
    • Policy/Legislation
    • How-Tos
    • Troubleshooting
  • Events
  • Interviews
  • Jobs
  • Opinion
  • Whitepapers
  • Glossary
  • Community Forum
  • Web Hosting Directory

© 2023, Cloud7 News. All rights reserved.

Welcome Back!

Sign In with Facebook
Sign In with Google
Sign In with Linked In
OR

Login to your account below

Forgotten Password? Sign Up

Create New Account!

Sign Up with Facebook
Sign Up with Google
Sign Up with Linked In
OR

Fill the forms below to register

*By registering into our website, you agree to the Terms & Conditions and Privacy Policy.
All fields are required. Log In

Retrieve your password

Please enter your username or email address to reset your password.

Log In
This website uses cookies. By continuing to use this website you are giving consent to cookies being used. Visit our Privacy and Cookie Policy.