Monday, May 29, 2023
  • Events
  • Interviews
  • Jobs
  • Opinion
  • Whitepapers
  • Podcasts
  • Web Hosting Directory
  • Login
  • Register
Cloud7
  • Cloud Computing
  • Web Hosting
  • Data Center
  • Linux
  • Cybersecurity
  • More
    • Software
    • Network/Internet
    • Hardware
    • Artificial Intelligence
    • Windows
    • Policy/Legislation
    • Blockchain
    • Troubleshooting
    • How-Tos
    • Articles
No Result
View All Result
Cloud7
  • Cloud Computing
  • Web Hosting
  • Data Center
  • Linux
  • Cybersecurity
  • More
    • Software
    • Network/Internet
    • Hardware
    • Artificial Intelligence
    • Windows
    • Policy/Legislation
    • Blockchain
    • Troubleshooting
    • How-Tos
    • Articles
No Result
View All Result
Cloud7
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. 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, 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

Wix opening up its backend

Wix opening up its backend

May 10, 2023 6:10 pm
Wix Launches Wix Shipping, a native solution powered by Shippo

Wix Launches Wix Shipping, a native solution powered by Shippo

May 4, 2023 4:00 pm
The 20i FOSS awards are now open for voting

The 20i FOSS awards are now open for voting

May 4, 2023 1:00 pm

GitHub’s private vulnerability reporting is now available to everyone

April 25, 2023 2:20 pm
Get free daily newsletters from Cloud7 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

Editor's Choice

10 best web hosting services

7 best shared hosting service providers

7 best Linux distros for beginners

7 best Linux distros for gaming

7 best cloud storage services for business

7 best Linux desktop environments

Farewell and gratitude: The journey ends for Cloud7

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.

Recent News

  • Farewell and gratitude: The journey ends for Cloud7
  • Gcore Partners with Pienso
  • LibreOffice 7.4.7 is now available for download
  • AI-powered automatic time tracking (Podcast #20 w/ Catalina Butnaru)
  • Best file managers for Linux
  • EuroLinux 9.2 is now available for download
  • X3D, or not X3D, that is the question

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
  • Artificial Intelligence
  • How-Tos
  • Troubleshooting

RESOURCES

  • Events
  • Interviews
  • Jobs
  • Opinion
  • Whitepapers
  • Podcasts
  • Web Hosting Directory

Get the Cloud7 Newsletter

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

  • About Us
  • Privacy & Policy
  • Copyright Policy
  • Contact Us

© 2023, Cloud7. All rights reserved.

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

© 2023, Cloud7. 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

Add New Playlist

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