SQLBits 2022

2 Fast 2 Furious - designing for speed, concurrency, and correctness (20 min edition)

Learn how to design for speed, concurrency, and correctness and avoid common database development pitfalls.
With the multitude of isolation levels, concurrency models, and specialist technologies available in SQL Server, it is no surprise that transaction throughput and correctness can be directly correlated to the ability and knowledge of the person that wrote the code.

In this session, we will reveal how SQL Server concurrency and correctness often goes wrong, how we can avoid this, and how we can use our knowledge to design and develop for optimal server throughput for our applications and processes using tips and tricks gained from real-world scenarios.

Feedback Link - https://sqlb.it/?7039