Overview
Explore the latest features and capabilities of SQL Server 2022 in this comprehensive conference talk by Bob Ward at the PASS Data Community Summit. Discover how to leverage Azure for disaster recovery, near real-time analytics, and enhanced security. Learn about innovations in the database engine, including SQL Server Ledger, and improvements to Query Store and Intelligent Query Processing that boost performance without code changes. Dive into new T-SQL language extensions for data virtualization object storage, JSON functions, and time-series analysis. Watch live demonstrations and gain insights from SQL Server engineering experts during the Q&A session. Get up to speed on connecting SQL Server with cloud services, implementing intelligent query processing, and utilizing new T-SQL features to enhance your database management skills.
Syllabus
Introduction
Introducing SQL Server 2022
Where weve been
When and How
Overview
Cloud Connectivity
Link for Synapse
Azure Active Directory
The Challenge
Intelligent Query Processing
Next Gen
Demo
Meat and Potatoes
SQL Server Ledger
Azure Data Studio
TSQL
Taught by
PASS Data Community Summit