Your server spec looks big for your data volumes.

You will be moving to latest hardware (or thereabouts) so for 300GB data 4 cores with 64gb memory should be ample.  However,...

Have you checked the SQL Error Logs for the update and subsequent restart attempts?  If your instance had a problem while in Script Update mode you could get similar symptoms...

I have not checked this situation, but a similar situation exists when a SQL Cluster is configured for multi subnets.

Have you checked the Windows Cluster dependency list for the AG...

Back around 2014, my then employer was putting a case together to move from the last SQL2005 servers.  The thing that clinched it was reliability.

We worked out we might get...

I have hardly ever used SSIS, but have seen it used extensively by others.  Like any tool, if you get to know it then you know what can be done...

Personally I think 22 small to medium size databases is not a large number.  220 starts to be a large number, but it all depends on the resources on the...

One of the few things to do with computing that has not seen multiple order-of-magnitude reductions in cost over the past 40 years is application development.  This has always been...

PowerBI Server on prem is best thought of as a replacement for Reporting Services.  It can replace SSRS on all versions from SQL 2008 onwards.

The PBI install will give you...

I know you have a tough job here, but upgrading in place is like playing Russian Roulette.  Eventually you will try an upgrade that corrupts your instance so it won't...

If you have not already done so this is something you should escalate to your management.

If you are based in the EU then this level of access puts you in...

If you are convinced that one of your cluster nodes is not fit for use, you should look at the safest way to decommission it, and also how you will...

Ever since SQL on Linux was announced I have thought that Windows is on a declining path.

The final hurdle for many organisations will be a native Linux version of AD. ...

Sync v async...  What do your SLAs say. 

Is minimising failover time more important than minimising query performance.  Is your network up to supporting sync replication, which means...

Each option has advantages and disadvantages, You need to choose what is best for you.

Both options cost the same.  If you run in A/P mode the licensing is...

I think you made the right choice.  Using DNS aliases in the connection string gives stabilityof the connection string wherever the alias is pointing.
In your situation you obviously have...