the Query Store for secondary replicas. This feature extends the Query Store functionality from primary replicas to secondary replica workloads.
SQL SERVER – Find Instance Name for Availability Group Listener
How to Find Instance Name for Availability Group Listener? I was recently asked this by DBA at Comprehensive Database Performance Health Check.
SQL SERVER – AlwaysOn and Propagation of Compatibility Level
It is not possible to Propagation of Compatibility Level in AlwaysOn or mirroring from primary to secondary mirroring. Let us learn it today.
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.
SQL SERVER – Unable to Disable Query Store for Always On Database
My clients enabled query store features to perform some troubleshooting which was a cause of unable to disable Query Store for Always On Database.
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.
SQL SERVER – Always On Error: This Database is Encrypted by Database Master Key, You Need to Provide Valid Password When Adding it to the Availability Group
This database is encrypted by the database master key, you need to provide a valid password when adding it to the availability group.