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

Explore the latest advancements in SQL Server 2022! This comprehensive course dives deep into the new features and enhancements, transforming SQL Server into a powerful hybrid data platform.

What you'll learn:

• SQL Server 2022 Evolution: Understand how SQL Server has evolved into a hybrid data platform, with a detailed look at Azure integration features introduced in each release leading up to 2022.
• Business Continuity: Master new high availability (HA) and disaster recovery (DR) capabilities, including bidirectional HA/DR to Azure SQL Managed Instance and Contained Availability Groups.
• Security Enhancements: Discover the latest security features in SQL Server 2022, including SQL Server Ledger/Blockchain Ledger Tables with a live demonstration.
• Performance Optimization: Learn about Query Store enhancements and Built-in Intelligent Query Processing (IQP), specifically Parameter Sensitive Plan Optimization, with practical live demonstrations.
• Azure Synapse Link: Explore the capabilities of Azure Synapse Link for seamless data integration.
• T-SQL Enhancements: Get up-to-speed on the newest T-SQL enhancements for improved development and data manipulation.
• Management Features: Discover new management features designed to simplify administration.

More About SQL Server 2022:

SQL Server 2022 is the most Azure-enabled release yet, offering significant integration with the Azure ecosystem alongside enhancements to the on-premises Database Engine. This course provides a clear understanding of all the new features and enhancements in SQL Server 2022.

After completing this course, you will be able to:

• Understand the evolution of SQL Server and its role as a hybrid data platform.
• Install and use SQL Server 2022 on Windows, following best practices.
• Implement new Business Continuity Features and Enhancements.
• Apply new Security Features and Enhancements.
• Leverage new Performance Features and Enhancements, including Query Store and Parameter Sensitive Plan Optimization.
• Utilize other significant new features like Azure Synapse Link, Management Features, and T-SQL Enhancements.
• Begin utilizing these new features in your own projects.

Prerequisites:

• Basic SQL Server knowledge from prior versions.
• Fundamental database principles.

Course Includes:

• 3+ hours of high-quality video lectures with live demonstrations.
• Helpful quizzes to assess your knowledge.
• Downloadable resources.
• A practice test to prepare for certification.
• Q&A section for instructor interaction.
• Certificate of completion.