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,

February

10

SQL Server Availability Groups

  • In-Person @ 201 S Clinton St, Iowa City, Iowa (map)
  • 17:30 - 19:30 (UTC-06:00) Central Time (US & Canada)
  • Language: English

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

Sponsor: Kingfisher Technologies

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

Featured Presentation:

Extending Your Availability Group for Disaster Recovery

Ed Leighton-Dick, Founder/Principal Consultant Kingfisher Technologies

Did you know that SQL Server Availability Groups can be a great solution for disaster recovery? Availability groups have become well known for their high availability capabilities, and for good reason: they work well, they remove some of clustering’s limitations, and they are fairly straightforward to setup. Extending an availability group to multiple sites for disaster recovery becomes more complicated. A lot of moving parts have to come together for it to work properly - SQL Server, Windows, Active Directory, and DNS all get involved in this advanced configuration. In this session, we’ll discuss some of the factors that complicate a multi-site availability group deployment, and we’ll walk through a multi-site deployment so you can see how it’s done.

About Ed:
Ed Leighton-Dick is a SQL Server performance and architecture expert with over twenty-three years of experience in development, database administration, and system administration. In 2014, he founded Kingfisher Technologies, a consultancy focused on SQL Server performance, architecture, and security. Ed volunteers his time with PASS, including roles as Midwest Regional Mentor, Chapter Leader of I-380 PASS SQL Server User Group, and organizer of SQLSaturday Iowa City. He can often be found teaching sessions at local, regional, and national events, including user groups, SQLSaturday events, and Iowa Code Camp. Outside of work, he is a devoted husband, father of two beautiful girls, and beginning runner. Ed can be reached through his blog, edleightondick.com, and on Twitter at @eleightondick.

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!