Next Meeting: Thu, Jun 27 2013
EDMPASS June 2013 Meeting with John Huang
Event Type: In-Person
Online Meeting URL: None
Topic: Locking and Blocking
Speaker: John Huang
5:00 pm - Food and socializing
5:30 pm - Group notice and slides - Harry Zheng
5:45 pm - Feature Presentation - John Huang
8:00 pm - Networking
UTC : Thu, Jun 27 2013 23:00 - 03:00
Event Time : Thu, Jun 27 2013 17:00 - 21:00 Mountain Daylight Time
Your Local Time: Thu, Jun 27 2013 23:00 - 03:00
10303 Jasper Avenue
Canadian Western Bank Place - Canadian Room
Direction: Room 27
Locking and Blocking
John Huang, Principle Consultant SQLNotes.info
Locking and Blocking is one of the most important concepts SQL professionals must know. Understanding it is as important as writing T-SQL and retrieving data from proper indexes. It's powerful that all Transaction Isolation Levels are implemented by locks ONLY (except snapshot related isolation level). With this knowledge, you can explain why your SQL Server behaves like that and also you can tell the preferable locking behavior under different circumstances. Furthermore, It's not the only thing internally used by SQL Server. It's also a tool being exposed to programmers/DBAs since version 7.0 in which it allows you to build your own concurrency controls.
John Huang, SQL MCSM Charter, MCM and MVP, has been working with SQL Server since 1994. He is an independent SQL Server consultant in Vancouver specialized in complex data processing, data warehouse, and performance tuning. He runs SQL PASS chapter in Victoria BC and spoke at TechDays, DevTeach, TechFest, SQL Saturdays, as well as local PASS Chapters.
John Huang, SQL MCM and MVP, has been working with SQL Server since 1994. He is an independent SQL Server consultant in Vancouver specialized in complex data processing, data warehouse, and performance tuning.