SQL Server 2022: What’s New – New and Enhanced Features
In this course, you will learn all about the new major features and enhancements in SQL Server 2022. Via a comprehensive set of video lectures, enriched with step-by-step live demonstrations, you will learn about all the major features and enhancements in SQL Server 2022, such as Bidirectional HA/DR to Azure SQL Managed Instance, Contained Availability Groups, SQL Server Ledger/Blockchain Ledger Tables and other security-related features, Query Store enhancements, Built-in Intelligent Query Processing Enhancements such as Parameter Sensitive Plan Optimization, Azure Synapse Link, T-SQL enhancements and much more.
SQL Server 2022, is the most Azure-enabled release of SQL Server yet. Besides the many new features and enhancements for the on-premises Database Engine, it also includes a large number of significant Azure integration features. In this course, we will be discussing all these, to get a clear picture of all the new features and enhancements in this version of SQL Server, that is SQL Server 2022.
We will begin the course by discussing, how SQL Server evolved to a hybrid data platform, by listing the Azure integration features that were added in each release of SQL Server up to the 2022 version. Then, we will start discussing the new features and enhancements, by first discussing the Business Continuity features and enhancements such as Bidirectional HA/DR to Azure SQL Managed Instance, Contained Availability Groups, and other related enhancements. Right after these, we will be discussing the security features and enhancements. To this end, among others, we will be talking about SQL Server ledger tables and see a relevant live demonstration.
In the next section, we will be discussing the Performance Features and Enhancements in SQL Server 2022, and more precisely, the Query Store enhancements and Built-in Intelligent Query Processing enhancements, and see some interesting live demonstrations of Query Store and Parameter Sensitive Plan Optimization.
Last but not least, we will be discussing other features and enhancements, such as Azure Synapse Link, Management Features & Enhancements, and T-SQL Enhancements.
After completing the course, you will know:
PREREQUISITES:
In today's digital age, opportunities for earning money have expanded significantly. One avenue that has… Read More
Earning apps have become increasingly popular as people look for ways to make money conveniently… Read More
In today's fast-paced digital world, opportunities to earn money online have become increasingly popular. One… Read More
Full Web Ethical Hacking Course Learn all about web application penetration testing! What you'll learn… Read More
Build Chatbots Using Javascript Build Chatbots Using Javascript From Scratch What you'll learn Build Chatbots… Read More
Basic Learning about Linux Daily use commands Basic knowledge to get you started What you'll… Read More