SQL Server 2022: What's New - New and Enhanced Features

Focused View

Artemakis Artemiou

2:41:46

244 View

1. Introduction

1. Welcome to the Course! What Will you Learn.mp4

03:38

2. SQL Server 2022 Overview A Hybrid Data Platform.mp4

03:54

3.1 SQL-Server-2022-T-SQL-Create-Sample-Database.pdf

3. Setting up our Demo Environment - Installing SQL Server 2022 & SSMS.mp4

24:18

4.1 SQL-Server-2022-Recap-Introduction.pdf

4. Section Recap.mp4

01:16

5. Introductory Concepts.html

2. Business Continuity Features and Enhancements

1. Section Overview.mp4

01:20

2. Bidirectional HADR to Azure SQL Managed Instance.mp4

05:54

3. Availability Group-Related and Other Enhancements.mp4

04:20

4.1 SQL-Server-2022-Recap-Business-Continuity.pdf

4. Section Recap.mp4

01:44

5. Business Continuity Features and Enhancements.html

3. Security Features and Enhancements

1. Section Overview.mp4

01:24

2.1 SQL-Server-2022-T-SQL-Create-Ledger-Tables.pdf

2.2 SQL-Server-2022-T-SQL-Ledger-Tables-Insert-Sample-Data.pdf

2.3 SQL-Server-2022-T-SQL-Ledger-Tables-Retrieve-Ledger-Details.pdf

2. SQL Server Ledger - Blockchain Ledger Tables.mp4

06:41

3. Demo SQL Server Ledger.mp4

16:23

4. Other Security Enhancements.mp4

05:28

5.1 SQL-Server-2022-Recap-Security-Features.pdf

5. Section Recap.mp4

01:47

6. Security Features and Enhancements.html

4. Performance Features and Enhancements

1. Section Overview.mp4

01:24

2. Query Store Enhancements.mp4

04:49

3.1 SQL-Server-2022-T-SQL-Query-Store-Demo.pdf

3. Demo Query Store.mp4

05:26

4. Built-in Intelligent Query Processing Enhancements.mp4

08:09

5.1 SQL-Server-2022-T-SQL-Parameter-Sensitive-Plan-Optimization-Demo.pdf

5. Demo Parameter Sensitive Plan Optimization.mp4

10:44

6. Other Performance Improvements.mp4

06:52

7.1 SQL-Server-2022-Recap-Performance-Features.pdf

7. Section Recap.mp4

01:20

8. Performance Features and Enhancements.html

5. Other Features and Enhancements

1. Section Overview.mp4

00:39

2. Azure Synapse Link.mp4

04:34

3. Management Features & Enhancements.mp4

03:53

4. T-SQL Enhancements.mp4

12:48

5.1 SQL-Server-2022-T-SQL-Language-Enhancements-Auto_Drop_Option.pdf

5.2 SQL-Server-2022-T-SQL-Language-Enhancements-Built-In-Function-Examples.pdf

5.3 SQL-Server-2022-T-SQL-Language-Enhancements-Is-Distinct-From-Example.pdf

5. Demo T-SQL Enhancements.mp4

11:17

6.1 SQL-Server-2022-Recap-Other-Features.pdf

6. Section Recap.mp4

01:22

7. Other Features and Enhancements.html

6. Putting it All Together

1.1 SQL-Server-2022-Course-Recap.pdf

1. What youve Learned in this Course.mp4

03:22

2. SQL Server 2022 Whats New - New and Enhanced Features.html

7. Learning More

1.1 Bonus_Lecture_Links.pdf

1. Bonus Lecture.mp4

07:00

Description

Learn what's new and enhanced in SQL Server 2022 such as bidirectional HA/DR to Azure SQL Managed Instance and more

What You'll Learn?

How to download and install SQL Server 2022 on Windows
What are the major new enhancements and features in SQL Server 2022 and SSMS 19
How to use many of the new features and enhancements in SQL Server 2022 via live demos and guides
What are the new business continuity features and enhancements
What are the new security features and enhancements
What are the new performance features and enhancements
Other enhancements in SQL Server 2022 such as T-SQL enhancements, Azure Synapse Link and more

Who is this for?

Professionals who work with previous versions of SQL Server and want to know what's new in SQL Server 2022.

Professionals who have basic SQL Server knowledge and want to learn more about the latest version of SQL Server.

Technology enthusiasts that explore new technologies and want to learn what’s new in this version of SQL Server.

More details

Description
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.

MORE ABOUT THE COURSE:
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, in order to get a clear picture about all the new features and enhancements in this version of SQLÂ Server, that is SQLÂ Server 2022.

We will begin the course by discussing about, 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 about the new features and enhancements, by first discussing about 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 about the security features and enhancements. To this end, among other, we will be talking about SQLÂ Server ledger tables and see a relevant live demonstration.

In the next section, we will be discussing about the Performance Features and Enhancements in SQL Server 2022, and more precisely, about the Query Store enhancements and Built-in Intelligent Query Processing enhancements and see some interesting live demonstrations on Query Store and Parameter Sensitive Plan Optimization.

Last but not least, we will be discussing about other features and enhancements, such as: Azure Synapse Link, Management Features & Enhancements and T-SQL Enhancements.

AFTER THE COURSE:
After completing the course, you will know:
How SQL Server evolved over the years and why this release, makes SQL Server a hybrid data platform
How to install and use SQLÂ Server 2022 on Windows along with following the best practices
What are the new Business Continuity Features and Enhancements in SQLÂ Server 2022
What are the new Security Features and Enhancements in SQLÂ Server 2022
What are the new Performance Features and Enhancements in SQLÂ Server 2022
Other significant new features and enhancements in SQLÂ Server 2022, such as main T-SQLÂ enhancements, Azure Synapse Link, Management Features & Enhancements, etc.
How you can start using many of these new features and enhancements

PREREQUISITES:
Basic SQL Server knowledge in prior versions of SQL Server
Basic database principles

THIS COURSE OFFERS:
2.5 hours of high-quality video lectures with live demonstrations and guides
Useful quizzes for testing your knowledge on each section
Useful downloadable resources
A practice test in the end of the course
Ability to ask the instructor questions related to the course via the Q&AÂ section
Certificate on course completion
Who this course is for:
Professionals who work with previous versions of SQL Server and want to know what's new in SQL Server 2022.
Professionals who have basic SQL Server knowledge and want to learn more about the latest version of SQL Server.
Technology enthusiasts that explore new technologies and want to learn whatâ€™s new in this version of SQL Server.

User Reviews

Rating

average 0

Total votes0

Focused display

SQL Server

Artemakis Artemiou

Instructor's Courses

Artemakis is a Senior Database and Software Architect and a former Microsoft Data Platform MVP (awarded for 9 consecutive years). He has over 20 years of experience and he has taught thousands of people to efficiently work with SQL Server, Data Access/Entity Framework, Azure, .NET/C#, Programming and more, via his video tutorials, blog and guest articles, public speaking, eBooks and online courses.Artemakis is the founder of the SQLNetHub and {essentialDevTips} communities and published hundreds of articles and videos that explain in simple words, how to perform complex technical tasks and he really enjoys the interaction with the technical communities.Besides his regular blogging activities, Artemakis is also a guest author on many prestigious online technology journals.Moreover, he currently serves as the President of the Cyprus .NET User Group (CDNUG) and the International .NET Association Country Leader for Cyprus (INETA).Artemakis, really enjoys sharing hands-on knowledge on a large set of technology topics, and thus helping his fellow tech community members, to easily start using these great technologies. To this end, he is really looking forward to seeing you in his online courses on Udemy!

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.