Welcome to the Kansas City SQL Server User Group!

We're currently looking for feedback on a number of items from the group in order to make the meetings more beneficial to everyone.  Please take a moment to fill out this survey (It should only take a minute or two).

We typically have meetings on the third Thursday on the month (times and locations may vary). 

We strongly encourage you to register and sign up using the registration link above to receive updates and announcements regarding our local chapter.  

Still have questions, please email me at: watts.tee@gmail.com.

 

 

Next Meeting

Thursday,

January

19

January 2017 - KC SQL Server User Group Meeting

  • In-Person @ 10801 Mastin Blvd. Overland Park, Kansas, United States (map)
  • 14:30 - 16:00 (UTC-06:00) Central Time (US & Canada)
  • Language: English

Please join us January 19th, from 2:30PM – 4:00PM at the Microsoft office in Corporate Woods. 

Register here

Please note, this will be an afternoon meeting.

Meeting Schedule for Thursday, January 19th, 2017:

  • 2:30 - 2:40 - Greeting and Housekeeping
  • 2:40 - 3:40 - Presentation
  • 3:40 – 4:00 - Wrap up and Q&A

We look forward to seeing you all soon!

KC SQL Server User Group web site: http://kansascity.sqlpass.org/

Featured Presentation:

Lock, Block, and Two Smoking CPUs

Daniel Maenle, Database Administrator Jack Henry & Associates

This session is about Dan Maenleā€™s personal experience rewriting the locking mechanism that his company was using. As well as migrating from a locking table to using the sp_getapplock stored procedure. This session will cover the ups and downs that he experienced in the transition. Dan will also discuss how this technique can be a better performing approach to gaining locks that could be used by the application or other queries to optimize concurrency.

About Daniel:
Daniel Maenle is a Database Administrator at Jack Henry & Associates and has been working with SQL server since 2011. He spoke at SQL Saturday Kansas City last year presenting on this same topic.