What you want to do is possible with a Windows Stretch Cluster or with two Windows Clusters.

If you have Enterprise Edition with Software Assurance  you may be able to do...

You sould get a check-list together of the tasks you need to do.  The following is suggested as a starting point, but you are the person who knows your site,...

You will need some form of EBCDIC collation to make SQL sort in the same way as IBM.

The standard collations used by Windows, Linux, and SQL Server have numbers before...

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