Explore SQL Server 2022 capabilities

In this module, you'll be able to:

• Describe the innovations introduced in SQL Server 2022
• Determine whether SQL Server 2022 can help modernize your data estate, while reducing the cost of ownership, and accelerate the performance of your applications
• Leverage new security capabilities in SQL Server 2022 to protect your data and use cryptographic attestations that your data hasn't been tampered with
• Connect your data to Azure and data lakes

In this module, you'll be able to:

• Discover best practices for disaster recovery using Azure SQL Managed Instance
• Describe how Azure Arc-enabled SQL Server works
• Understand how to implement near real time analytics with Azure Synapse Link for SQL Server
• Explain cloud connected technologies that support security with Azure Active Directory authentication
• Explore Microsoft Purview access policies for SQL Server
• Describe the services that support SQL Server data files in a hybrid platform

At the end of this module, you'll be able to:

• Understand the key functionality behind Intelligent Query Processing and when to implement the feature
• Understand Automatic performance healing with memory grant feedback persistence
• Know how to get consistent performance with Parameter Sensitive Plan optimization
• Gain parallel efficiency with DOP Feedback

By the end of this module, you'll be able to:

• Describe what ledger for SQL Server is, and use ledger tables to enhance your auditing capabilities.
• Be familiar with the security feature enhancements, like the added granular fixed server roles, Always Encrypted enhancements, strict connection encryption, and granular UNMASK permissions for dynamic data masking.
• Understand the enhancements to memory management, tempdb, and how SQL Server 2022 can help you scale large-memory environments with no code or application changes.
• Describe the new capabilities around SQL Server 2022 availability, including contained availability groups, cross-platform snapshot backups, and Intel® QuickAssist Technology backup compression.

By the end of this module, you'll be able to:

• Understand the benefits and principles of data virtualization
• Know what PolyBase is, and how you can leverage its capabilities
• Be familiar with object storage solutions
• Install and configure PolyBase on SQL Server 2022
• Access external data on SQL Server 2022 using PolyBase

In this module, you'll be able to:

• Understand the new and enhanced T-SQL features in SQL Server 2022.
• Utilize new functions and capabilities to optimize database performance and maintainability.
• Adapt to the evolving needs of modern database administrators and developers.

• Introduction
• Deployment options, licensing, and feature differences in SQL Server 2022
• Build a hybrid data platform with SQL Server 2022
• Gain performance insights when you need it and accelerate performance with no code changes
• Power your application with an industry proven database engine with security, scalability, and availability
• Use SQL Server 2022 as a data hub querying files and backup/restore to object storage providers
• Learn how developers can use new T-SQL language enhancements
• Summary

• Introduction
• Ensure Business Continuity with Azure SQL Managed Instance
• Simplify management with Azure Arc-enabled SQL Server
• Near real-time analytics with Azure Synapse Link for SQL
• Secure with Microsoft Entra authentication
• Microsoft Purview access policies for SQL Server
• Knowledge check
• Summary

• Introduction
• Memory grant feedback
• Exercise - Memory grant feedback persistence in SQL Server 2022
• Parameter Sensitive Plan optimization
• Exercise - Parameter Sensitive Plan
• Degree of Parallelism (DOP) feedback
• Exercise - Degree of Parallelism feedback
• Summary

• Introduction
• Ledger in SQL Server 2022
• Exercise - Ledger
• Learn about the security enhancements in SQL Server 2022
• Enhancements in SQL Server 2022 to help scalability
• Availability enhancements in SQL Server 2022
• Summary

• Introduction
• Introduction to PolyBase
• Understand credentials and data sources with PolyBase
• Exercise - Query Parquet file
• Exercise - Use data virtualization to connect to Azure SQL Database
• CREATE EXTERNAL TABLE as SELECT (CETAS)
• Exercise - CREATE EXTERNAL TABLE as SELECT
• Summary

• Introduction
• Create index and resumable constraint enhancements
• Named window definition with the SELECT WINDOW clause
• Enhance expression comparisons with IS [NOT] DISTINCT FROM
• Time and series functions enhancements
• String and other functions enhancements
• New and improved JSON functions
• New aggregation functions
• New bit manipulation functions
• Summary