May 12th – Query Store Feature for SQL Server both On-Prem and in the Cloud – presented by Deepthi Goguri

Welcome to this month’s meeting!  As a member of Oregon Data Community you are also a member of the PNW Data Community!  All of the local data groups are working together, with each of us taking turns hosting the monthly meeting(s)!!!  Yes, meetings!  We will always have our “evening” meeting on the 2nd Wednesday of the month at 4 PM PST, and a second meeting on the 4th Wednesday of the month at 12 PM PST!!

We are now using Teams!   Link will be published closer to the meeting

In order to encourage questions during the presentation, we want people to use the raise hands option in Teams and not talk over each other. Please be mindful of the other attendees!

We will be starting at 4:00 PM PST/7:00 PM EST

Schedule (may be fluid):
4:00 – 4:15 PM – Announcements and other information
4:15 PM – 1st Presentation

Our wonderful sponsors are providing gifts each month!

Title: Query Store feature for SQL Server on-premises and cloud!

Abstract: 

Are you facing performance issues due to the parameter sensitive queries? Are many plans being generated for your queries and you cannot control choosing the plan best for your query? Come learn in this session how we can capture the different plans generated for those queries and decide which plan you can force for better performance using the Query Store feature. Query Store feature introduced in SQL Server 2016 and has advanced its features introducing Wait stats per Query plan and Automatic Plan correction feature in SQL Server 2017 and Azure SQL database which will force the plans and resolve the issues automatically for you. Sounds amazing, right? Join Deepthi to know all about the Query Store feature and its advancements in detail so you can implement them to take advantage of this Awesome feature!

Biodata:

Deepthi is a SQL Server Database Administrator with several years of experience in Administering SQL Servers. She is a 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.

 

Here’s Deepthi!

Posted in Announcements | Leave a comment