The goal of the DBA Virtual Chapter 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.
Next Meeting

Wed, Aug 27 2014 12:00 Eastern Daylight Time


The Curious Case of Isolation Levels – sponsored by Dell Software

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 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.

The DBA Virtual Chapter presentations are recorded. On the Meeting Archive page, you will find  .WMV files that can be viewed on-line.

Interested in Presenting to the DBA VC?

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.

Future Meetings

September 10 Noon Mountain Patrick Akhamie Transaction Log file management (SQL Server 2008r2 – 2012)

September 24 Noon Eastern Sreeni Julakanti SQL Server Statistics