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.
Overview
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
Related Courses
-
Monitor and optimize operational resources in Azure SQL
-
Modernizing Applications with SQL Server 2022 and Azure SQL Innovations
-
SQL Server 2022 - The Hybrid Data Platform
-
Transform Your Business with New Innovations from Edge to Cloud Across SQL Server
-
Intelligent Query Processing in SQL Server 2019 - Modernizing Your Data Platform
-
SQL Server 2022 Storage Engine Capabilities
