March 2018 - Query Story Primer by Tracy Boggiano (@TracyBoggiano)

Abstract:
This session will take a look at the new Query Store feature in SQL Server 2016. 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. We will take a hands-on look at how to use Query Store to troubleshoot problems as well as some of the new DMVs you can use to find issues as they arise. And see what is new in SQL Server 2017.

About Tracy:
Tracy Boggiano is the Database Superhero for ChannelAdvisor. She has spent over 20 years in IT and has used SQL Server since 1999. Tracy covers all aspects of administration and deals heavily with performance tuning and high availability and disaster recovery. Tracy has volunteered through the NC Guardian ad Litem program since 2003 advocating for abused and neglected foster children in court.