I tried, but I went blind

If I were going to pick a DBA celebrity to have all the answers, I would pick Kendra. I would ask Steve to be...

So what have you tried so far, and where are you stuck?

CTE is like a derived table, so it could, or it could just be a collection of values, like "SELECT 1  as someNum UNION SELECT 2 UNION SELECT 3"

….aaand now I'm wondering what I've screwed up during my tenure. Thanks Joe!

I have never heard of a "tibble", so I googled it. Nothing. Not sure how widespread that term is.

I also tried to google the "problems with old Sybase UPDATE..FROM...WHERE syntax",...

I don't think that's the issue (not exactly), I think you are telling it to update on the aliased table. Try taking the alias off, just say UPDATE Orders SET...

...and every report in your system that your team or any other reporting team has built, to see if they are using those NULL columns. Or, as previously mentioned, blow...

Hahaha, had an upgrade weekend myself. Things went fairly smoothly, other than timing being WAY off from estimated and me validating tables in the back of a bowling alley while...

Sean, you should look into NABBA, really fun brass band organization that has a national competition each year. I used to coach the trombone section for the youth one in...

In your definition of 'a' you've included a line with the summed subtotal, did you intend to do that?

I think the trick is that we're all in the same boat, so stating why you oppose something but knowing that the final decision might be somewhere else is just...

what everyone else said - plus in some of the teams we have a database per change request being done.

one of our teams has almost always over 100...

Very interesting editorial, Kendra. You've mentioned a lot that I've never heard of before, such as SQL Provision or other tooling to mask/de-identify production data. I've never worked anywhere,...

Tonight, I'll be in a theatre orchestra pit for the 5th time this week.  No need for prayers - I need...

Jack's just kinda boring, that's all. It's not "bad", like undrinkable or anything, but it's not interesting either.