22-25 April 2026 
Transaction Log Internals, unplugged
Proposed session for SQLBits 2026TL; DR
In this unscripted session we'll dig into transaction log internals, how SQL Server uses the logs and why things go wrong, all based on your questions
Session Details
Ever wondered how SQL Server uses the transaction log? Or how the log looks internally? Or why Change Data Capture prevents log reuse?
This is your opportunity to find out. This session will have no presentation, no fixed content, no rehearsed delivery.
Just a drawing app, a pen and your questions. Bring it on!
This is your opportunity to find out. This session will have no presentation, no fixed content, no rehearsed delivery.
Just a drawing app, a pen and your questions. Bring it on!
3 things you'll get out of this session
Answers to their questions on how the transaction log is structured
Answers to their questions on how the transaction log is used
Answers to their questions on problems involving the transaction log
Speakers
Gail Shaw's other proposed sessions for 2026
All about Indexes - Part 1 - 2026
All about Indexes - Part 2 - 2026
Identifying the worst performing queries in a DB, with Query Store - 2026
KQL for the SQL Professional - 2026
On Transactions and Atomic Operations - 2026
Parameter Sniffing vs Parameter Sensitive Plan Optimization - 2026