Next Meeting: Tue, Feb 12 2013
CincyPASS February Meeting
Language: English
Event Type: In-Person
Online Meeting URL: None
RSVPURL: http://cincypass0213.eventbrite.com/
Sponsored by BlueGranite and xSQL Software
When
iCal
UTC : Tue, Feb 12 2013 23:00 - 02:00
Event Time : Tue, Feb 12 2013 18:00 - 21:00 (GMT-05:00) Eastern Time (US & Canada)
Your Local Time: Tue, Feb 12 2013 23:00 - 02:00
Where
7875 Montgomery Rd
Cincinnati, Ohio
Direction: None
Featured Presentation
Locks, Blocks, and Deadlocks
Speaker:
Kyle Neier, Sr. Microsoft Consultant Perpetual Technologies
Summary:
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.
About Kyle:
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.
Attachments
[Attachments]