Name: Locks, Blocks, and Snapshots: Maximizing Database Concurrency - Bob Pusateri
Start: 2023-12-13T17:30:00-08:00
End: 2023-12-13T19:30:00-08:00

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

Agenda:
5:30 PM - 5:45 PM Networking & User Group updates
5:45 PM - 6:00 PM Sponsor Spotlight & Speaker Introduction
6:00 PM - 7:00 PM Featured presentation
7:00 PM - 7:30 PM Q&A and continued networking

We'd love to keep in touch! Visit https://www.redmondsql.org/membership-registration/ to join our user group to get access to free learning content.

Looking for the presentation from a previous monthly meeting? Visit our meeting archive: https://www.redmondsql.org/archives/.

Cheers,

Redmond SQL User Group Leadership Team
https://www.redmondsql.org

Harry Chandra

Tho H. Le

Redmond SQL User Group for SQL Server & Data Professionals

Azure Data Tech Groups

Technology

Database Professionals

SQL Server

Data Management

Business Intelligence

Hadoop

Big Data

Database Development

Data Analytics

Data Visualization

SQL Integration Services

Business Intelligence Tools

SQL Azure

Business Intelligence & Data Warehousing

Apache Spark

Bob Pusateri is a Microsoft Data Platform MVP, Microsoft Certified Master, DBA, and systems architect with over 15 years experience on SQL Server. His interests involve internals, performance optimization, and cloud technologies. He is very active in the Chicago data platform community, and a frequent speaker at local, national, and international events.

Bob Pusateri

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

Online event

Share

Redmond SQL User Group for SQL Server & Data Professionals

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

Redmond SQL User Group for SQL Server & Data Professionals

Details

Members are also interested in