$300

SQL Server Internals w/Kalen Delaney - Full Day Training on Concurrency

Event Information

Share this event

Date and Time

Location

Location

Instructor Led Online

Refund Policy

Refund Policy

Refunds up to 1 day before event

Event description

Description

Here is your chance to attend training delivered by Kalen Delaney, SQL Server MVP and renowned author of the SQL Server Internals book series.

Kalen’s topic in this online training event will be SQL Server Concurrency: Locking, Blocking and Row Versions

Description:

Prior to SQL Server 2005, SQL Server managed concurrency pessimistically, using locking and blocking to prevent multiple users from updating the same data simultaneously and to provide data consistency. In this training seminar, we will look at the concurrency enhancements made in SQL Server 2005, based on a technology called row-level versioning (RLV) to implement a form of optimistic concurrency. We’ll compare concurrency management with RLV to concurrency management with locking and blocking. RLV allows SQL Server to support Snapshot Isolation so that readers of data are not blocked by writers. This training seminar will provide guidelines as to how to determine which isolation level is appropriate for your needs, and what application changes might be necessary to achieve the level desired. We will also look at the concurrency enhancements added to recent versions of SQL Server. The demos in the seminar will be run on SQL Server 2017, but most of the content will be applicable to any version after SQL Server 2005.

Topics:

  1. Differences between Pessimistic and Optimistic Concurrency in SQL Server
  2. How your application’s transaction management affects concurrency
  3. SQL Server’s locking and blocking behaviors
  4. SQL Server metadata to observe the locking, blocking and row versioning
  5. Differences between the two snapshot based isolation levels: Read Committed Snapshot and Full Snapshot

Prerequisites:

A basic understanding of batches and transactions in SQL Server and some experience writing TSQL-based applications.

What's included:

  1. Live Q&A during the webinar
  2. Downloadable file of all the demonstration files for you to try on your own servers
  3. Access to the recorded webinar videos for review for 1 year
  4. A certificate of completion of the training

Know more about your Instructor:

Kalen Delaney has been working with SQL Server for over 30 years, and provides advanced SQL Server training to organizations around the world. She has been a SQL Server MVP since 1993 and has been writing about SQL Server almost as long. Kalen has spoken at dozens of technical conferences, including every PASS conference in the US and multiple TechEd events in both the US and Europe. Kalen is the author or co-author of many books on SQL Server, the most recent being SQL Server Internals: In-memory OLTP, from Redgate. She is one of the main editors for SQL Server Central’s SQL Server Stairways Series, http://www.sqlservercentral.com/stairway .

Kalen currently works for DB Best Technologies, blogs at https://www.dbbest.com/blog/category/kalens-continuum/and tweets as @sqlqueen. Kalen is on LinkedIn at https://www.linkedin.com/in/kalendelaney .

Share with friends

Date and Time

Location

Instructor Led Online

Refund Policy

Refunds up to 1 day before event

Save This Event

Event Saved