New IndyPASS Sponsor - Indy Data Partners

IndyPASS is proud to welcome our newest sponsor, Indy Data Partners - 

Indy Data Partners is an Indianapolis-based, Veteran-owned IT solutions company that provides core Microsoft and Oracle database support, business intelligence solutions, and custom application development services.  Indy Data Partners’ mission is to deliver data-centric IT solutions, while ensuring outstanding customer service, rapid response times, and reliable and proficient technical solutions to our clients.

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

 Feature Presentation

May 19, 2015

The Business Intelligence Data Mart

Chris Schmidt, Centric Consulting


Once you've built you're Business Intelligence ecosystem, you want to ensure that everything is running smoothly. SSIS packages should be timely, analysis services databases should be logging their usage, and reports should be monitored for improvement where possible. In this session, we'll start out by discussing why a management data mart is a good thing, and why you need this tool in your business intelligence environment to properly monitor and manage usage. Then we'll cover adding event handlers to your SSIS packages for a robust business intelligence solution. Next we'll see how DMV's and profiler monitor usage and query performance, and pulling data from the Report Server database to track reports. Later, we'll discuss how to report off of this new data mart and the best way to deliver this report to management for some much needed insight  

A Little About Chris:
Chris Schmidt from Centric Consulting will be May's presenter. Chris is a Data Architect and has more than 6 years experience in developing business intelligence solutions. He lives in Columbus, OH and is an active member of the SQL community, currently serving on the board of the CBusPASS user group as vp of membership/marketing. Chris is extremely passionate about business intelligence, and helping companies achieve insight through data.


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

 Other News

Book Exchange

Beginning at the July 2009 meeting ...
Bring an old SQL Server book.
Take an old SQL Server book.
Help a SQL Pro in need.
Learn something new indeed.

SQL Job Opportunities

Job Postings are now online. Are you seeking SQL professionals? Are you seeking a new place to ply your skills? Visit the IndyPASS Job Opportunities forum today. Members only! Please register to post or view job opportunities.

Prior Presentations

The slides and code examples from January's IndyPASS meeting are now available in the Prior Presentations area of the site.
 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