SQL Server 2022 extends the Query Store feature for secondary replicas. Here is how to enable it and what to watch before using it.
Read-Only Routing for Availability Group Replicas
Configure availability group read-only routing, listener connections, replica URLs, balanced lists, and verification after failover.
SQL SERVER – Find Instance Name for Availability Group Listener
An Availability Group Listener identifies a connection endpoint rather than a separate engine instance. I query where this connection actually arrived.
SQL SERVER – Availability Groups Can Propagate Database Compatibility Level
Propagation of Compatibility Level needs verification on the actual availability-group topology. I compare each replica through its own connection.
What is Transactional Replication Supported Version Matrix? – Interview Question of the Week #274
Question: What is the Transactional Replication Supported Version Matrix?
The rules for the supported versions are pretty simple and clearly written.
Disable Query Store on an Always On Database: What Blocks It
To disable Query Store on an Always On database, run ALTER DATABASE with QUERY_STORE = OFF, and try OFF (FORCED) when the statement waits. This post shows the states to read, the background commands that block the statement and the steps used on an Always On database. It marks which parts were tested on a single server and which come from a client case.
SQL SERVER – LogonUserExEx Fails for User & GetToken – Logging on as the CNO Failed With Error 1326
In this blog I would share my learning about fixing error LogonUserExEx fails for user & GetToken – Logging on as the CNO failed with error 1326.