Join Rob and Ben for a fun filled hour from the community for the community as they invite a concatenation of community experts on stage and let them show us what their favorite data platform feature is and why!
The video is not available to view online.
Understand the automatic performance changes in Azure SQL and SQL Server
Azure SQL performance capabilities, how to configure and maintain your Azure SQL for higher performance. We will explore various monitoring tools and pick few scenarios for deeper troubleshooting. In this demo centric session, we will tune our database and find an optimal ground to manage cost. We will generate Power BI powered database score card for trend analysis.
Two consultants, two different companies, two data professionals passionate about performance tuning. Do we like the same things? Do we have the same approach to problems? Topics will include: Trace Flags, DMVs, DBCC commands, Community Scripts and Intelligent Query Processing Features. We will talk about the features and solutions we agree on, and discuss where we disagree.
Only the curious will learn and only the resolute overcome the obstacles to learning.
Delicious Demos For Doubting Developers
Let us walk you through our steps to triage and troubleshoot issues as they come in to make sure things get fixed in the right order at the right time and we all stay sane.
I can spend an entire day talking about Query Store and all it can do, but in 20 minutes I can convince you that it should be a feature you start using today.
DBA and Data scientists should work together! Analyzing data gathered with XE and Query Store data using R or Python for better database insight and discovering hidden patterns.
The video is not available to view online.
This session will discuss how to look at your workload holistically using a variety of methods, so that you can target and address patterns in your code and query plans, rather than troubleshooting one query at a time.
If you have heard about Query Store but don't know what it can offer, or why you really need it, this session will answer those questions and demonstrate the value of this feature that continues to evolve.
<<1>>