Welcome

The Madison SQL Server Users Group (MADPASS) is an official chapter of the Professional Association for SQL Server. We are here to support the SQL Server users in the Madison, WI area. We plan to meet on the third Wednesday of every month.

Meetings are always FREE and food is provided. Details about the next meeting can be found below.

In an ongoing attempt to make the content presented useful to our members we start each meeting with a short Q&A session. Unless noted in the meeting notes the schedule for each meeting will be:

5:30 - 5:45 - General Q&A session & Announcements
5:45 - 6:15 - Food &Networking
6:15 - 7:30 - Main Presentation
7:30 -7:45 - Q&A Session / Door Prizes / Wrap-up

 

Meeting Location Provided By:
Talavant

Next Meeting

Wednesday,

August

15

August MadPASS Monthly Meeting

  • In-Person @ 5510 Nobel Drive Fitchburg, Wisconsin, United States (map)
  • Online @ None
  • 17:30 - 20:00 Central Daylight Time

5:30 - 5:45 - Food & Networking

5:45 - 6:15 - General Q&A session & Announcements

6:15 - 7:30 - Main Presentation

7:30 - 7:45 - Q&A Session & Wrap-up


Third Wednesday of month

Time: 5:30 to 8:00 PM


Featured Presentation:

Locking and its effects on queries and maintenance tasks

Jake Manske, Software Developer Epic

Multi-user systems are affected by how SQL Server locks resources to manage concurrent transactions. Understanding how SQL Server uses locks to isolate transactions from one another is important for both writing code and running maintenance tasks. In this session, we will discuss lock modes in SQL Server and how they impact your queries. We will show how different isolation levels change which locks are taken and for how long they are held. We will look at ways to avoid unnecessary blocking for maintenance tasks like index rebuilds. Assertions will be backed up with demo-based evidence. After this session, you will have the understanding you need to start writing application code and maintenance jobs suitable for concurrent systems by anticipating blocking issues due to locking.

About Jake:
Jake has been a T-SQL developer for 5 years, starting after he jumped ship from an academic life as a mathematics professor to the software industry. He focuses on solving difficult concurrency problems and understanding SQL Server optimizer behavior.

Connect with us!

 

PASSChapterLogo100.jpg 

 sql_micro_sm.gif 

Office 365 

 

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids