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,

January

13

Right-Sizing Your SQL Server Virtual Machine

  • In-Person @ -, -, Iowa (map)
  • 17:30 - 19:30 (GMT-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: Tegile


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

Featured Presentation:

Right-Sizing Your SQL Server Virtual Machine

David Klee, Founder & Chief Architect Heraflux Technologies

Virtualizing your top-tier production SQL Servers is not as easy as P2V’ing it. Sometimes allocating more resources to the VM is the wrong approach, and getting it wrong will silently hurt performance. What is the most effective method for determining the ‘right’ amount of resources to allocate? What happens if the workload changes a month from now? The methods for understanding the performance of your mission-critical SQL Servers gathered over the past ten years of SQL Server virtualization will be addressed, and valuable processes for performance statistic collection and analysis will be displayed. Come learn how to properly ‘right-size’ the resources allocated to a VM, improve the performance of your SQL Servers, and keep it maximized well into the future.

About David:
David Klee, Microsoft MVP and VMware vExpert, is a SQL Server performance and virtualization expert. David spends his days handling performance and HA/DR architecture of physical and virtualized critical SQL Servers as the Founder of Heraflux Technologies. His areas of expertise are virtualization and performance, datacenter architecture, and risk mitigation through high availability and disaster recovery. You can read his blog at davidklee.net, and reach him on Twitter at @kleegeek.

Announcements

Links from Dec 9 meeting
Tuesday, December 09, 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!

 

Publisher discount codes
Sunday, March 09, 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!