www.sqlpass.org    Professional Association for SQL Server




We are pleased to announce that we have new Chapter Leaders: Andy Yun & Lowry Kozlowski!  They are excited to take the reins and revitalize the User Group!

The group will be meeting at SWC Technology Partners:

SWC Technology Partners
1520 Kensington Road
Oak Brook, IL 60523 



We will no longer be using the MailChimp system for future communication. Please make sure to update your PASS Profile & Join our Chapter here. All future mailings will be sent out via your SQLPass account:


Quick Search on "Chicago Suburban SQL Server User Group" and make sure you are registered as a member.  Doing so will ensure that you will receive future e-mails from us.

 Next Meeting

DATE Tuesday, October 7, 2014 
SPEAKERS      SQLSkills - Jonathan Kehayias, Erin Stellato, & Kimberly Tripp
SESSION  Session 1: SQL Sentry Plan Explorer
Presenter: Jonathan Kehayias 

Abstract: Learn how SQL Sentry Plan Explorer can help you explore and tune the most difficult query plans! Jonathan will cover the key differences between Plan Explorer and SQL Server Management Studio plus what to look for in estimated and actual plans. Even if you have used Plan Explorer - you might be surprised at the cool things you can do. And, if you haven't used it - you shouldn't go any longer without knowing this revolutionary FREE tool from SQL Sentry!
Session 2: Extended Events
Presenter: Erin Stellato

Abstract: If you’re looking to upgrade to SQL Server 2012 or 2014 soon (or, perhaps you already have!) you need to understand how to use Extended Events. Not only can you use Extended Events to accomplish what you’ve been doing with SQL Trace / Profiler, but it’s the only method for capturing information about new features such as In-Memory OLTP and Availability Groups.  We’ll look at Profiler and Extended Events side by side so you can see how easy it is to transition to using Extended Events. 

Session 3: Statement Execution / Caching
Presenter: Kimberly Tripp

Abstract: Have you ever wondered how SQL Server caches statements? Or, how much cache can be allocated to your plans? And, how it works - is this a good thing or a bad thing? What are the overall costs and benefits? In this final section, Kimberly will show you a variety of statement execution methods (ad hoc, dynamic, sp_executesql) and how / when (or, if?) they are cached. Additionally, we’ll look at some DMV queries to see them in cache. Finally, Kimberly will also compare and contrast how stored procedures work and when these can prove to be a better option!


  • 6:00PM - Doors Open
  • 6:30PM - Meeting Start - Open Q&A and Networking (bring your questions!)
  • 7:00PM - 8:30PM - SQLSkills Presentation Mashup


The Professional Association for SQL Server (PASS) is an independent, not-for-profit association, dedicated to supporting, educating, and promoting the Microsoft SQL Server community. From local user groups and special interest groups (SIGs) to webcasts and the annual PASS Community Summit � the largest gathering of SQL Server professionals in the world � PASS enables knowledge sharing, in-depth learning, access to the Microsoft SQL Server team, and the ability to influence the direction of SQL Server technologies. PASS was founded in 1999 by Microsoft and CA and continues to enjoy executive level endorsement from both organizations. As the number one user community for Microsoft SQL Server, Microsoft looks to the PASS community for valued feedback, input, and inspiration. PASS Mission Empower the global Microsoft SQL Server community to connect, share, learn and be inspired through networking, knowledge sharing, peer-based learning, and the ability to influence the direction of Microsoft SQL Server products and services.




 Contact Us

Andy Yun
E-Mail: SQLBek@gmail.com
Twitter: @SQLBek

Lowry Kozlowski
E-Mail: lowrykoz@gmail.com
Twitter: @lowrykoz

Chapter E-Mail: chisuburbanssug@sqlpass.org