Fox Valley Microsoft Data Platform

Next Meeting: Wed, Dec 05 2018

"Locking and its effects on queries and maintenance tasks" with Jacob Manske

Language: English
Event Type: In-Person & Online
Online Meeting URL: https://meet.lync.com/myskyline365-skylinetechnologies/jlindbom/SD6JLPJK
RSVPURL: https://www.meetup.com/Fox-Valley-Microsoft-Data-Platform/events/256734675/?isFirstPublish=true

After the unfortunate cancel back in October, we are pleased to have Jacob Manske join us for his presentation on December 5th at the Skyline Technologies Garage where we will be discussing "Locking and its effects on queries and maintenance tasks". A description of the talk: "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." You can also join the meeting through Skype found here: https://meet.lync.com/myskyline365-skylinetechnologies/jlindbom/SD6JLPJK.


Thank you!

When

iCal
UTC : Wed, Dec 05 2018 11:30 - 13:30
Event Time : Wed, Dec 05 2018 05:30 - 07:30 (UTC-06:00) Central Time (US & Canada)
Your Local Time: Wed, Dec 05 2018 11:30 - 13:30

Where

100 W Lawrence St, Suite 100 Appleton Center
Appleton, Wisconsin

Direction: None

Featured Presentation

Locking and its effects on queries and maintenance tasks

Speaker: Jake Manske, Software Developer Epic

Summary: "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 since 2013, 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.

Attachments

Sponsors

PASSChapterLogo100.jpg 

 

sql_micro_sm.gif 

sql_ca_sm.gif 

 

Brent Ozar Unlimited

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