Las Cruces & El Paso SQL Server Users Group

We will update meetings with slides and attachments as the presenters make them available.

Next Meeting

Thursday,

October

09

LCEP SSUG Oct 2014 Meeting "The Curious Case of Isolation Levels" w/ SQL MCM - Keith Tate

  • In-Person @ 1625 Hawkins Blvd. El Paso, TX El Paso, Texas, United States (map)
  • 12:00 - 13:00 Mountain Daylight Time
  • Language: English

The Las Cruces-El Paso SQL Server User Group (LCEP) will be having a Special Presentation at its next meeting, Thursday 10/09/14 from 12:00 PM - 1:00 PM at the New “New Horizons Center” at 1625 Hawkins Blvd. El Paso, TX 79925 Microsoft SQL Server Certified Master, Keith Tate will be joining us in-person to share his knowledge.  Join us for his presentation “The Curious Case of Isolation Levels”, and learn how and why SQL Server takes locks and how that affects other users. Ask Keith questions, get to know your peers, may be win a prize and have lunch on us!

Attend this FREE SQL training event!

RSVP and be eligible to win a copy of Randall Root’s "Pro SQL Server 2012 BI Solutions""

 

Sign up for your free PASS membership at: http://www.sqlpass.org/ 

LCEP SSUG SPONSORS 

New HorizonsThe IT Training Leader: New Horizons El Paso delivers a full range of technology and business skills training

Red Gate - Simple tools for DBA's & developers.  The Leader for SQL and .NET tools.  If you haven't already

Plural Sight – Excellent Online Training. Check them out, we’ve watched some of their sessions on Team Foundations Server and they were very useful.

O’Reilly – User group members save 40% off print and 50% off ebooks.Discount Code:DSUG

Featured Presentation:

The Curious Case of Isolation Levels

Keith Tate, Senior Database Administrator

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.

About Keith:
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

Supplementary Materials

The following event attachments are available to you:

EventArchive

Meeting Archive

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