Build your skills with Extended events in this SQLChallenge.
This course is an overview of why Read Committed Snapshot Isolation (RCSI) and Snapshot Isolation levels are critical for scaling workloads in SQL Server.
If you haven’t thought much about isolation levels in SQL Server, chances are your application can easily return incorrect data to your users.
In just half an hour, you’ll see how queries against a readable secondary in an Availability Group are automatically escalated to Snapshot Isolation – whether you ask for it or not!
Sharpen your skills at fighting blocking and deadlocks.
What happens when you use NOLOCK hints in your code, or set your isolation level to READ UNCOMMITTED in SQL Server?
Serializable and Repeatable Read isolation levels offer protections so your users won’t see weird or incorrect data – but there are tradeoffs for those protections.