Sign in to confirm you’re not a bot
This helps protect our community. Learn more

How SQL is getting smarter – Intelligent Query Processing 2017 to Today | Data Exposed

Microsoft Developer
588K subscribers
<__slot-el>
<__slot-el>
1.8K views 1 year ago #SQLServer #AzureSQL
Did you know that SQL has built in query intelligence on par with other “autonomous” systems? Did you know that SQL can adjust and adapt to your workload over time to give you the best available performance without any user action? SQL has been investing in this space for the past 3 major versions – today, we walk through those investments to explain the impact of these investments in our query processing components. 00:22 - Introductions 01:06 - What is Intelligent Processing 02:06 - SQL Server or Azure Feature? 02:40 - Overview of IQP "Family Tree" Timeline 13:45 - How should we think about these improvements 14:50 - It just runs faster 15:05 - Closing ✔️ Resources: https://learn.microsoft.com/en-us/sql... 📌 Let's connect: Twitter: Anna Hoffman,   / analyticanna​​​   Twitter: AzureSQL, https://aka.ms/azuresqltw​​​ 🔔 Subscribe to our channels for even more SQL tips: Microsoft Azure SQL: https://aka.ms/msazuresqlyt Microsoft SQL Server: https://aka.ms/mssqlserveryt Microsoft Developer: https://aka.ms/microsoftdeveloperyt #AzureSQL #SQLServer ...more
...more
How SQL is getting smarter – Intelligent Query Processing 2017 to Today | Data Exposed
28Likes
1,824Views
2023Aug 3
Did you know that SQL has built in query intelligence on par with other “autonomous” systems? Did you know that SQL can adjust and adapt to your workload over time to give you the best available performance without any user action? SQL has been investing in this space for the past 3 major versions – today, we walk through those investments to explain the impact of these investments in our query processing components. 00:22 - Introductions 01:06 - What is Intelligent Processing 02:06 - SQL Server or Azure Feature? 02:40 - Overview of IQP "Family Tree" Timeline 13:45 - How should we think about these improvements 14:50 - It just runs faster 15:05 - Closing ✔️ Resources: https://learn.microsoft.com/en-us/sql... 📌 Let's connect: Twitter: Anna Hoffman,   / analyticanna​​​   Twitter: AzureSQL, https://aka.ms/azuresqltw​​​ 🔔 Subscribe to our channels for even more SQL tips: Microsoft Azure SQL: https://aka.ms/msazuresqlyt Microsoft SQL Server: https://aka.ms/mssqlserveryt Microsoft Developer: https://aka.ms/microsoftdeveloperyt #AzureSQL #SQLServer

Follow along using the transcript.

Microsoft Developer

588K subscribers