))
Azure SQL Database: Non-blocking transactions
Manage episode 354391402 series 3444474
Content provided by Scott Hanselman. All podcast content including episodes, graphics, and podcast descriptions are uploaded and provided directly by Scott Hanselman or their podcast platform partner. If you believe someone is using your copyrighted work without your permission, you can follow the process outlined here https://ppacc.player.fm/legal.
Managing concurrent access to a resource, be it a row, a table, or a single value, is easy if no one is trying to modify the underlying data. But what happens if someone changes data while someone else is reading it? Even better, what could happen if two or more users try to change the same data at the same time? Well, there are a couple of options. The easiest is to just ask everyone to queue up, the other is to have multiple versions of the data available over time so that no one must wait for the changes to be finished. Let's explore both the options with Lara Rubbelke and Davide Mauri on Azure Friday. Chapters 00:00 - Introduction 01:50 - DEMO: Locking behavior 03:20 - DEMO: Default "read committed snapshot" behavior 05:20 - Migrating from SQL Server to Azure SQL DB 06:42 - DEMO: snapshot isolation level 12:12 - Wrap-up Recommended resources Transaction locking and row versioning guide SET TRANSACTION ISOLATION LEVEL (Transact-SQL) Azure SQL Database Create a Pay-as-You-Go account (Azure) Create a free account (Azure) Connect Lara Rubbelke | Twitter: @SQLGal Davide Mauri | Twitter: @MauriDB Azure Friday | Twitter: @AzureFriday
485 episodes
Share
