SQL Server for Beginners - How Does the Transaction Log Work?!?

@SQLBalls Discusses how the SQL Server Transaction Log works. How VLF's Work and he gives an example of finding transaction log space, understanding that only a log backup will flip status bits in VLF's with no active transactions, a piecemeal restore, and more!

GitHub Repository for the demo scripts:

Here's some additional documentation:
The Transaction Log (SQL Server)

/*******************
/CONNECT WITH US!!
/*******************

Tales from the Field

Bradley Ball

Daniel Taylor

Neeraj Jhaveri

Josh Luedeman

Andrés Padilla