Next Meeting

Thursday,

July

12

Locks, Blocks, and Snapshots: Maximizing Database Concurrency - Bob Pusateri

  • In-Person @ The Motley Fool - 2000 Duke Street Alexandria, Virginia, United States (map)
  • 18:30 - 21:00 Eastern Daylight Time
  • Language: English

** NOTE - we are now meeting in Alexandria VA. We no longer meet at the MTC in Chevy Chase! **



The ability for multiple processes to query and update a database concurrently has long been a hallmark of database technology, but this feature can be implemented in many ways. This session will explore the different isolation levels supported by SQL Server and Azure SQL Database, why they exist, how they work, how they differ, and how In-Memory OLTP fits in. Demonstrations will also show how different isolation levels can determine not only the performance but also the result set returned by a query. Additionally, attendees will learn how to choose the optimal isolation level for a given workload and see how easy it can be to improve performance by adjusting isolation settings. An understanding of SQL Server's isolation levels can help relieve bottlenecks that no amount of query tuning or indexing can address - attend this session and gain Senior DBA-level skills on how to maximize your database's ability to process transactions concurrently.
Prerequisites: This session begins with the very basics of what isolation levels are. A simple understanding of concurrency is helpful but not required
Join us for dinner and a presentation focused on SQL Server technologies and career advancement.

Featured Presentation:

Locks, Blocks, and Snapshots: Maximizing Database Concurrency

Bob Pusateri, Solutions Architect Heraflux Technologies

** NOTE - we are now meeting in Alexandria VA. We no longer meet at the MTC in Chevy Chase! ** The ability for multiple processes to query and update a database concurrently has long been a hallmark of database technology, but this feature can be implemented in many ways. This session will explore the different isolation levels supported by SQL Server and Azure SQL Database, why they exist, how they work, how they differ, and how In-Memory OLTP fits in. Demonstrations will also show how different isolation levels can determine not only the performance but also the result set returned by a query. Additionally, attendees will learn how to choose the optimal isolation level for a given workload and see how easy it can be to improve performance by adjusting isolation settings. An understanding of SQL Server's isolation levels can help relieve bottlenecks that no amount of query tuning or indexing can address - attend this session and gain Senior DBA-level skills on how to maximize your database's ability to process transactions concurrently. Prerequisites: This session begins with the very basics of what isolation levels are. A simple understanding of concurrency is helpful but not required Join us for dinner and a presentation focused on SQL Server technologies and career advancement.

About Bob:
Bob Pusateri is a Microsoft Certified Master, DBA, and systems architect with over 10 years experience on SQL Server. His interests involve internals, performance optimization and cloud technologies. He is an active member of both Chicago-area chapters of PASS, a community speaker, and maintains a web presence through both twitter (@SQLBob) and his blog (bobpusateri.com).

Regular Meeting Details

PASSDC meets the second Thursday of each month at the Motley Fool in Alexandria, Virginia.

Meetings begin at 6:30pm, and typically last around two hours.

Location

The Motley Fool
2000 Duke street
Alexandria, VA
22314

Travel

Metro is your friend; the Motley fool is just a short walk from the King street metro (use the tunnel!).

Note: The building is a secured building and the doors will most likely be locked when you arrive.
We will have someone at the front door to let you in. If you arrive early you will need to wait until 6:30 for us to let you into the building. a phone number you can text for entry between 6:30 pm and 7:30 will be posted on the door.

 

RSVP

 

 

PASSChapterLogo.jpg


Major Sponsors



Capital Personal Computer User Group ( C P C U G )


WaterOx Consulting


sql_micro_sm.gif


GEICO


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