June 19th – Hash and Non-Clustered In-Memory OLTP Indexes in Azure SQL as presented by Torsten Strauss

Welcome to the June 19th PST/June 20th CEST, 2024 HYBRID meeting!

We are once again meeting in person in Vancouver, WA at the downtown Umpqua Bank in their Community Room!

We meet on the 3rd Wednesday of the month once again at 6:00 PM PST.  We will have snacks and networking before the main meeting.

But… we will continue to operate monthly online meetings through the PNW collaborative facilitated by the Oregon Data Community.  Due to this, you will be able to attend the meeting remotely and we are definitely open to remote speakers.

Please Register at Meetup!!!

https://www.meetup.com/oregonsql/events/301479759

In order to encourage questions during the presentation, please use chat which will be monitored and/or use the raise hands option in Teams.  Please be mindful of the other attendees and mute your mic!

We will be starting at 6:00 PM PST/3:00 AM CEST

Schedule: (may be fluid due to discussions and Q/A):
6:00 – 6:30 PM – Snacks/Announcements/Networking
6:30 PM – Presentation

8:30 PM – Happy Hour/Networking (Shanahans in Vancouver)

 

Presentation:

Title: Hash and Non-Clustered In-Memory OLTP Indexes in Azure SQL

Abstract:

Microsoft provides two fundamentally different index types in the in-memory OLTP engine. In this session, we will focus on the differences between the hashed and non-clustered in-memory index types and in which scenario which index should be preferred. We will also look at the structure of both index types to better understand the differences, limitations, and advantages.

Bio:

Torsten (MVP, MCSE, MCT) has been working with Microsoft SQL Server since the turn of the millennium and is specialized in performance optimization for large SQL Server environments and database development.
He has been with bp as a database engineer for over two decades and has given more than 200 presentations at national and international conferences and user groups.
Torsten has been recognized as a Microsoft Most Valuable Professional for Data Platform since 2018.

Posted in Announcements | Leave a comment