https://docs.microsoft.com/en-us/sql/t-sql/statements/create-columnstore-index-transact-sql?view=sql-server-ver15

If the hardware is not the same, the same settings might not be correct. I would baseline a workload, with expected timings and then re-run that, being ready to tune...

I'd be curious about which two products and why can't 1 do both. Not questioning your situation, but just trying to understand.

For your question, I've only run into this with...

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...