What Erland said

The popular list here notes Azure VMs and storage are things people need to learn about. I'd agree with this. There is plenty to troubleshoot in the cloud

https://docs.microsoft.com/en-us/learn/?WT.mc_id=nurture3_control_l1_home-email-learn

Thanks for the research. That matches what I see.

GROUP BY ALL is specifically on the deprecation list for 2016/2019, and noted on the GROUP BY page. The WITH xxx syntax...

You cannot pin tables into RAM. That was removed because of issues with the process many versions ago.

You can look at in-memory tables, but this is a big, disruptive change,...

I'd go with Jeff's idea, if that works for you. A simpler import, in my mind.

I don't believe this is the case. You can install SSRS on a machine without SQL Server, but I don't think you can upgrade just SSRS separately from an instance.

I...

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