Sql server versions comparison1/16/2024 ![]() 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?
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |