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.
You will learn:
- Understand what are locks, why they are needed and how they work
- How to create applications with databases that can scale as much as needed
- About isolation levels and database internals