Transactions and locking masterclass
2022TL; DR
Learn everything you need to know to tame transactions and locking as a SQL Server developer
Session Details
Do you know what SET ARITHABORT does? Do you know the difference from XACT_ABORT? Why would you need the SERIALIZABLE isolation level? OK, wait, before your brain melts, come to this full-day training session.
You are a SQL Server developer. Or do you need to use SQL Server, Azure or on-premises, in your application development? This session is for you. You will learn how to use, handle, and master transactions in your code from the ground up. How to take concurrency and locking into account when you write SQL code and what happens on the server during transactions. Including how the transaction log works, which locking modes and types are at play, how to monitor and trace transactions, and locking and blocking. Then you will be able to handle transactions and locking with confidence, from simple transactions to deadlocks.