John started programming with SQL Server in 1994. He has been involved into many implementations of large scale database applications and data warehouse projects. While he was a lead of a small database team in National Money Mart Company, he automated majority DBA tasks over a very complex distributed SQL Server system with almost 1000 instances involved. As an SQL Server expert, he successfully passed Microsoft Certified Master of SQL Server at beginning of year 2009 and became to the first Certified Master of SQL Server outside Microsoft in Canada. Now he is an independent SQL Server consultant specialized in performance tuning, database design, large volume data processing, and troubleshooting. He spoke at SQL PASS local chapter, TechDays, and SQL Saturdays in Vancouver, Toronto, and Seattle.

Concurrency is one of the most important things to be seriously considered while designing a complex database system. Fully understanding different level of concurrency control is the key to make your design success. Most of SQL Server internal concurrency controls are implemented through locks. We can utilized the same mechanism to customize the concurrency control for your processes. I am going to cover all of these during the session. At the end, we will talk about concurrency control with combination of different components of SQL Server.