Good software engineering is good software engineering. Technology isn't a panacea if you don't engineer things well. You can pay $$ and hide problems for a bit, but not forever.

Ultimately,...

Certainly learning your existing tools well is important. However, I think you should also be learning new skills and judging when they are useful. That means lots of tests.

For some...

That is an unfortunate bug. Have you submitted this on feedback.azure.com and asked others to vote? I don't know why this breaks, but that seems like something they should fix.

Cu would be what I'd think of. I wouldn't be surprised if MS changed something. There are a lot of updates between those versions:

https://www.sqlservercentral.com/articles/sql-server-2019-build-list

I'd likely use a trigger here, with good error handling to let the user know the issue.

Unfortunately there are no data-mart products or cloud services. Everyone sells a data warehouse and people are loading them constantly

To be fair ..

I find it intensely frustrating that the "no business value" argument is used so liberally.  Pretty soon you end up with a mountain of "No business...

As somebody who ...

In an office setting I wonder how much the lack of printing is a natural progression and how much has been a push from Office and...

I find that occasionally reading a newspaper or book is like CDs or vinyl albums. An immersive experience in my hands. Nothing digital that disappears when a screen times...

Ah, that's cool. Thanks

I always clean-up as I go, this way I do it when I am working on it knowing that I will not have a chance later on. It is...

Steve, you touched a live wire on this one with me.  In my humble opinion ( and you all know how humble I am ), if you don't do...

I'll admit that I am a culprit.  The dev instance looks like the SQL version of a condemned building.  Even PROD can be cleaned up a bit.

A decent project...

Another good reason to clear out unused code is when you have a column that is used to filter results and you find that it can contain a new...

People like Brent who say "don't clean up old code" apparently don't have much experience with 40-50 year old codebases that are still mission critical for more than 18...