Heraflux is a proud supporter of technical and business community events all over the world.

Loading Events

« All Events

  • This event has passed.

SQL Saturday Madison 2018

April 7, 2018 @ 8:00 am - 5:00 pm

Free

Heraflux is proud to announce that Bob Pusateri will be presenting at this year’s SQL Saturday in Madison WI on Saturday, April 7, at the Pyle Center. His session is entitled “Locks, Blocks, and Snapshots: Maximizing Database Concurrency.”

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

Details

Date:
April 7, 2018
Time:
8:00 am - 5:00 pm
Cost:
Free
Event Categories:
,
Event Tags:
Website:
http://www.sqlsaturday.com/724/eventhome.aspx

Organizer

MadPASS
Website:
http://www.madpass.org/

Venue

The Pyle Center, University of Wisconsin-Extension
702 Langdon Street
Madison, WI 53706 United States
+ Google Map