Next Meeting: Tue, Feb 12 2013
CincyPASS February Meeting
Event Type: In-Person
Online Meeting URL: None
Sponsored by BlueGranite and xSQL Software
UTC : Tue, Feb 12 2013 23:00 - 02:00
Event Time : Tue, Feb 12 2013 18:00 - 21:00 (UTC-05:00) Eastern Time (US & Canada)
Your Local Time: Tue, Feb 12 2013 23:00 - 02:00
4445 W Lake Forest Drive
Blue Ash, Ohio
Locks, Blocks, and Deadlocks
Kyle Neier, Sr. Microsoft Consultant Perpetual Technologies
These terms seem to be thrown around all the time – but what do they all mean? In this session we’ll explore the different isolation levels in SQL Server and how they affect the way that blocking and locking behave within the database engine. We’ll dive into the most common locks and how they can be leveraged and avoided to improve your application experience. Once locks are explored, we’ll discuss the dreaded deadlock and explore techniques to detect and mitigate this troublemaker in your environment.
Kyle has been working professionally with computers since 1995, the past 10 years being dedicated to SQL Server. He currently works as a Sr. Microsoft Consultant for Perpetual Technologies (PTI.net) where he continues to chase his passion to automate DBA processes. He is a proud father of 5, a leader of the local PASS chapter (www.indypass.org), a Microsoft Certified Master (MCM), and enjoys sharing his passion for SQL Server with others by speaking and mentoring at local and regional events.