February 27, 2026 at 12:00 am
Comments posted to this topic are about the item Designing SQL Server Pipelines That Are Ready for AI Before You Actually Need AI
February 27, 2026 at 5:30 pm
All your statements are true but then I'm sure you already know that SQL Server has temporal tables, when designed well removes the need for audit tables. I have made a good living modernizing legacy systems to make them more flexible, where the principles you mention hold. However, having Primary Keys be reused I've not seen except in the most simple databases by someone who isn't a SQL developer.
Also, any AI looking system is almost always clarified as "from this point forward." Scoping for need that doesn't exist is a tough sell for almost any company.
February 28, 2026 at 9:06 pm
andre.quitta , I appreciate the thoughtful perspective.
You’re absolutely right that temporal tables can replace traditional audit tables when the requirement is purely row-level version tracking. In many modernized systems, that’s sufficient.
The distinction I was trying to highlight is around cases where historical reconstruction goes beyond row history. For example, when business logic, relationships, or derived states must be reconstructed in context. Temporal tables track data state, but they don’t always capture intent, workflow transitions, or cross-entity dependencies without additional modeling.
On primary key reuse, I agree it should not happen in well-designed systems. The article was intentionally addressing edge cases I’ve encountered in legacy migrations where design assumptions didn’t hold up under scale or schema evolution.
Regarding AI systems being scoped “from this point forward,” that is often how they begin. The challenge I’ve seen is that infrastructure decisions made early can silently limit future retraining, explainability, or compliance needs. My argument was less about over-engineering and more about designing with optionality.
Appreciate you engaging. These kinds of discussions are exactly what move architecture conversations forward.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply