Upgrade to 2019 if time is of the essence.

SQL2022 is just around the corner.  So if you can hold off till the end of the year, I would wait and...

Yes this is totally possible, but does require you to have Enterprise edition of SQL Server in play.

You would setup the AG as normal, and set the 3rd node as...

So you will want to do some date math.

You should treat all dates as the ISO standard and to avoid any ambiguity use YYYY-MM-DD formatting when passing dates to SQL.

So...

Do you have a backup?

https://docs.microsoft.com/en-us/sql/t-sql/statements/restore-statements-transact-sql?view=sql-server-ver15

So you want to loop round multiple DB's pulling in the values for the same query from the same table?

If I need to do this in each database (inc system...

There is no import/export for query store data on its own.

Someone did raise this for MS to investigate, you can upvote that here

Export Query Store tables separately from the...

Your sample script you backup the database prior to enabling Query Store, so yes you restore that backup you will have no query store data.

use master 
go
create...

So your referring the the query store data which you have accumulated prior to restoration?

Database  is running happy, collecting query store data.

I restore database with database100

Query store data for database...

Spam filter needs a kick it would seem

You need to use something like Azure AD sync to sync your on-prem AD to Azure AD.

Azure SQL Database can only accept AAD logins or SQL logins.

If the account you...

You cannot hide anything from the SA user or a sysadmin.

You could obfuscate the definitions using the “with encryption” phrase but give any good DBA 2 seconds and they can...

Select partnumber from #stockyes where sourcetype = ‘website’ and stockid = 1

or am I missing something your not detailing in the question?

Your SQL servers should be as far away from public IPs as possible.

Everything should be on a internal private 10 / 172.16 - 172.31 / 192.168 range.

Using named instances is totally supported as replicas.

In relation to the listener only there is no documentation or support as far as I know for using Listener\Instance.  All the documentation...

Is the service running as a domain account?

You could run SSMS as the domain account and login that way instead of using the -m switch.

Then add in your account to...