SEQUENCE vs IDENTITY in SQL Server: Choosing the Right Auto-Increment

TL;DR Pick the wrong auto-increment strategy in SQL Server and you find out in production....