I think it's actually worse than you say. If you look at some of the horrendous problems on CONNECT that occurred with 2012 and the continuing lack of attention to detail in preserving functionality even in SSMS, it would seem that MS has come to using SPs and CUs as a crutch for poor programming practices, inadequate testing, and a lack of good source control.
Don't get me wrong. I think that SQL Server is one of the best RDBMSs in the world but, if MS would start doing things right, it could be the best. Not sure that's possible in the next 10 years, though, because of all the technical debt they've built up by postponing fixes and releasing partial functionality like that damned PIVOT function and, up to 2012, the horrible job they did on the Windowed Functions and (especially) the related aggregates.
And then there's the "cloud". Good grief.
is pronounced "ree-bar
" and is a "Modenism
" for R
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
"If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
"Change is inevitable... change for the better is not."
When you put the right degree of spin on it, the number 3|8
is also a glyph that describes the nature of a DBAs job. 😉
How to post code problems
Create a Tally Function (fnTally)