Sessions & Content

Search
Content Type
Conference
Tags
Query Store Best Practices Erin Stellato
Want to use Query Store and not sure how to make sure everything is "correct"? Tried Query Store and had issues? In this session we'll cover what you MUST know to successfully use Query Store in a production environment.
The video is not available to view online.
Keynote by the Community Ben Weissman (he/him)
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.
Automagic Tuning in SQL Server Joey D'Antoni
Understand the automatic performance changes in Azure SQL and SQL Server
Different dimensions of monitoring and tuning performance for Azure SQL Surbhi Pokharna
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.
Erin & Monica’s Favorite SQL Stuff Monica Rathbun
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.
From Housekeeping to Data Engineer - My journey to find my passion Jean Joseph
Only the curious will learn and only the resolute overcome the obstacles to learning.
The SQL Server Performance Tasting Menu Erik Darling
Delicious Demos For Doubting Developers
Troubleshoot and Triage Like a Pro Matt Gordon
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.
Why You Need Query Store Erin Stellato
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.
Analyzing database with XE and Query Store data using R / Py Tomaž Kaštrun
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.
Stop Tuning Queries and Start Tuning Your Workload Erin Stellato
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.
Why You Need Query Store Erin Stellato
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>>