OK, I must need more caffeine, I totally missed the expected results, try this?

DECLARE @first_date int = CONVERT(int, CONVERT(varchar(8), DATEADD(wk, DATEDIFF(wk, 0, GetDate()) - 4, 0),112));

SELECT...

I'd compute the integer version of the date beginning of 4 weeks ago first, then compare that to the run_date, something like:

DECLARE @first_date int = CONVERT(int,...

you can script the statements to setup compression like this:

SELECT 'ALTER TABLE [' + s.name + '].[' + t.name + '] REBUILD WITH (DATA_COMPRESSION =...

Since the different types of aggregates are a known set of values (MIN, MAX, SUM, AVG) you could do a case statement, but you'd need to ensure that there was...

This kind of stuff always reminds me of the short story "the Machine that Won the War" by Isaac Asimov.  How can we ever get complete enough information for the...

I actually got started in 7th grade at home in BASIC on a TI-994A, and school on an Apple IIe in 8th grade, and BASIC on IBMs in high school.

Yes, it is a part of it.  Here's some articles about the topic:
http://www.tech-coffee.net/alwayson-availability-group-introduction/
https://www.brentozar.com/sql/sql-server-alwayson-availability-groups/
https://msdn.microsoft.com/en-us/library/ff877884.aspx
https://technet.microsoft.com/en-us/library/hh510230(v=sql.110).aspx
I'm sure there's tons more.