SQL Server Always On AG – Is a Passive Secondary Required for Automatic Failover?

It is my understanding that for automatic failover to occur in an Always On AG environment, the replicas just need to be configured with "automatic failover," "synchronous commit" and the environment must have proper quorum (i.e. odd number of voting members).

However, according to the "SQL Server 2019 Always On" textbook by Peter A. Carter, for automatic failover to work, the secondary cannot be active and must be passive. Passive meaning the Readable Secondary setting is set to ‘No’ so it is unavailable for direct connections or read access, and obviously no backups can be done on them either.

Here is the exact statement from the textbook:

"Although we can change the value of Readable Secondary through the GUI while at the same time configuring a replica for automatic failover without error, this is simply a quirk of the wizard. In fact, the replica is not accessible since active secondaries are not supported when configured for automatic failover."

Here’s a screenshot of the "quirk"

enter image description here

Note: According to the textbox, the Readonly Secondary should be set to ‘No’ if you want automatic failover to work. Thinking back, I don’t recall a successful automatic failover occurring with this set up and I believe when an issue occurred, the AG was in a RESOLVING state. Note, we have third server for proper quorum.

I’ve searched through Microsoft’s documentation to confirm whether or not the author’s statement is true but have yet to find anything that explicitly states that the secondary replica must be passive for automatic failover to work. This Microsoft article (Failover and Failover Modes (Always On Availability Groups)) states the conditions required for automatic failover but does not mention needing a passive secondary replica.

So is the author correct and Microsoft has failed to advertise this OR is the author incorrect and automatic failover does work when the secondary replica is active/readable? My objective is to have a highly available environment with automatic failover but do we need to sacrifice offloading read operations in order to accomplish this? Adding another server is not an option.

How to deal with players that wants their characters to do automatic perception, stealth and searching for traps/secret doors?

Every time my players are exploring a dungeon, they want their characters to do perception checks for monsters, perception checks for traps and/or secret passages while being on stealth mode, all at the same time. If a monster comes or if they activate a trap, they get mad because “my character is always looking for traps”. If I say they need to declare their actions, the game goes like this:

[me describing a area, like a corridor they’re walking in]

player: I check for traps and secret doors in the wall, the floor and the ceiling. I also want to hear anything unusual and walk silently.

They want to be on “automatic mode”, expecting me to roll for their PCs every time they enter a new area. Otherwise they always have this phrase “I check for traps and secret doors in the wall, the floor…” that they say EVERYTIME I introduce a new area. I can’t put them in “automatic” for this kind of roll. We’re playing D&D 5e, but this happen in other campaigns, and it has always been a problem to me.

How do I deal with it?

Automatic Method for FindMinimum with constraints

What is the default method used by FindMinimum with constraints?

The documentation says-"Currently, the only method available for constrained optimization is the interior point algorithm"

But a random example gives different results for the Method->Automatic and Method->"InteriorPoints"

Reap[FindMinimum[{x^2 + y^2, (x - 1)^2 + 2 (y - 1)^2 > 5}, {{x,  4}, {y, 4}}, Method -> Automatic,StepMonitor :> Sow[{x^2 + y^2, x, y}]]]  Reap[FindMinimum[{x^2 + y^2, (x - 1)^2 + 2 (y - 1)^2 > 5}, {{x,      4}, {y, 4}}, Method -> "InteriorPoint",    StepMonitor :> Sow[{x^2 + y^2, x, y}]]] 

The above code yields the same final solution. But the steps taken are different for both, which suggests that the interior points is not used as the automatic one.

The same question has been asked here and here

So what is the exact method being used when Method->Automatic is specified?

Plugin or standalone script for wordpress automatic generate passwords for admin users with 24h regenerate

I have clean wordpress installation with one admin user. I want some script or plugin with autogenerate passwords for WordPress’s admin and sent automatically to email notification. Is possible? Example : i have user’s admin with password ‘test’ – i want generate random passwords for this admin once at 24h and send automatically thsi fact to email.

GSA Proxy Scraper Automatic Export Filter by Type

Hello,

could you add the feature to automatic export the Proxies by Type? So atm it will save all the working Proxies in a single file in my example a .txt file. But it would be great if there is the function to save the working Proxies by Type so there would be multiple Output files like Socks5.txt, Socks4.txt, Web.txt and Connect.txt

Top Profitable Gadgets Website – 100% Automatic – Ready to Earn Profit – No Experience Needed!

This website is 100% automated – Profitable Niche with ready to go online business allows you to make money. No technical knowledge is required.

(Key Features)

· Amazing Website.
· Built with WordPress.
· Fully Automated.
· Easy to use & No Maintenance Required.
· Free Website Setup.
· Best Support.

Do you really wanted to start your own profitable Gadgets site with little or no work involved? This is the perfect place to begin. GadgetsTricksSpot.com provides you a best way to earn…

Top Profitable Gadgets Website – 100% Automatic – Ready to Earn Profit – No Experience Needed!

Huge Profitable Health Website – Ready to Earn Profit – Fully Automatic – Newbie Friendly!

This website is 100% Automated – Profitable Niche with ready to go online business allows you to make money. No technical knowledge is required.

(Key Features)

· Amazing Website.
· Built with WordPress.
· Fully Automated.
· Easy to use & No Maintenance Required.
· Free Website Setup.
· Best Support.

Do you really wanted to start your own profitable Health site with little or no work involved? This is the perfect place to begin. TopHealthCity.com provides you a best way to earn easy…

Huge Profitable Health Website – Ready to Earn Profit – Fully Automatic – Newbie Friendly!

Amazing Bitcoin Website – Fully Automatic – Top Profitable Niche – No Experience Required!

This website is Fully automated – Top Profitable Niche with ready to go online business allows you to make money. No technical knowledge is required.

(Key Features)

· Amazing Website.
· Built with WordPress.
· Fully Automated.
· Easy to use & No Maintenance Required.
· Free Website Setup.
· Best Support.

Do you really wanted to start your own profitable Bitcoin site with little or no work involved? This is the perfect place to begin. GreatBitcoinSpot.com provides you a best way to…

Amazing Bitcoin Website – Fully Automatic – Top Profitable Niche – No Experience Required!