If you have extra spaces, once you substring, you can also use TRIM to clear things out.

First, I'm not an expert here and conservative. When I have doubts, I open a CSS case with MS to work through issues. I'd also immediately restore the oldest backup...

It all depends on your smartwatch. Apple watches need a charge most every day. My wife's Samsung needs it every 2-3 days. Mine has GPS, music via BT, and other...

I'd actually write a job to do this. I'd allow a user to put a name into a table somewhere. I'd have a job that looked in this table, and...

Thanks for the notes and good luck. I think you're on the right track with verify PIT.

Be sure you can do this within your RPO/RTO, and give numbers to the...

So, don't use DNS alias. This is the FQDN as a CNAME or A entry. You have one set for the current server, like

myserver.mydomain.com  192.168.0.111

Users use this to connect, assuming...

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