Transaction Log – delayed durability and minimally logged operations

Network, learn, ask a question, meet other folks - these are all things that happen at user group events. These events are a really great opportunity to socialise in an informal learning experience.

Remember to tell your friends and the people you work with; make sure you register as soon as you can.

Online event only - Link provided to those who sign up. Not being recorded.

17:45 – 18:00 - Intro and updates

18:00 - 19:00 - Torsten Straus | Transaction Log – delayed durability and minimally logged operations

The ACID rule requires that SQL Server write all data and schema changes synchronously to the transaction log in order to guarantee persistence, which can have a major impact on the performance of the system. In this session we will try to improve the throughput of the SQL Server through minimally logged operations and delayed durability.

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.
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 130 presentations on Microsoft SQL Server performance optimization at national and international conferences and user groups.
Torsten has been recognized as a Microsoft Most Valuable Professional for Data Platform since 2018.