Welcome to Edmonton PASS!


Thursday June 15, 2017 EDMPASS - 

Answering the Question, "What Happened?" with Query Store with Erin Stellato  

Language: English

Event Type: In-Person

Online Meeting URL: None



5:00 pm Doors open

5:30 pm Feature Presentation & Pizza

One of the most highly anticipated new features in the SQL Server 2016 release is Query Store.  It's been referred to as the "flight recorder" for SQL Server because it tracks query information, namely plans and runtime statistics.  If you've ever had to drop everything to troubleshoot a sudden drop in performance, then you've probably already realized the value of this feature.  In this session we'll walk through Query Store with a series of demos designed to help you understand how you can immediately start to use it once you’ve upgraded to SQL Server 2016.  We'll review the different options for Query Store, look at examples of what gets collected, dig through the included reports, see how you can force SQL Server to use a specific plan for a query, and find out what happens when it can’t use the specified plan.  Get ready to make troubleshooting easier with this feature that’s included in all editions of SQL Server 2016!.

Erin is a Principal Consultant at SQLSkills

Erin Stellato is a SQL Server MVP and lives in Cleveland, OH. She has over 15 years of technology experience and has worked with SQL Server since 2003. Her areas of interest include statistics, performance tuning, Extended Events, and helping accidental/involuntary DBAs figure out how SQL Server works.  Erin is an active member of the SQL Server community, has volunteered for PASS at the local and national level, and is a regular speaker at conferences like SQLintersection and the PASS Summit.  Outside of time with family and friends, she enjoys running, spinning, movies, and all things chocolate.


Full Bio: http://www.sqlskills.com/about/erin-stellato/
SQL Server
 MVP since 2012

NOTE: Due to renovations to the downstairs convention centre it will be held on the 11th floor


10303 Jasper Avenue
Canadian Western Bank Place - Canadian Room 
Edmonton, Alberta
Direction: None