Defeat Page Latches by optimising for sequential key and other techniques

Defeat Page Latches by optimising for sequential key and other techniques in Microsoft SQL Server
Concurrent inserts into a clustered table with an ever-increasing key become a bottleneck since Microsoft SQL Server must protect the corresponding pages with a page latch. There are several techniques like, hash partitioning, reserve bits, in-memory OLTP and the feature introduced in 2019 CTP 3.1 called OPTIMIZE_FOR_SEQUENTIAL_KEY. We will compare these features to understand their performance improvements and the effort required to modify your existing application.
Speaker
Torsten (MVP, MCSE, MCT) has been working with Microsoft SQL Server since the turn of the millennium and is specialised in performance optimisation for large SQL Server environments.
He has been with bp as a database engineer for over two decades and collaborates closely with Sarpedon Quality Lab as a Principal Microsoft SQL Server Consultant.
Torsten is the founder of inside-sqlserver.com and has given more than 190 presentations on Microsoft SQL Server performance optimisation at national and international conferences and user groups.
Torsten has been recognised as a Microsoft Most Valuable Professional for Data Platform since 2018.
Hybrid Session
As well as getting back in person, we'll also have a Teams link available. Please answer the question when you register about whether you'll be there in person or remote. The Teams link will be provided closer to the event date.
What Else to Expect?
The chance to network. We plan to incorporate the best parts of SQL Social and the SQL Server Group in our new User Group, so there will be networking time, learning opportunities and introductions to new ideas.
Pizza and Door Prizes
Yes, we'd love to see you back in person if you are comfortable doing so. As a reward, we'll have pizza, maybe more muffins (they were great!) and door prizes for those who come along and join in the networking time.