top of page
Writer's pictureMadeira Team

SQL Azure default isolation level

Updated: Jun 25, 2020

I came across Bob Beauchemin’s post, stating that the SQL Azure default isolation level is read committed snapshot.

This is generally pretty cool as it increases database concurrency, but should be taken into account when migrating your on-premise database or writing new code that will run on SQL Azure.

For example, suppose you have a process that updates a large table, and the update takes a few minutes.

When working in read committed, reading sessions are blocked, and get the updated value when the upgrade is finished.

When working in read committed snapshot, reading sessions get the last consistent value before the update.

What’s the correct way to work? Both can be the answer, as it depends on the business scenario.

Bear in mind that you can still override this default at the session level using set options.

1 comment

1 Comment


Guest
Oct 14

I've noticed a lot of businesses shifting their focus to digital assets, especially with how the NFT space is growing. If you're looking into expanding your business model or investing in emerging tech, it might be worth checking out how NFTs are being leveraged in various industries. They’re not just about digital art anymore, but also about ownership, contracts, and unique business opportunities. For those wanting to explore this further, sites like https://icoholder.com/en/nft provide a lot of useful insights and tools on how to navigate this growing sector. Definitely worth a look if you're thinking of diversifying or staying ahead of market trends!

Like

STAY IN TOUCH

Get New posts delivered straight to your inbox

Thank you for subscribing!

bottom of page