Other News

 

IndyPASS has a new sponsor - Welcome SIOS

SIOS delivers innovative software solutions that provide application availability and disaster protection for Windows and Linux environments.


SIOS SAN and SANLess clustering software provides the flexibility to build clusters your way to protect your choice of Windows or Linux environment – and any configuration (or combination) of physical, virtual and cloud (public, private, and hybrid) storage – without sacrificing performance or availability. SIOS’ unique SANLess clustering solution eliminates both the cost and the single-point-of-failure risk of traditional shared-SAN storage. Please welcome and support SIOS, our newest IndyPASS Sponsor! http://us.sios.com/

   SIOS

 Feature Presentation

August 18th, 2015 

Stored Execution Plans – The good, The Bad and The Ugly

Brandon Brown, Crowe Horwath

Abstract:

Have you ever wondered why a procedure will run quickly one minute and slow the next? Without in-depth knowledge of execution plans, understanding performance variances can be a very painful experience. Sometimes stored execution plans can beneficial and other times it can lead to major performance degradation. I am going to show examples of how I use stored execution plans to performance tune our applications. I will cover topics such as parameter sniffing, incorrect temp table statistics, and statistic utilization within plans.

About Brandon:

My name is Brandon Brown. I am a SQL developer / DBA in Indianapolis, IN. I have spent most of my career building healthcare applications for reporting and data analytics. Over the years I have become infatuated with the SQL query optimizer, execution plans, and performance.

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

 Anouncements
PASS Summit Discount Code Is Here

Discount Code: LC15TDF8

Registration Info:

The PASS Summit 2015 registration rate goes up after April 19, so we encourage you to share this code ASAP with anyone interested in attending PASS Summit 2015 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 #Summit15 hashtag.   -  https://www.regonline.com/Register/Checkin.aspx?EventID=1628378

 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