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. The I-380 PASS Chapter was formed in 2009 to support SQL Server users in Cedar Rapids, Iowa City, and surrounding areas. We meet the second Tuesday of every month, and we're working hard to develop a vibrant and interactive SQL community for Eastern Iowa.

Meetings are always FREE and food is provided, typically pizza. Please register to help us know how much food to bring, but feel free to come even if you decide at the last minute and cannot register ahead of time. Details about the meeting can be found below.

If you have any questions, please contact Ed Leighton-Dick (

Next Meeting




SQL Murder Mystery Hour: Living and Dying by Dynamic SQL

  • In-Person @ 201 S Clinton St, Iowa City, Iowa (map)
  • Tue, Oct 13 2015
    17:30 - 19:30 Central Daylight Time
  • Language: English


Dinner starts at 5:30p - Meeting starts at 6:00p

Please RSVP for this meeting using the survey to the right.

Featured Presentation:

SQL Murder Mystery Hour: Living and Dying by Dynamic SQL

Doug Lane, Consultant Brent Ozar Unlimited

Ask any DBA if they want to manage dynamic SQL: "Impossible-to-read source code and SQL injection? No thanks!" they'll say. However, dynamic SQL not a tool of the desperate and unskilled. It is flexible and makes complex queries screaming fast when more conventional methods cannot. In this session, we focus on: * Understanding pros and cons of dynamic SQL * Writing fast and efficient dynamic SQL code * Monitoring dynamic SQL statements and their performance To spark discussion and keep the audience riveted, this session is styled as a technical presentation weaved into an interactive murder mystery, complete with suspects, interrogations, and clues. Attendees form small groups to observe, discuss, and ultimately solve the mystery of the deadly dynamic SQL. Developers and DBAs: if you want to become wise in the ways of dynamic SQL, this session is for you. Be sure to bring your sleuthing skills!

About Doug:
Doug Lane (MCITP, MCTS) is a consultant for Brent Ozar Unlimited, specializing in T-SQL, Reporting Services, and motion pictures. He has over 15 years' experience in IT. In addition to presenting at conferences, SQL Saturdays, and user group meetings, Doug also blogs and does webcasts on


Speakers needed!
Wednesday, September 9, 2015

We're looking for a few good speakers! All months in 2016 are now available for anyone who would like to present a session. All topics and skill levels are welcome, and new speakers are encouraged. Email Ed at if you're interested or if you have a suggestion for a session.


2016 Sponsorships Now Available
Wednesday, September 9, 2015

Sponsorships are now available for 2016. Quarterly sponsorships are being added this year, in addition to our traditional monthly sponsorships. Details will be on our website shortly, or you can contact Ed at Our sponsors enable us to offer free training every month in eastern Iowa - please pass the word along to your companies and invite them to help!

UPDATE [9/22]: Our sponsorship page is now available!


Looking for session materials?
Thursday, July 16, 2015

Looking for session materials?  Check the Meeting Archive page!  We're uploading files we receive from speakers to each meeting's record.


PASS Summit Discount Code
Tuesday, May 12, 2015

If you're planning to head to PASS Summit in October, use our discount code!  You'll get $150 off your registration, and I-380 PASS will receive a $50 referral fee to use for our chapter operations.  Just enter code LC15HPP4 when you register.