On Feb 22nd I'll have been a data pro for 30 years. It's been a great and exciting career and will be for about another 15 years, learning new technology...

A rollback in Production is a failure. A rollback in a sub-Prod environment is a success. You've used your environments to find an issue that would have burned you in...

I think this is totally normal in software development. You put out features that Product / BA thinks users will like or have requested, only to find out that scant...

I believe this will take less than a decade to begin to eliminate some DBA positions, but not all... there will always need to be some level of human admin....

Thanks Andy, good info. Pardon my ignorance, but what does "C level audience" and "C suite" mean? Client/Customer?

I've been in IT for almost 30 years now and I've rarely seen bias like everyone talks about. Every time I say that people say well that's because you're a...

Although the STUFF command was brazenly missing from the code (LOL), this is a very valuable piece of code we use on a regular basis to get a comma delimited...

Microsoft is pricing themselves out of the market. My company is moving off it in favor of PostgreSQL. Sadness.

Best question I've seen in a while. Thanks.

Deferred Name Resolution is an awful "feature". At the very least it should be optional/configurable. I want to always know that my proc is being compiled referencing a table that...

Yeah that was a good one... have never contemplated dropping the only column in a table. Interesting to see the error.

Excellent question. Never really thought about using option 2 before now.

How do you write a question, and get your own answer wrong? Simply amazing.

LOL, now this is a first in my many years here! Got it wrong by picking the other right answer (namespace).

Always nice to learn something new - good question. And Mighty's example code a few posts ago is just as interesting.