Spring SQLIntersection, Orlando–Randy Knight

Randy Knight, president and founder of SQL Solutions Group, and a Microsoft Certified Master, was a featured speaker at the spring SQLIntersection event (part of DEVIntersection) in Orlando, Florida. The event was April 19-21, with pre- and post-conference workshops April 16-18 and on April 22.

Randy’s sessions were:

Locks, Blocks, and Deadlocks, Oh My!

Managing concurrency is one of the most challenging aspects of working with any enterprise DBMS. Too many issues that manifest as performance issues are in fact concurrency management issues. There is much confusion out there about locks, blocks, and deadlocks. In this demo heavy session we will clear up the confusion.

Understanding Transaction Isolation Levels

SQL Server offers several isolation levels beyond the default “READ COMMITTED”. But understanding when to use each one can be daunting. Whether you are a developer who needs to understand how isolation works and why NOLOCK is not an appropriate directive in most cases, or a seasoned DBA who needs to understand the less commonly used isolation methods, this session is for you. We will look at each level, how it impacts the engine, and examines appropriate (and inappropriate) use cases for each. We’ll also take a brief look at the In-Memory OLTP feature introduced in SQL 2014 and greatly enhanced in 2016 and how that fits into the mix.

Get all the event details and register on the DEVIntersection website.

 
 
Loading Map....

Date/Time
Date(s) - 04/16/2016 - 04/22/2016
9:00 AM - 6:00 PM

Location
Walt Disney World Swan

Categories No Categories