Sign in to confirm you’re not a bot
This helps protect our community. Learn more

Azure SQL Database: Non-blocking transactions | Azure Friday

Microsoft Azure
340K subscribers
<__slot-el>
<__slot-el>
4.7K views 2 years ago #MicrosoftAzure #AzureFriday #AzureSQL
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 – https://aka.ms/azfr/726/01 ■ SET TRANSACTION ISO …...more
...more
Azure SQL Database: Non-blocking transactions | Azure Friday
112Likes
4,732Views
2022Aug 5
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 – https://aka.ms/azfr/726/01 ■ SET TRANSACTION ISOLATION LEVEL (Transact-SQL) – https://aka.ms/azfr/726/02 ■ Azure SQL Database – https://aka.ms/azfr/726/03 ■ Create a Pay-as-You-Go account (Azure) – https://aka.ms/azfr/726/payg ■ Create a free account (Azure) – https://aka.ms/azfr/726/free Connect with us ■ Lara Rubbelke | @SQLGal –   / sqlgal   ■ Davide Mauri | @MauriDB –   / mauridb   ■ Azure Friday | @AzureFriday –   / azurefriday   #MicrosoftAzure #AzureFriday #AzureSQL

Follow along using the transcript.

Microsoft Azure

340K subscribers