Next Meetup

Locks, Blocks, and Snapshots: Maximizing Database Concurrency - Bob Pusateri
** 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.

The Motley Fool

2000 Duke street · Alexandria, VA

What we're about

Washington, DC Official PASS Chapter.

**NOTE** We have changed location!!

We meet 2nd Thursdays in the Foolitorium at The Motley Fool (,-77.0640748,19.25z/data=!4m5!3m4!1s0x0:0x4fe56d8822bd332e!8m2!3d38.8042271!4d-77.0639909) in Alexandria (2000 Duke St, Alexandria, VA 22314)

Nearest metro: Yellow Line King street station (,+King+Street,+Alexandria,+VA/Motley+Fool,+2000+Duke+St,+Alexandria,+VA+22314/@38.8057397,-77.0630941,18z/data=!3m1!4b1!4m14!4m13!1m5!1m1!1s0x89b7b1aa40892405:0xaa46abc01e2c0755!2m2!1d-77.0600084!2d38.8072485!1m5!1m1!1s0x89b7b1a9a1e78f2d:0x4fe56d8822bd332e!2m2!1d-77.0639911!2d38.8042267!3e2) - about 2 blocks away (5 minute walk)

Nearest parking: On street (if you can find it), at the Metro station or there is a Pay garage about 10 minute walk away at the Hoffman Town Center (,-77.0699869/Motley+Fool,+2000+Duke+St,+Alexandria,+VA+22314/@38.8035949,-77.0678864,18z/data=!3m1!4b1!4m9!4m8!1m0!1m5!1m1!1s0x89b7b1a9a1e78f2d:0x4fe56d8822bd332e!2m2!1d-77.0639911!2d38.8042267!3e2) (Mandeville Ln, Alexandria, VA 22314)

(walking maps provided in links above)

We hope you can join us for a night of socializing with other SQL Server users and learning SQL Server concepts!

Members (601)

Photos (38)