October CASSUG Monthly Meeting

Our October speaker is Tracy Boggiano! She will present her topic titled "Intro to Query Store."

In this session, we will look at the new Query Store feature in SQL Server 2016, 2017, and 2019. 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 Plan Correction 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.

About Tracy:
Tracy Boggiano is a Senior Database Administrator for FM:Systems. She has spent over 20 years in IT, using SQL Server since 1999, and is currently certified as a MCSE Data Platform. She has worked on SQL Server since 6.5. She has spoken at local user groups and numerous SQLSaturdays. She is currently a co-leader of a TriPASS Local Group in Raleigh, NC.

Tracy also tinkered with databases in middle school to keep her sports card collection organized. She blogs at databasesuperhero.com.

Her passion outside of SQL Server is volunteering with foster children as their advocate in court through volunteerforgal.org and being a mental health advocate as part of the PAIMI NC Advisory Council.

Our meeting schedule is usually as follows:
5:30 PM Food, soft drinks, and networking
6:15 PM Chapter news and announcements
6:20 PM Presentation (topic changes monthly)
We usually wrap up between 7:30 PM and 8:00 PM.