SQLBits 2023
My application is fully concurrent and async. What about the database?
Let's look at how concurrency works inside the database. If you want to create a truly scalable solution, this knowledge is needed as much as knowledge about threads and synchronization mechanisms in your favorite language.
You have created a beautiful, concurrent application taking advantage of all the latest and greatest language features. It scales magnifically and it’s the jewel of the cloud. But what about the database? What happens when simultaneous queries are executed against the same data? Using Azure SQL Database or SQL Server, we'll see what happens behind the scenes, how it guarantees concurrency *and* consistency and what options you have to performance *and* scalability.