- This event has passed.
IDPA-Des Moines March Meeting – Intro to Query Store
March 8, 2021 @ 5:30 pm - 7:30 pm CST
*** Due to COVID-19, until further notice, IDPA-Des Moines will hold only Virtual Meetings. No in-person attendance. ***
The virtual meeting link will be active at 5:30PM CST to allow for fellowship and announcements prior to 6PM CST when we introduce our speaker.
Topic: Intro to Query Store
Description: In this session, we will look at the new Query Store feature in SQL Server 2016 and 2017. Query Store tracks changes in execution plans, allowing you to easily view performance differences and revert to older plans with a few clicks of the mouse in 2016.
Then in 2017, Microsoft added wait stats per query plan and Automatic Tuning capabilities. Allowing DBAs more tools to troubleshoot fires with and a way to automatically resolve issues.
In this session, we will walk through the features of Query Store, so you can understand how to use them in SQL Server 2016, 2017, and 2019.
Speaker: Tracy Boggiano is currently a Data Platform MVP, PASSion 2020 Award winner, and works as a Senior Database Administrator for DocuSign. Tracy has worked on SQL Server since 6.5. She has spoken at numerous local user groups and SQLSaturdays, virtual groups, Data Relay, and Summit. She is currently a co-leader of the Triangle SQL Server User Group in Raleigh, NC. Tracy tinkered with databases in middle school to keep her sports card collection organized and got an early start on databases. (https://tracyboggiano.com/about-me/)