It's often a SAN driver/hardware/etc that can cause this, but it could be memory module issues, so movement of the VM an be a pain to diagnose. Get the SAN...

You can't dynamically join all <db name>.sys.database_files for all databases with master.sys.master_files. You can join for a particular db and easily get the sizes that way.

If you want to try...

In a SELECT, there is no late binding of columns. You have to use dynamic SQL, as Phil noted, but there are all sorts of security problems here. You are...

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