I’m always happy when I have the opportunity to present a session for an audience, but I am especially excited about delivering a session for GroupBy next week! GroupBy is a free online training event that has been going on for about three years. I’ve always thought it was a great concept, but it hasn’t been until now that the stars have aligned and I am able to participate.
Even more exciting is that GroupBy is offering two streams this time around. European sessions will take place on Wednesday 9 October starting at 10:00am UTC, and North American ones will be Thursday 10 October beginning at 10:00am PDT. There will be five sessions per stream, each 45-60 minutes in length.
I’ll be presenting a new and improved version of a session that I have given before, but it’s a REALLY important topic so I am happy to still be speaking about it. What’s so important, you ask? ISOLATION LEVELS. I really think people don’t realize how much the performance and flat-out correctness of your query results depend on your database’s isolation level. Also, isolation levels matter whether your database is on-premises or in the cloud, so knowledge of this topic will be useful no matter where your environment is located right now or where it is headed in the future.
Locks, Blocks, and Snapshots: Maximizing Database Concurrency
The ability for multiple processes to query and update a database concurrently has long-been a hallmark of database technology, but this feature can be implemented in many ways. This session will explore the different isolation levels supported by SQL Server and Azure SQL Database, why they exist, how they work, how they differ, and how In-Memory OLTP fits in. Demonstrations will also show how different isolation levels can determine not only the performance, but also the result set returned by a query.
Additionally, attendees will learn how to choose the optimal isolation level for a given workload, and see how easy it can be to improve performance by adjusting isolation settings. An understanding of SQL Server’s isolation levels can help relieve bottlenecks that no amount of query tuning or indexing can address – attend this session and gain Senior DBA-level skills on how to maximize your database’s ability to process transactions concurrently.
Registration Is Open!
Registration is open right now, so if you would like to see my session, sign up! There’s an awesome schedule the GroupBy team has put together, and I’m very happy to be a part of it! My webinar begins on 10 October 2019 at 10:00am PDT.
Can’t watch live? That’s no problem at all GroupBy also posts videos of all sessions afterwards. For free. Forever. How cool is that?!?
I hope you have time to tune in and watch either live or after-the-fact. This is going to be awesome!