Anouncements
PASS Summit 2016 - Discount Code Is Here & Ready to be used by all. Share Away!

Discount Code: LC15TDF8

Registration Info:

The PASS Summit 2016 registration is live and prices will increase soon, so we encourage you to share this code ASAP with anyone interested in attending PASS Summit 2016 to double down and get the best possible rate plus the discount code. The code can, and we hope, is used over and over. Pass along to your friends, co-workers, folks on the street, and tweet it continually using the #Summit16 hashtag. -  http://www.sqlpass.org/summit/2016/RegisterNow.aspx

 Feature Presentation

Tuesday, June 21st, 2016

Taking advantage of Query Store in SQL Server 2016

Joe McTaggart - Microsoft

Abstract:
One of the toughest performance problems to troubleshoot and diagnose in SQL Server is plan instability. One minute your server is running great, and the next minute user applications can be timing out. To diagnose this issue generally requires multiple rounds of data gathering, research into the underlying data, and potentially days to get to root cause. With the new Query Store feature in SQL Server 2016, this issue can potentially be identified and resolved in minutes. Query Store simplifies performance troubleshooting and makes forcing plans stability as simple as a couple clicks. In this session we will start with some basics on how to read query plans then look specifically at some scenarios with Query Store to highlight how it can be used to make your life as a DBA much easier. 


About Joe:
Joe McTaggart is a Premier Field Engineer with Microsoft and has been working with SQL Server since 2001. At Microsoft, Joe primarily works with customers helping to architect, review, and troubleshoot solutions using SQL Server. This work has covered the breadth of the SQL product including SSRS, SSIS, SSAS, PowerPivot, and Azure. Aside from direct customer work, he has helped write or develop many of the Microsoft Premier workshops for SQL Server since SQL Server 2012.


Agenda:
5:30 - Professional Networking & Food
6:00 - Announcements
6:15 - Featured Presentation
7:15 - Prize Drawings

Location:

Apparatus HQ
1401 North Meridian St.
Indianapolis, IN 46202

 Other News

 

IndyPASS 2016 Sponsorship Renewal

Know a company that is a good IndyPASS fit?  Invite a rep to the next IndyPASS Meeting and show them what IndyPASS is all about.

2016 Sponsorship details below.

IndyPASS Sponsor

Cost: $500 annual commitment:

•       $400 in cash

•       At least one prize equivalent to $100 in value (Our members will gladly take more if you want to give them!) Benefits:

IndyPASS Supporter

Cost: $500 annual prize commitment

•       At least $500 of SQL or IT related products with a minimum MSRP of $500 Benefits:

Meeting/Food Sponsors

Cost: Various (approximately $200 per meeting) :

•       DBA’s love free food and they remember who bought it!

 IndyPASS Tweets

Follow us at @IndyPASS:
http://twitter.com/indypass

 Sponsors


Apparatus
Indy Data Partners

Pinnacle Partners.
SIOS
Tully Recruiting
 Violin Memory
 Supporters
Quest Software
ingeniously simple tools
 Special Offers

O'Reilly Bookstore

 IndyPASS Logo Merchandise

Based on popular demand, we now have IndyPASS Logo Merchandise available. Get yours today!

IndyPass Mug.jpg