Job Openings

Moser Consulting

Moser Consulting has a job opening for SQL Server DBA. If you have any questions about the opening, please contact Bryan Robertson at

Feature Presentation

Meetings take place every third Tuesday of the month.

Tuesday, March 20, 2018

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

Erin Stellato

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 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.

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

Apparatus HQ
1401 North Meridian St.
Indianapolis, IN 46202

Upcoming Meetings

Tuesday, April 17th, 2018
Kimberly Tripp

Stored Procedure Optimization Techniques
Kimberly will discuss stored procedure caching and the potential for performance problems due to a problem known as parameter sniffing. There are some common solutions and while they can drastically improve performance, they can also cause other problems. Sometimes a hybrid solution is needs, from this session, you’ll know the best way to write procedures so that stable requests are cached and unstable requests are not (giving you the most optimal performance without wasting resources).

Other News

IndyPASS 2017 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:

Indy Data Partners
Moser Consulting
New Horizons
Vaco Technologies


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

Back to Top