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

I tend to do this, mostly because replication is fragile and it's often easier to rebuild than fix something that's broken.

Ah, that's a parenthesis, but thanks for the catch.

I see brackets at [], braces as {} and parens as ()