Fox Valley Microsoft Data Platform

 Welcome to FoxPASS, the SQL Server community for Northeast Wisconsin! 

Next Meeting: Wed, Oct 03 2018

Locking and its effects on queries and maintenance tasks

Language: English
Event Type: In-Person
Online Meeting URL: None
RSVPURL: https://www.meetup.com/Fox-Valley-Microsoft-Data-Platform/events/254803444/?isFirstPublish=true

Please join us for Jacob Manske's presentation on Locking and its effects on queries and maintenance tasks.

 

A little bit about Jacob:

"Jacob 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."

 

See you there!


When

iCal
Event Time : Wed, Oct 03 2018 17:30 - 19:30 Central Daylight Time
Your Local Time: Wed, Oct 03 2018 22:30 - 00:30

Where

4351 W College Ave
Appleton, Wisconsin

Direction: Suite 210 (Second Floor) (Follow signs)

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 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.

Thank you 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