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,

July

14

Understanding Backup and Restore

  • In-Person @ 415 12th Ave SE, Cedar Rapids, Iowa (map)
  • Tue, Jul 14 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:

Understanding SQL Server Backup and Restore

Tim Radney, Principal Consultant SQLskills

Everyone knows that it's critical to have backups but it's amazing how few people make sure those backups can be restored properly! Too many times to count, Tim has been brought in by organizations to help recover failed systems where administrators simply didn’t know how to properly restore SQL Server backups when they have to. In this session, Tim will explain the various types of backups that can be taken and demonstrate how to restore each of them. Apart from covering the common full, differential and log backups, Tim will also cover partial, filegroup, and COPY_ONLY backups, backing up to and restoring from a URL, backup encryption, and how to perform a hack attach for the ultimate tail log restore. There's something here for everyone to learn!

About Tim:
Tim Radney is a principal consultant with SQLskills and a Microsoft SQL Server MVP.

Announcements

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.

 

Links from Dec 9 meeting
Tuesday, December 9, 2014

* David Thole's Linq/SQL comparison can be found at http://bit.ly/1qq9FQL.

* The Computer Science Education Week links Ed spoke about are at http://bit.ly/CSEW2014.

Thanks to all who came to the meeting tonight! I hope to see you all in 2015.

 

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!

 

Our chapter's Summit referral code is now available!
Wednesday, June 11, 2014

Are you planning to go to this fall's PASS Summit in Seattle?  If you are and you haven't registered yet, you can take advantage of our chapter discount code.  You get a $150 discount off your registration fee, and our chapter gets a referral bonus to use toward chapter operations!  Just use code USNCS23 when you register to get the discount.

And feel free to pass this code along to others, even if they aren't members of our chapter. The more people that use the code, the more that we benefit!

 

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!

 

February slides and scripts now available
Sunday, March 2, 2014

For those who attended our February meeting, Frank Gill has posted his slides and scripts on his website.  You can download them at http://skreebydba.com/presentation-slides-and-scripts/.

 

PASS Business Analytics Conference Referral Code
Tuesday, January 14, 2014

Today we received our referral code for the upcoming PASS BA Conference, to be held in May in San Jose, CA. When you enter this code at registration, you receive $150 off the current conference fee, and our chapter receives $50 to use toward chapter operations. You can use the code anytime between now and the conference, but unfortunately, it cannot be applied retroactively to existing registrations.

Our referral code is BA2Q8B.  Please pass the code along to others - they don't have to be a member of our chapter to use it.

 

Slides from Dec 10 meeting
Wednesday, December 18, 2013

David Klee's slides from our December 10 meeting are now available on our Resources page.