Yesterday, November 16 2022, Microsoft announced the general availability of SQL Server 2022. The long-awaited new release of SQL Server, includes many features in all aspects of the popular data platform, but also an additional set of features, that make SQL Server the most Azure-enabled release of SQL Server yet. Let’s discuss about the highlights of these features.
Business Continuity Features
The highlights in terms of new features and enhancements under this category, are Bidirectional HA/DR to Azure SQL Managed Instance which allows replicating your databases to Azure SQL Managed instance, and many Availability Group-Related enhancements such as Contained Availability Groups, that besides the databases themselves, they can also manage/include logins, jobs and other objects.
Security Features
The highlight in this category of features, is of course SQL Server Ledger, which enables the Database Engine to automatically keep record of data modifications over time, and secure these records with blockchain technology.
Performance Features
The highlights of features in this category, are Query Store enhancements and many Built-in Intelligent Query Processing enhancements, such as: Parameter Sensitive Plan Optimization, Degree of Parallelism (DOP) Feedback, Cardinality Estimation (CE) Feedback, Memory Grant Feedback Persistence and Percentile and much more.
Other Features
In addition to the above highlights of new features, many other features have been added, such as: T-SQL enhancements, Buffer Pool Parallel Scan, XML Compression, support for new hardware capabilities and other.
Azure-Related Enhancements
As mentioned in the beginning of this article, this new release of SQL Server, includes a special set of features that make SQL Server the most Azure-enabled release of SQL Server yet.
These features are:
- Link to Azure SQL Managed Instance for High Availability
- Microsoft Defender for Cloud integration
- Microsoft Purview integration
- Azure Active Directory authentication for connecting to SQL Server
- Support for certificate and key backup and restore integration scenarios with Azure Blob Storage service
- Install Azure Arc agent via SQL Server at setup
Learn More About What’s New in SQL Server 2022 – Enroll to the Course!
Feel free to check our course on Udemy, titled “SQL Server 2022: What’s New – New and Enhanced Features“.
Via the course, you will learn all about the new features and enhancements in SQL Server 2022, via a rich set of high-quality lectures, infographics and step-by-step live demonstrations.
Watch the course preview:
Featured Online Courses:
- SQL Server 2022: What’s New – New and Enhanced Features
- Working with Python on Windows and SQL Server Databases
- Introduction to Azure Database for MySQL
- Boost SQL Server Database Performance with In-Memory OLTP
- Introduction to Azure SQL Database for Beginners
- Essential SQL Server Administration Tips
- SQL Server Fundamentals – SQL Database for Beginners
- Essential SQL Server Development Tips for SQL Developers
- Introduction to Computer Programming for Beginners
- .NET Programming for Beginners – Windows Forms with C#
- SQL Server 2019: What’s New – New and Enhanced Features
- Entity Framework: Getting Started – Complete Beginners Guide
- Data Management for Beginners – Main Principles
- A Guide on How to Start and Monetize a Successful Blog
Read Also:
- SQL Server 2022: What’s New – New and Enhanced Features (Course Preview)
- SQL Server 2022 Overview: A Hybrid Data Platform
- Query Store Enhancements in SQL Server 2022
- What is Data Management and why it is Important?
- What is Data Security and which are its Main Characteristics?
- An existing History Table cannot be specified with LEDGER=ON – How to Resolve
- Data Security vs. Data Privacy
- What are NoSQL Databases?
- Differences Between Batch and Streaming Data
- What is Data Compliance within the Data Management Scope?
- How to Connect to SQL Server Databases from a Python Program
- How to Resolve: [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriverConnect)
- Useful Python Programming Tips
- Main Data Structures in Python
- Working with Python on Windows and SQL Server Databases (Course Preview)
- How to Write to a Text File from a C++ Program
- How to Establish a Simple Connection from a C# Program to SQL Server
- The timeout period elapsed prior to obtaining a connection from the pool
- Closing a C# Application (including hidden forms)
- Changing the startup form in a C# project
- Using the C# SqlParameter Object for Writing More Secure Code
- Cannot implicitly convert type ‘string’ to ‘System.Windows.Forms.DataGridViewTextBoxColumn
Subscribe to our newsletter and stay up to date!
Subscribe to our YouTube channel (SQLNetHub TV)
Easily generate snippets with Snippets Generator!
Secure your databases using DBA Security Advisor!
Generate dynamic T-SQL scripts with Dynamic SQL Generator!
Check our latest software releases!
Check our eBooks!
Rate this article: 
(1 votes, average: 5.00 out of 5)
Loading...
Reference: SQLNetHub.com (https://www.sqlnethub.com)
© SQLNetHub
Artemakis Artemiou is a seasoned Senior Database and AI/Automation Architect with over 20 years of expertise in the IT industry. As a Certified Database, Cloud, and AI professional, he has been recognized as a thought leader, earning the prestigious Microsoft Data Platform MVP title for nine consecutive years (2009-2018). Driven by a passion for simplifying complex topics, Artemakis shares his expertise through articles, online courses, and speaking engagements. He empowers professionals around the globe to excel in Databases, Cloud, AI, Automation, and Software Development. Committed to innovation and education, Artemakis strives to make technology accessible and impactful for everyone.