Explore new capabilities in security, scalability, and availability in SQL Server 2022

  • Module
  • 7 Units
Beginner
Developer
Data Engineer
Data Scientist
Data Analyst
Database Administrator
SQL Server

Learn about the new capabilities in security, scalability, and availability in SQL Server 2022.

Learning objectives

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.

Prerequisites

  • SQL Server 2022 installed.
  • Basic working knowledge of SQL Server security, performance, and availability features.
  • Fundamental knowledge of the Transact-SQL (T-SQL) language.