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,

August

11

PowerShell

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

PowerShell for the Reluctant Administrator

Pat Phelan, GIR Involta, LLC.

You've heard many people claim that PowerShell is fabulous, but you've never really felt the need for it. What's all the fuss? What is PowerShell and why should you even care, much less learn it? How will this new toy make your work easier? This session will help you understand what PowerShell is, how it integrates into the tools you know and love, and how it can help make your everyday work go faster and more smoothly. Along with the background on PowerShell, you'll see some simple but useful tools and ideas for how you can use those tools and make your own tools too. This session was designed for the non-PowerShell user and the new PowerShell user. It is intended to help people start to use PowerShell, and it will touch on advanced ideas but only assumes only basic scripting/coding experience like understanding a variable, a loop, etc.

About Pat:
Pat Phelan joined a user group (DECUS) in High School, and many more since then. Pat worked many jobs in high school and college, and over twenty years for a major accounting firm. Pat started working for Involta in 2007 and is now the database mentor and a member of the Engineering team. Involta builds, owns and operates world class colocation datacenters and provides managed services and support staff to clients.

Announcements

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.

 

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!