Now, not only is it easier to configure, but because this is a managed service, you no longer have to manage and maintain your DR infrastructure. And since we’re linked to Azure SQL Managed Instance, we can also view it in the Azure portal. Next, you can see an availability group and distributed availability group that was deployed and configured for me automatically. And by the way, if you’re setting this up for the first time, it will ask you to log into your Azure subscription and choose your target managed instance, and it will seed your database into the managed instance. All I had to do was right click the server, go to Azure SQL Managed Instance link and attach my database to the cloud. In this case, I’ve already attached our Azure SQL Managed Instance to our SQL Server. And you can see five subscribers that have opted in.

We’ve run a query to look for people that have opted into email comms. I’ve connected to my SQL Server, and you can see the Wide World Importers database. I’m in SQL Server Management Studio, or SSMS. In fact, we’ll look at our demo company example, Wide World Importers, who want to implement disaster recovery in an easy way, especially for the email marketing campaign. So now it’s super easy to set up disaster recovery as a managed service with Azure SQL Managed Instance configured for you as your disaster recovery site. It’s hard to set up everything and really get it all configured and running, though, right? Today they have to spin up an Azure virtual machine or another SQL on-premises server to failover to. So starting with disaster recovery, I know this has been traditionally a pain point for people. So I’m really going to focus on my three favorites: disaster recovery, Azure Synapse integration, and built-in query intelligence. And as you saw, there’s a lot we can dig into with SQL Server 2022. So let’s unpack these capabilities a bit more and also see them in action. And these really seem like great updates, especially for hybrid data workloads. And one of my favorites, we’re also bringing performance to the next level with built-in query intelligence, like parameter sensitive plan optimization that caches more than one plan for a stored procedure for consistent query performance. Then for auditing scenarios, we’re introducing SQL Server Ledger, bringing the power of blockchain technology to verify changes by other parties, so that you can retain an immutable record of the data. Additionally, you can now get visibility over your SQL Server data in the context of your entire data state with Azure Purview integration. That pain now goes away with Azure Synapse link integration for near real-time analytics and reporting. In the past, you’d have to ETL your operational data on a schedule to bring it into your analytics system in order to run analytics. We’re also removing silos between your operational and analytic workloads. And this release really moves a ton of pain points in areas like disaster recovery, where for the first time you can do failover from SQL Server 2022 to Azure SQL Managed Instance in the regions you need. As you know, most of the new innovations start in the cloud before coming to SQL Server. So with every release we’re optimizing the core SQL engine to give you a consistent database experience from the cloud to on-premises, and even the Edge. What’s been the focus on this round of updates? So first, congrats to you and the team and big news today with the announcement of SQL Server 2022. I love being on the show, thanks for having me. So Bob, it’s great to have you back on the show. Up next, we’re joined by SQL engineering leader Bob Ward, to tour the latest Azure-enabled database and data integration innovations with a first look at SQL Server 2022 and 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.

Keep getting this insider knowledge, join us on social:

Join us on the Microsoft Tech Community:.You can watch and share valuable content and demos of current and upcoming tech from the people who build it at Microsoft. We are Microsoft’s official video series for IT. Apply to join our private preview, and try it out at Unfamiliar with Microsoft Mechanics?

Latest sql server versions