I would prefer to always store time in utc, but that doesn't mean I don't need separate application and server times depending on what I'm doing. Storing the ui timezone...

Personally I would be more worried when a new query shows up, as opposed to similar queries being repeated. One solution to this could be banning ad-hoc queries completely and...

Just because a dataset is immutable doesn't mean we can't amend it when looked at.

I don't have an issue with reserving space for updates. Provided the space consumed remains constant(not counting user data) over the lifetime of the product no matter how many mandatory...

I think it's just as likely that management risks becoming dependant of having an individual with this valuable skillset on the team. Replacing them may not be something they see...

If we compare it to a medical scribe, a data scribe would be someone doing data entry as a replacement for an automated integration between two or more systems(one of...

Maybe I'm missing something regarding the backup example. But I would expect the right to be forgotten to include being removed from backups.

I expect we'll get a tool that puts the semicolons in place to upgrade old sql automatically. The remaining issue then would be any dynamic queries left, which in a...

I think a key component in making this feasible is to stop designing systems to achieve a result and instead have them model a process accurately. It would mean we'd...

Personally I've never had comments be of any use when fixing a system, they're either out of date, wrong, a combination of both, or in rare cases they're actually accurate...

I prefer to use views over stored procedures when retrieving data. Number of returned rows, simple filters and sorting belongs outside the data-storage/validation realm in my opinion. That said, I...

Saying using source control doesn't make you a better developer might be a bit conservative. Since it does enable you to quickly review your edits in a way that would...