Introducing SQL Server 2022
Offered By: PASS Data Community Summit via YouTube
Course Description
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
Related Courses
Using Non-Relational Data in SQL ServerMicrosoft via edX Data Analysis: Essential Skills
Microsoft via edX Intermediate SQL Server
DataCamp Building and Optimizing Triggers in SQL Server
DataCamp SQL Server: Understanding, Configuring and Troubleshooting Database Mirroring
Pluralsight