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,

April

14

Bridging the Gap from Rows to Columns

  • In-Person @ 201 S Clinton St, Iowa City, Iowa (map)
  • Tue, Apr 14 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: 


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

Featured Presentation:

Bridging the Gap from Rows to Columns

Larry Toothman, Database Administrator

For many who come to T-SQL from other languages, dealing with result sets and thinking in set based solutions can be frustrating. Our minds are conditioned to think in processing rows of data, not entire sets. As a consequence many give up and misuse cursors or come up with other ways to create RBAR (Row By Agonizing Row) solutions. Some others try to deal with sets but get caught in the tangle of nested queries. In this session I will deal with Table Expressions with particular emphasis on CTEs or Common Table Expressions. Let me show you how using these simple tools can help simplify your code, bridging the gap between RBAR and set based solutions.

About Larry:
Larry has been a Database Administrator for a non-profit health system in Cedar Rapids, IA since late 2007. With over 20 years of software and database development experience, he was drafted to be the DBA in 1999 for a dev company. Amazed by the wide variety of people in the SQL Server community as well as the support from the "SQL Family" Larry is always looking for opportunities to pay it forward, spread the word & mentoring.

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!