We talked about this in my software engineering course back in 2001. Surely we can start acting on these finding a quarter century later right? Right?? Joking (I guess?) aside, this really should be taken more seriously.

For the most part it is just soul crushing to constantly be interrupted but people legit die because of software errors due to these kinds of things. You think someone who has 30 minutes free a day to do code reviews for a whole team is going to do a good job, regardless of their intention?

Software is driving cars, flying planes, scheduling trains, pretty much everything in modern life. Yet we are fragmenting our codebases, micromanaging to the point of focus and productivity loss, and to make up for that we are trying to leverage ai tools that were rushed to market. Buckle up folks, we are in for a bumpy ride.

This and justifying the cost of office space are the reasons.

Just because we can do everything in C and Assembly doesn’t mean it is a good idea or that we should.

It makes sense, you aren’t telling sql server how to do something, you just tell it what you want and it figures it out. You aren’t even doing procedural stuff at that point.

I like the RAD tools being qualified as 4GLs as I haven’t really thought of them that way but again it makes sense.

Also screw PowerBuilder. I am sorry if anyone in this thread likes it…but it is seriously awful.

Edit: Before people jump me, I do know that you have some influence over execution plans with join orders, hints, etc… but by and large you don’t tell SQL Server how to do it’s job.