Skip to content

Query Store – What is it all about?

Photo of Jack Corbett
Hosted By
Jack C. and Mike W.
Query Store – What is it all about?

Details

Agenda:
6:00-6:30 - Networking and Appetizers - you can buy your own drinks and dinner from the bar if you like or just enjoy water and appetizers provided by our sponsor.
6:30-6:45 - Greetings and Announcements
6:45-8:00 - Feature presentation
8:00-9:00 - Questions and discussions

We are an informal group so the times may vary a bit from the schedule and please feel free to arrive anytime from 6:00 on and leave when you need to leave.

Here is this month's featured presentation:

Query Store – What is it all about?

SQL 2016 brings us many new features but one of the most anticipated is surely the Query Store. The Query Store now allows us to track query plans as they change over time giving us a whole slew of new possibilities when it comes to tuning our queries. Even just the ability to compare a previous plan to a new plan is a huge step towards understanding what may be happening in our instance. We can even tell the optimizer which plan we want it to use. These were all either extremely difficult to do before and in some cases impossible to do. This session will explain the fundamentals of what it is all about and give you the insight to get started using this new and wonderful feature set.

About Andrew J. Kelly

Andrew J. Kelly is a Sr. Technology Subject Matter Specialist with B3 Group Inc. who lives in Waynesboro, Va. He has over 20 years’ experience with relational databases and application development but his main focus now is SQL Server. In addition to general SQL Server training and Mentoring he specializes in Performance, Scalability and Maintainability of large scale SQL Servers. He is a regular speaker each year at many conferences and user groups. He is a contributing editor and writer for SQL Server Pro and has been a Microsoft Data Platform MVP since 2001.

Photo of SeacoastSQL User Group group
SeacoastSQL User Group
See more events
Roundabout Diner
580 US Highway 1 Byp · Portsmouth, nh