Name: Locks, Blocks, and Snapshots: Maximizing Database Concurrency ~ Bob Pusateri
Start: 2018-12-12T18:00:00-05:00
End: 2018-12-12T21:00:00-05:00
Location: Microsoft

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.

Speaker:

Bob Pusateri is a Microsoft Certified Master with over fifteen years of experience working with database systems. A Solutions Architect at Heraflux Technologies, his areas of expertise are performance tuning, database architecture, and VLDBs (Very Large Databases) in Microsoft SQL Server. When not in front of a computer, Bob loves enjoying the outdoors with his young family. You can read his blog at bobpusateri.com, and reach him on Twitter at @SQLBob.

Bob frequently speaks at technology-related events, including the PASS Summit, SQL Saturday events, PASS virtual chapter webinars, and SQL Server User Groups.

Vladimir Ivanovich

John Moore

Taiob Ali

New England SQL Server User Group

Azure Data Tech Groups

Thank you to Centric Consulting for the annual Sponsorship!

Centric Consulting

Technology

Business Intelligence

Data Mining

Data Science

Data Management

Big Data

Database Professionals

Database Development

SQL Server

SQL Azure

Data

Business Intelligence & Data Warehousing

Software Development

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

Microsoft

Share

New England SQL Server User Group

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

New England SQL Server User Group

Details

Sponsors

Members are also interested in