Yep, no heaps allowed without a really good, defensible reason.

Thanks for the notes. I'll update the question, but I don't see GROUP BY xxx WITH CUBE|ROLLUP deprecated. It is noted as backwards compatibility and not ISO standard, but not...

You need a connector. I've seen some for sale, like this one: https://www.cdata.com/kb/articles/ado-ssistask.rst

Encryption is a complex topic. What to write about it depends more on requirements than the features involved. This is really just running functions on data when storing/retreiving, so depending...

Interesting to see this. If there are no NULLs, I wouldn't expect rows to need to move or any page splits. This ought to be a meta data only change.

On my previous laptop, I ran Dev edition for

• 2014
• 2016
• 2017

On this one, I have 2017 and 2019, no issues. In fact, I don't usually install a default instance...

So, I proposed rewriting the client admission and billing pieces into a web app. The proposal was accepted and I led the rewrite. We delivered that some 6 months...

That's a win right there.

I agree. You shouldn't be updating these. The reason is that if you move the server/db to a new time zone, or clients move, they can always determine the actual...

Hopefully they learned something

I think so. I know it gets announced in a few places.

I don't believe you can change from UTC, which is expected. You should use the AT TIME ZONE to convert to local time.

What customization for the time did you have...

The survey gets announced: https://stackoverflow.blog/2020/02/05/the-2020-developer-survey-is-now-open/

A moment of silence, please.

I heard from his family and Mike Vessey, https://www.sqlservercentral.com/author/mvdba, passed away on 25 Jun 2020. I was pleased to meet Mike and host him on...

Sad indeed