An Availabilty Group requires WSFC. It does not require a Failover Clustered Instance (FCI), which is a SQL Server cluster.

https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/failover-clustering-and-always-on-availability-groups-sql-server

Log shipping uses log backups. That's it. A full is required (or full+diff) to get the system setup, but log shipping moves transaction log backups to the secondary and restores...

I believe this is the regular network name. You can have DNS point here later, but this should just be SQL01 if the DNS would be SQL01.mydomain.com

I might also suggest that some of your CTEs might be better combined, returning more results, with the column(s) from the WHERE included. Not sure, but definitely need more information...

I would say Windows as the SQL AG story is more mature. Things should work fine on Linux, but I tend to avoid v1 versions of things like HA.

How's this:

WITH myCTE (u, entries, complete)
AS
(
SELECT u = ,
     Entries = 1,
   Complete =  CASE
       WHEN event1...

I like Steve's solution. I'd be tempted to make a permanent table that tracks capacity by time (and potentially by machine/location/etc). Then use that as a way of performing calculations.

Try this: https://www.sqlskills.com/blogs/kimberly/how-can-you-tell-if-an-index-is-really-a-duplicate/

This is Steve's Benevolent Dictatorship Principle

Shameless promo 2: SQL in the City commercial from the ranch this past weekend: https://www.youtube.com/watch?v=Fyg1xpUy1Kw&feature=youtu.be

Shameless self promotion 1 - Interviewed in Ch 9 with ReadyRoll: https://channel9.msdn.com/Shows/Visual-Studio-Toolbox/Database-DevOps-with-RedGate-ReadyRoll

I don't like to remove or censor posts, but let's leave the political stuff out of here. You can comment on data, but no comments or debate on whether political...