Channel: Microsoft Mechanics

Category: Science & Technology

Tags: windows server 2022azure synapse linked serverazure sqlazure synapseazure synapse link sql serverazure sql database managed instancesql server tutorialmicrosoftmicrosoft sql server tutorialazure sql managed instancesql serversqlazure sql databaseclouddatabasesql basicsazure synapse link for dataverseazure sql managed instance vs azure sqlbig datamicrosoft sql serverazuresql databaseazure synapse link

Description: A first look at SQL Server 2022—the latest Azure-enabled database and data integration innovations. See what it means for your hybrid workloads, including first-time bi-directional high availability and disaster recovery between Azure SQL Managed Instance and SQL Server, Azure Synapse Link integration with SQL for ETL free near real-time reporting and analytics over your operational data, and new next-generation built-in query intelligence with parameter sensitive plan optimization. Bob Ward, SQL engineering leader, joins Jeremy Chapman to share the focus on this round of updates. ► QUICK LINKS: 00:00 - Introduction 00:38 - Overview of updates 02:19 - Disaster recovery 04:26 - Failover and restore example 06:16 - Azure Synapse integration 09:04 - Built-in query intelligence 10:19 - See it in action 12:52 - Wrap up ► Link References: Learn more about SQL Server 2022 at aka.ms/SQLServer2022 Apply to join our private preview, and try it out at aka.ms/EAPSignUp ► Unfamiliar with Microsoft Mechanics? We are Microsoft’s official video series for IT. You can watch and share valuable content and demos of current and upcoming tech from the people who build it at Microsoft. Subscribe to our YouTube: youtube.com/c/MicrosoftMechanicsSeries?sub_confirmation=1 Join us on the Microsoft Tech Community: techcommunity.microsoft.com/t5/microsoft-mechanics-blog/bg-p/MicrosoftMechanicsBlog Watch or listen via podcast here: microsoftmechanics.libsyn.com/website ► Keep getting this insider knowledge, join us on social: Follow us on Twitter: twitter.com/MSFTMechanics Follow us on LinkedIn: linkedin.com/company/microsoft-mechanics #MSIgnite #SQLServer #Azure