I’m proud, giddy, and just plain overly excited to be giving a pre conference session at the SQL PASS Summit in Seattle, Washington on November 5, 2018.
This is going to be a fun, demo-packed day which will teach you skills you can use throughout your career as a developer, database administrator, or data professional.
While features and tricks change from year to year (or even month to month), understanding isolation levels is critical for your long term future.
The Session: Prevent ‘Fake News’ in Your Data! Isolation Levels Demystified
Are your users seeing bad data? If you’re using the default isolation level of read committed in SQL Server, chances are that sometimes your users get incorrect results. If NOLOCK hints lurk in your code, the odds are even higher that sometimes your customers see information that just isn’t right.
In this day-long, demo packed session, you’ll learn why a single statement may read rows twice, miss rows entirely, or return combinations of data that never existed in the database — and why that’s not a bug. You’ll learn what “read phenomena” are, which isolation levels are vulnerable to them, and the performance trade-offs which come from raising your isolation level to protect your users from bad data.
You’ll see how isolation levels work with newer technologies such as columnstore indexes, In-Memory OLTP, and Always On Availability Groups. You’ll discover why version-based isolation levels can be awesome, and what you need to look out for with these isolation levels to avoid race conditions that produce– you guessed it– incorrect results.
At the end of the day, we’ll pull together all this information into a guide. You’ll leave the seminar with the tools and knowledge to choose the right isolation levels for new and existing applications based on business and performance requirements.
What Does it Cost?
A single pre-conference session is $499. You can also bundle pre-conference sessions with registration at the full Summit.
Attendees at my pre-conference session will not only get all the demos we show live, and a download of the PDF of slides, but also….
Perk: Watch It Again Later
Access to a recorded online session of my 8 hour seminar, “Conquer Blocking & Isolation Levels” for a full year.
Want to revisit a topic and get the nitty gritty details? You’ll be able to watch anytime, online.
Note: the live pre-conference sessions at PASS aren’t recorded for purchase anymore– however, you can buy recordings of “regular” sessions during the week from PASS in different formats.
Perk: A Month of SQLChallenges!
For four weeks following the conference, I’ll be hosting SQLChallenges on blocking and isolation level problems.
- Attendees will get access to the problems and a chance to apply the skills they’ve learned.
- I’ll hold a live, online session going over sample solutions for the problem. Attend, share your solution in Slack if you’d like, and ask questions.
- Can’t make the SQLChallenge live? The recording will be posted and you’ll get online access for a year. All SQLChallenges support Q&A in the course pages.
Perk: Private Follow-Up Quizzes
Want even more learning? Following the SQLChallenges, attendees will get access to a series of four weekly quizzes about blocking and isolation levels to confirm your knowledge.
Combining this will the month of SQLChallenges will fully establish your new knowledge in place, getting you the most value for your dollar.
I hope to see you at the PASS Summit! Sign up here to join my pre-conference session.
Postscript: SQL Symposium subscribers get access to all these perks as well. As sustaining members during the first year of SQLWorkbooks, SQL Symposium members get it all 🙂