https://medium.com/ingeniouslysimple/why-did-we-shift-away-from-database-generated-ids-7e0e54a49bb3

In our current journey of building a Data Catalog for SQL Server as a team, we are optimizing our engineering efforts for decoupling. There are some specific reasons why this is very important to us, and fundamentally this boils down to two core principals which I hope every software engineering professional would agree to:

Here is a nice quote from protoactor-go open source project, which I found very accurate to what I am trying to state here: