Excellent. Looking forward to it. We'd love more ADF articles, btw.

I've seen a few places report  SET QUOTED IDENTIFIER ON fixed things.

Multiple reports from SQL Agent, but it might apply here.

https://joyfulcraftsmen.com/blog/internal-query-processor-error-debugged/

Does this help? I assume you mean backup files from the database, not VM backups.

https://stackoverflow.com/questions/56903837/delete-files-older-than-x-number-of-days-from-azure-blob-storage-using-azure-fun

Have you run the estimate procedure?

I haven't seen many people saw they do row without page, but I'm sure some have done this. What I'd really do is not compress...

If this is SQL 2019, you can use window functions. This might help you. Your requirement isn't clear. Here is some sample data and a query. Not sure if this...

Are you using the SqlServer module? The older method was importing the sqlps module, which doesn't have these cmdlets.

+1 for what Brian said. Set a max memory. In this case, I'd likely set max memory to 28GB for this machine, which should leave 4. You might also check...

You need EXECUTE permission to execute procedures or functions. If this is in the same database, it's just

GRANT EXECUTE ON dbo.MP_STATIC TO <your user>

If it's in another...

My thoughts: https://voiceofthedba.com/2020/04/06/daily-coping-6-apr-2020/

We aim for narrow articles, with something short to get someone started. This isn't intended to be a long, comprehensive piece. We are definitely interested, and yes, something simple like...

HA/DR

High Availability/ Disaster Recovery

Thanks, Tom, and I'm trying. I have good days and bad ones, struggling at times, but I am trying to cope in different ways.

Always here if you need a chat.

I'd save the logs and scripts for the jobs and recheck when the clocks go back. There I'd expect perhaps a double run. Here, going from 1->2 (or 2-> 3)...

There shouldn't be patching issues. You won't have HA, so patching this is the same as other systems. There are people that always install SQL as a single node cluster,...

You can remove the availability groups - https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/remove-an-availability-group-sql-server?view=sql-server-ver15

You can just also remove the other node and let it run single node.