Please note: our site will be undergoing scheduled maintenance on April 21, 2019, starting at 07:00 UTC and ending at April 22, 2019 04:00 UTC. During this period, you will not be able to log in to your PASS account. To register for PASS Summit, select the Register as Guest option. If you require assistance, please email helpdesk@pass.org. Thank you for your patience.

Fox Valley Microsoft Data Platform

Next Meeting

Wednesday,

December

05

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

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!

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 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, large scale data warehouse ETL processes, data conversions, and understanding SQL Server optimizer behavior.

Supplementary Materials

The following event attachments are available to you:

Bronze Sponsors

 

Hosts

 

Other 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