The goal of the DBA Virtual Group is to provide a PASS community for the DBA. It provides a forum for open discussion and education on issues that face SQL Server database administrators.

The Curious Case of Isolation Levels – sponsored by Dell Software

Wed, Aug 27 2014 12:00 Eastern Daylight Time

RSVP: https://attendee.gotowebinar.com/register/7826922261448314882

The Curious Case of Isolation Levels – sponsored by Dell Software

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 are the ACID properties and how to monitor locks and blocks.


Keith Tate

Keith Tate is a Microsoft Certified Master in SQL Server 2008 and 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.

Interested in Presenting to the DBA VG?

We can always use people to give a talk at one of our bi-monthly events. If you are interested in giving a presentation, please send your title, a brief abstract and a brief bio to Sharon Dooley, dbavolunteer@sqlpass.org.

Want to become a member of the DBA VG Leadership team?

Members of this team moderate meetings and interact with the speakers during the Q&A sessions. Contact Sharon Dooley, dbavolunteer@sqlpass.org if you'd like to become part of the team.

Have a speaker to recommend?

Send the email address of the proposed speaker together with any relevant information about the speaker to Sharon Dooley, dbavolunteer@sqlpass.org.

 

Meeting Recordings

The DBA Virtual Chapter presentations are recorded. On the Meeting Archive page, you will find  .WMV files that can be viewed on-line. Select the event you are interested in, click the Show More button if it is visible, and the recording and any associated files will be visible.

Regular Meeting Schedule

The DBA Virtual Chapter holds two regular webinars each month. The first one is on the second Wednesday at noon, Mountain time and the second one is on the fourth Wednesday at noon, Eastern time. These 1 - 1¼ hour presentations include slides, demos and a time for questions and answers. The meetings are recorded and archived.

 

Follow us on Twitter: @PASS_DBA_VC

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids