Other News

IndyPASS Birthday Bash v10

Join us for an evening of fun, networking and like every month you are bound to learn a little something. IndyPASS turns 10, so we are throwing a Summer BBQ, SQL Sentry is sending Kevin Kline on a Summer SQL Vacation and Indy is one of the stops. They will be providing great prizes, including SQL Sentry software, #SQLVacation T-Shirts, and of course a chance to meet and learn from the great Kevin Kline.

• Food Catered by Dick's Bodacious BBQ

• Birthday Cake - We've been doing this 10 years and its time to light the candles.

• Special Entertainment - You will have to show up to find out, but it will motivate you while putting a smile on your face.  

• Great Prizes - SQL Sentry Software, #SQLVacation T-Shirts, Books from WROX, O'Reily, Wiley and free training from pluralsight

• Featured Presentation: 10 Query Tuning Techniques Every SQL Programmer Should Know by Kevin Kline from SQL Sentry.



IndyPASS has a new sponsor - Welcome Mainstreet DBAs

Mainstreet DBAs senior level staff can fill project needs, consult on database issues, provide database risk assessments, or any other DBA related tasks that customers require. This allows smaller IT organizations to utilize Mainstreet as their sole DBA support and larger organizations to "plug" Mainstreet DBAs resoruces into their staff to handle fluctuations in DBA needs.Please welcome and support Mainstreet DBAs, our newest IndyPASS Sponsor! www.mainstreetdbas.com

   Mainstreet DBAs

 Feature Presentation

Happy Birthday - -IndyPASS Turns 10 on June 16, 2015 

10 Query Tuning Techniques Every SQL Programmer Should Know

Kevin Kline, SQL Sentry


SELECT statements have a reputation for being very easy to write, but hard to write very well. This session will take you through ten of the most problematic patterns and anti-patterns when writing queries and how to deal with them all.  Loaded with live demonstrations and useful techniques, this session will teach you how to take your SQL Server queries mundane to masterful.

Goal 1: Implement a reusable Transact-SQL test harness for reliable query results.

Goal 2: Learn ten patterns that kill the performance of SELECT statements and how to avoid them.

Goal 3: Discover the high-impact metadata that shows how a SELECT statement behaves … or misbehaves.

About Kevin: 

Kevin Kline is a database expert serving as Director of Engineering Services at SQL Sentry, a leading database tools vendor. A Microsoft SQL Server MVP since 2003, he is a founder and former president of PASS, author of over a dozen books, blogger, columnist, and popular speaker. Kevin has authored many books, including the best-selling "SQL in a Nutshell" and contributes monthly for Database Trends & Applications magazine. He tweets at @kekline and blogs at http://KevinEKline.com


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

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:

Indy Data Partners

Pinnacle Partners.
 Violin Memory
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