An Outbox for 3 Million Events a Day on Azure SQL: the Engineering Behind It

The Transactional Outbox pattern fits in a thirty-second diagram: write the event in the same transaction as the business data, and let a worker publish it later. Everyone draws that in the first meeting and goes home happy. What nobody draws is the second half: that table becomes the hottest structure in your database. It takes an insert, an...