I think you are on the right track. It is a number of years since I set my AOAG up but looking through my notes and at the current setting...

I have just tried a restore from SQL 2005, SQL 2008R2 and SQL 2012 Enterprise to a SQL 2017 Enterprise server with no issues so it should be possible.

Someone hasn't put entries in the local hosts file on the server have they? We use that sometimes to override DNS when we want to do testing without affecting anything...

Good spot. I have the same messages in the Application area in the Event Viewer on the 2016 Dev server that I upgraded yesterday.

When I compare the...

Does anyone know how GDPR applies to EU citizens when they are overseas? 

I work for a local government organisation and our country is popular with people from the...

Thanks very much for your response.
OS is Windows 2012 R2,
SQL as mentioned earlier is SQL 2016 Enterprise with SP1 and CU3. 
Min Max currently set to...

I feel very inadequate! My smallest two have 1GB and 1 vCPU each and run SQL 2005. They performed OK in their day but have only been kept around while an...

"Available MBytes
....
This counter cannot be queried through T-SQL; it has to be observed through Perfmon only."

Can't you use sys.dm_os_sys_memory to pick that up?

...

Not sure what it would be classified as but the email I received from the Microsoft engineer said that he had raised an RFC with the product team.

We...

Thanks for your response. I raised a call with Microsoft and this looks like it is actually an issue in SQL 2016. We have changed the service account that is...

On a related note, there seems to be a security loop hole if the owner of the database is a member of the sysadmin group and TRUSTWORTHY gets set to...

This might give you better information because it breaks it down by database:

SELECT
ar.replica_server_name,
adc.database_name,
ag.name AS ag_name,
drs.is_local,
CASE WHEN hags.primary_replica = ar.replica_server_name THEN 1...