Dan English's BI Blog

Welcome to my random thoughts in regards to Business Intelligence, databases, and other technologies

Archive for November 14th, 2012

PASSMN November 2012 Meeting

Posted by denglishbi on November 14, 2012

The next Minnesota SQL Server User Group meeting is next Tuesday on November 20.  This month the presentation will be on SQL Server database locking and blocking.  Be sure to register so that your name badge will be available for you at the Microsoft Technology Center when you arrive.Minnesota SQL Server Users Group
The sponsor for this month’s meeting is Dell Compellent.


Location: 3601 West 76th Street, Suite 600 Edina, MN 55437

Date/Time: Tuesday, November 20 from 4 to 5:30 p.m.

Live Meeting:
• URL: https://www.livemeeting.com/cc/usergroups/join?id=8DFJJB&role=attend&pw=Z-%3B%7D*t4%2Cn
• Meeting ID: 8DFJJB
• Entry Code: Z-;}*t4,n


  • 4:00 – 4:10 : Registration / hospitality / networking
  • 4:10 – 4:15 : From our Sponsor – Overview of Dell Compellent SAN
  • 4:15 – 5:15 : Introduction to SQL Server Locking and Blocking
  • 5:15 – 5:30 : Announcements and prize giveaways

Please click here for meeting details and to RSVP for the event 


Introduction to SQL Server Locking and Blocking (Kirby Richter, Dell Compellent)

What is locking?  What is blocking?  Why should you care?  You want to update a million rows on production, you need to know what type of locks will happen so you can plan accordingly!

You are tuning a query and the normal duration is 1 second but recently it’s been taking over a minute.  Is your process being blocked?

Let’s face it blocking is very common and as a good DBA you need to recognize when blocking is an issue and how to deal with it.  This presentation will cover most of the gory details and includes several fun demos.  You will learn how to check and monitor locking and blocking and how to deal with common issues.

And don’t forget, the SQL Lunch that was scheduled for October was rescheduled and will be next month for Friday, December 14 from 11:30 to 1:30 with me as the host – SQLFriends Lunch–Dec 14.

Posted in Training | Tagged: , , | Leave a Comment »