Transaction Modes in SQL Server

In the following video, I take a look at the three most important transaction modes in SQL Server: autocommit, explicit transactions, and implicit transactions. Sorry, batch-scoped transactions, but nobody loves you. https://youtu.be/D3sPycbiQR8 If you'd prefer a textual rendering of the video, here are the pre-demo and post-demo sections, lightly edited for narrative flow. Setting the…