Performance in Azure by Deepthi Goguri | Query Store by Brandon Tuck

Session #1 - Improve the performance in Azure using these features by Deepthi Goguri
Abstract
Once you deploy your database in Azure, you need to make sure you are always increasing the tiers and paying more for the performance of your database. Just like you tune your databases on-prem, you need to focus on optimizing your database for performance. But how do we achieve this in Azure?

Let's dedicate this session to mainly focus on the ways that you can optimize and tune your Azure data solutions so you can save money being on Azure and get fast response times for your queries.

Speaker Bio
Deepthi is a SQL Server Database Administrator with several years of experience in Administering SQL Servers. She is a Microsoft Data Platform MVP, Microsoft certified trainer and Microsoft certified professional with an Associate and Expert level Certification on Data Management and Analytics. Deepthi blogs for DBANuggets.com. Deepthi is an Co-Organizer for Microsoft Data and AI South Florida user group and Data Platform Diversity, Equity, and Inclusion Virtual Group. She is a Volunteer for Data platform Women in Technology user group. She is a Friend of Redgate. Along with this, Deepthi loves arts and crafts. You can contact her on Twitter @dbanuggets.

Session #2 - A Beginner's Guide to Query Store by Brandon Tucker
Abstract
Like many others, you installed SQL Server 2022, created a new database, and suddenly saw this new “Query Store” node. Where did that come from and what do I do with it?! Fret not, Microsoft wouldn’t put it in there if it wasn’t helpful for us? Right? Right! Even though Query Store was introduced in SQL Server 2016, SQL Server 2022 took it a step further for it to be enabled for new databases. Because of this, every DBA and DB developer will want to have a cursory knowledge of what it is and what value it can provide. In this talk, we’ll teach you how to work with Query Store and begin to leverage the treasure trove of information that it contains. We’ll start by introducing the high-level concepts of Query Store and how it works in your SQL Server 2022 databases. Once we set the foundation, a straightforward UI demo will walk through how Query Store can be configured and optimized. Lastly, we’ll explore the variety of reports and queries available to us to dive into the high-value data that’s being collected. Come join us to level up on your SQL Server 2022 knowledge by understanding how Query Store can help understand your environment better!
Speaker Bio
Brandon Tucker is a data geek and has engaged SQL Server as an architect, developer, data engineer, and administrator over the last 18 years. He loves solving complex, real-world data problems, applying them in business situations, then sharing the knowledge to benefit the community. Brandon has served on the board for the Denver SQL Server User Group and presented at PASS Summit, SQL Saturdays, User Groups, and Code Camps. When not wrangling data, Brandon can be found cycling/backpacking/skiing in his home state of Colorado, cheering on the Avalanche, or talking world travel over drinks.