Welcome to the Cincinnati Professional Association for SQL Server!

CincyPASS is a professional organization/user group dedicated to all aspects of SQL Server from database administration to application development and business intelligence.

Our meetings occur every month on the 3rd Tuesday, in the Microsoft office located at 4605 Duke Drive, Suite 800, Mason, OH. Please ensure to register to help us plan for food. Unless noted otherwise the monthly meeting agenda will be

  • 6:30 - Welcome and Announcements
  • 6:45 - Featured Presentation
  • 7:45 - Q&A Session / Door Prizes

 

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 (UTC-05:00) Eastern Time (US & Canada)
Your Local Time: Tue, Feb 12 2013 23:00 - 02:00

Where

4605 Duke Drive
Mason, 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