Erin Stellato is a Senior Program Manager on the SQL Experiences team, helping advance tools that customers use daily with Azure SQL. She is passionate about data and chocolate, not always in that order. She previously worked as a consultant and was a Data Platform MVP, and has been an active member of the SQL Server community as both a volunteer and speaker. Her areas of interest within the engine include Query Store, Extended Events, statistics, and performance tuning; and she also enjoys helping accidental/involuntary DBAs figure out how SQL Server works.

Sessions

Extended Events was released with SQL Server 2008, and almost 10 years later, many data professionals are still clinging to Profiler. It's time to move forward, and in this session I'll show you how.
Automatic Plan Correction is a feature you can use whether you're a pro at performance tuning or just starting with SQL Server. Come to this session to learn how to spend less time fighting fires with this new feature.
If you've been using Extended Events the same way you used to use Trace, you might be wondering if there's more to it. There is! In this session we will explore what else you can do with XE besides capture long-running queries.
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.
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.
I often recommend that folks proactively manage statistics, but I always seem to run out of time to talk about HOW to do that...this session will cover exactly that.
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.
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.
Join Alan Yu and Erin Stellato to talk about all the tools you use to connect like SSMS, SSDT, Azure Data Studio, Visual Studio Code, and our CLI tools.
Erin_Stellato270638.jpg