Background: for decades the water management was handled by local govt, disastrously. Previous govt. (Ardern) fought like hell to wrestle this back to national govt, pushed it through as more systems were found to be on the verge of collapse.
The trumpkins that got elected next rolled this back immediately (“big bad central govt!”) and so now these water systems are collapsing, and the right wing is doing the GOP-style “oh yeah WE are FINALLY going to fix this”. Thanks Luxon you f’ing idiot.
Historically it was targeted at already captive clients building on Windows, so there was no incentive to innovate or break eggs.
This persisted just long enough for the industry to evolve (web & Linux) and create much better solutions, making MS’s dev tools largely irrelevant.
Today, seeing .net in a shop is a red flag for me at least (choosing .net for Web work, to clarify)
I would def use this if there was a return “select …” option. There are heaps of scenarios where sql is modified based on parameters. If no doc string just use the return value maybe?
Our queries are typically large, not 3-5 liners.
(Filter view queries where you might add additional CTA’s to provide the necessary filter conditions, but aren’t desirable if particular filter parameter is nill, etc.)
At the very least, these folks need to have their names permanently attached to this atrocity. These weren’t decisions made by “a corporation” - these people sat across a meeting room table and actually concluded that targeting breast cancer patients was an acceptable means to an end.
Lori A. Beer was the CIO at the time. Now at JP Morgan.
In 2010 WellPoint was found to be automatically targeting insurance policies of women with breast cancer for cancellation, using any pretext. Angela Braly was the CEO at the time, now at ExxonMobile. WellPoint was the second largest health insurer in the US at the time.
This required a lot of business analysis and software development - and people had to realize what this code was doing. I’m guessing bonuses were paid on the back of the “savings” this generated.