Online Course: SQL Server Locking, Blocking and Row Versions

Five On-Demand Sessions Start on Oct. 11, 2011 and End Nov. 10, 2011

Course Overview

In SSWUG.ORG’s virtual class, you will learn about locking, blocking and row versions, which are some of the most important topics to understanding SQL Server’s internal behavior. By the end of the five sessions, you will know how these technologies are used to manage SQL Server concurrency - the ability of multiple users to access data at the same time.

Kalen Delaney, course instructor and celebrated author of SQL Server 2008 Internals, will start by discussing what consistency might mean to one’s applications, and describe the details of how each of the concurrency models works internally. She will examine the costs and trade-offs between the two concurrency models that SQL Server 2008 supports through different transaction isolation levels.

The target audience of this class is administrators, developers or IT professionals who have some experience with SQL Server Management Studio and TSQL queries, as well as an understanding of basic transactional work processing. Most importantly, students should want to learn more about the way SQL Server works internally and how to take advantage of the inner working to create the best performing system and applications possible.

Session Descriptions

Throughout the 30-day course, you will learn how to:

  • Design an application with concurrency in mind
  • Understand the ways SQL Server manages concurrent user access
  • Spot causes of poor application performance
  • Troubleshoot concurrency problems
  • Recognize the details of both concurrency models – optimistic and pessimistic


Course Structure and Cost

Upon registration and payment, you will receive an email with instructions on how to test your system in order to view the classes, as well as a link that will remain active for the 30 day on-demand period.

The course cost is $169 for full SSWUG.ORG members and $199 for non-members. The cost of the DVD with purchase of the course is an additional $199. The DVD costs $399 if you do not purchase a course seat. Course downloads, office hours and the ability to email questions to the instructor are included with course purchase only.

Once you have completed the course, you will have the opportunity to take a course quiz and receive a course certificate. After passing the quiz, please allow up to five business days after the course is finalized to receive your certificate (.PDF via e-mail).

Event Registration

Rate and Comment
  Confirm Conference Registration Selection
Online Course: SQL Server Locking, Blocking and Row Versions
EVENT is Closed
- Standard Rate: $199.00
High Definition DVD
- Get an additional copy of the video presentations and other     materials on DVD for later viewing. $399.00 
SSWUG Membership
- Receive a 12-Month Membership to SSWUG.ORG to Access Exclusive Content and Save on Future Virtual Classes, Expos and Webcasts. $79.00
Registration Total: $0.00
Rate and Comment
Rate and Comment
  Please Confirm Your Information
Note: no dashes or spaces
We'll email a copy of the receipt to this address.
Card Security Code:  
What's This?
Expiration Date:
We accept Visa, Mastercard, American Express, Diner's Club, Discover

Rate and Comment
Rate and Comment
  Attendee Survey
What is your organization’s size?    
Which industry do you work in?    
Which of these options best summarizes your current job title?    
Rate and Comment
Updating Registration
Submitting Registration

Conference Registration

  • Your registration includes:
    • Access to the virtual event's video content
    • Live, interactive chat with other attendees, speakers and sponsors
    Not sure you can attend on the first day? No problem! All the video content will be available on-demand for 30 days. If you are unable to view all sessions within the 30 days, we can offer a course extension for $79.00.