*RAFFLE* Everything You Know About Isolation Levels Is Wrong with Erik Darling

NOTE: This month the meeting is on a Tuesday instead of the usual Thursday to coordinate with PASS on Tour: Dallas, and our speaker.

Sponsored by Redgate

Click here to register for the PASS On Tour event in Dallas, click the image below. Use the code DALLASUGTOUR100 at checkout to get $100 off your 2-Day Combo Ticket.

Click here to register for the PASS Data Community Summit, click the images below. Use the code DALLASUG150 at checkout to save $150 on your 3-Day Ticket.

Title: Everything You Know About Isolation Levels Is Wrong

Abstract:
You’ve been told that NOLOCK hints are bad, so you look at all the queries your developers write and hang your head in shame. A NOLOCK hint here, a NOLOCK there, a NOLOCK hint seemingly everywhere. Like termites, eating at the foundation of your well-being.

But in the real world, how are you supposed to remove those all those yucky hints without blocking and deadlocking causing huge problems?

I'm Erik Darling, and I'm a world class NOLOCK hint removal expert, and in this demo-heavy session, I'll change your mind about every isolation level.

You're going to learn why:
* Read Committed is nearly as weak as Read Uncommitted
* Optimistic isolation levels aren't incorrect-result factories
* Repeatable Read isn't what it sounds like
* Serializable isn't the enemy of concurrency
* You don't need to worry about tempdb's version store
* No isolation level is perfect for every workload

At the end, you’ll have the confidence and knowledge to start turning on optimistic isolation levels and stop hanging NOLOCK hints all over your queries like Christmas tree ornaments.

RAFFLE - This month we're going to be raffling off some awesome Lego sets, but there's a catch. To be eligible for the raffle, you have to register and attend PASS on Tour: Dallas. Bring your PASS on Tour badge with you to the meeting and you will get an entry for the raffle. For registration details, see the link above.

6:00 pm - get to MS Las Colinas & get some food
6:30 - 6:45ish - Announcements & Ask the Experts
6:45-7pm - Start Presentation
8:30pm - End Presentation; Wrap Up
When: Tuesday, September 16, 2025
Food - Pizza