Eight capabilities we have run in production — from the schema underneath to the server it runs on.
Services
More
Insights
Things we learned the expensive way, written down so the next person does not have to. Mostly databases, mostly at three in the morning.
Msg 5074 and Msg 4922 are not obstacles to route around. They are the database telling you it knows about a dependency you had forgotten.
STRING_AGG has existed since 2017. That is no help at all when the server in front of you is running 2014 and is not going to be upgraded this quarter.
Every bespoke platform reaches a moment where the fastest way to satisfy a client is to copy the codebase. That decision is where products go to die.
We would rather talk about the specifics than write another general post.