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 (ed@380pass.org).

Next Meeting

Tuesday,

March

10

High-Performance SSRS Tuning

  • In-Person @ 415 12th Ave SE, Cedar Rapids, Iowa (map)
  • Tue, Mar 10 2015
    17:30 - 20:00 Central Daylight Time
  • Language: English

Dinner will start at 5:30 PM with the meeting following at about 6:00 PM.

Sponsor: Robert Half Technologies

Directions:

 

 

Vault Coworking is in the Geonetric Building in the New Bohemia in Cedar Rapids. From downtown, take 3rd St SE south. Turn left (east) onto 12th Ave SE at NewBo City Market/Chrome Horse. The Geonetric Building is just across the old railroad tracks on the right side of the street. We'll be in the cafe on the first floor. Please enter using the front (streetside) doors.

If you have problems finding the building, please call Ed at 319.560.8888.


 

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

Featured Presentation:

From Minutes to Milliseconds: High-Performance SSRS Tuning

Doug Lane, Consultant Brent Ozar Unlimited

Even though you're an experienced report developer or administrator, performance tuning for SQL Server Reporting Services still feels as bewildering and hopeless as folding a fitted bed sheet. You've made your data sets smaller and timeouts longer, but it's not enough to remove the slowness dragging down your reporting environment. In this session, you'll learn how design and configuration choices put pressure on your report server and techniques to relieve that pressure. You’ll see how to configure your Reporting Services databases for speed, streamline your subscription schedules, and use caching for high-demand reports. You'll also learn some design strategies to lighten your report processing load. If you want to maximize the speed of your Reporting Services environment and minimize the pain of performance tuning, this session is for you.

About Doug:
Doug Lane (MCITP, MCTS) is a consultant for Brent Ozar Unlimited, specializing in Reporting Services, T-SQL, and motion pictures.

Announcements

January 2015 slides posted
Wednesday, January 14, 2015

David's slides have been posted on our NEW Meeting Archive page.  Information about all of our meetings since December 2012 are also available from that page. Let us know what you think!

 

SQLSaturday Iowa City: Call for Planning Committee Members
Wednesday, January 14, 2015

We're ramping up our planning for SQLSaturday Iowa City 2015! If you'd like to help, or would like more information about what's involved, please contact Ed at ed@380pass.org by January 20.

 

Want to speak for us?
Wednesday, October 29, 2014

We're currently looking for speakers for the first half of 2015 on any topic related to SQL Server.  If you're interested, please email Ed at ed@380pass.org.

 

August meeting handout and script
Wednesday, September 10, 2014

UPDATE 10/7/14: I've been informed that the links pointed to the wrong files! That has been corrected. I apologize for the inconvenience! -Ed

I've posted two items related to our August meeting on the Resources tab:

* A handout that Jes gave me
* The script that Jeremy mentioned in his SQL Shot that checks the DMV dm_exec_requests to get the statement completion percentage

Sorry for the delay on this!

 

Publisher discount codes
Sunday, March 9, 2014

A list of current publisher discount codes for user group members has been added to the Resources page of our site.  Manning and O'Reilly are currently listed; more will be added as we find them.  Go and check them out!