What's Happening?

Next Meeting: Fri, May 10 2013

May ABQSQL Meeting

Language: English
Event Type: In-Person
Online Meeting URL: None
RSVPURL: None

May ABQ SQL Meeting

When

iCal
UTC : Fri, May 10 2013 17:30 - 19:00
Event Time : Fri, May 10 2013 11:30 - 13:00 Mountain Daylight Time
Your Local Time: Fri, May 10 2013 17:30 - 19:00

Where

6700 Jefferson Street
Albuquerque , New Mexico

Direction: None

Featured Presentation

Locks, Blocks & Bears Oh My!

Speaker: Keith Tate, DBA

Summary: Have you ever seen or used “WITH (NOLOCK)” in T-SQL? Do you know what it does and its side effects? Is SQL Server optimistic or pessimistic when it comes to locking? Can it be both? In this session we will cover these questions and discuss how and why SQL Server takes locks and how that affects other users. We will go over alternatives for using NOLOCK and discuss when it is appropriate to use. In addition, we will discuss what ACID is and how to monitor locks, blocks and bears (maybe not bears).

About Keith: Keith Tate is a Senior Database Administrator with over 14 years of experience as a data professional. During Keith's professional career he has been a developer, DBA and data architect. Keith is also active in the SQL Server community and is currently the chapter leader of the Albuquerque SQL Server User Group.

Attachments

Please be sure to check out our Meetup.com page, and RSVP there for our monthly meetings.

PASS membership is not a prerequisite to attend this or any other monthly meeting of the Albuquerque SQL Users Group, however, you can enjoy many benefits of being a member by signing up for a FREE PASS membership at http://www.sqlpass.org/.