The Jade 2025 release focuses on modernising the developer experience and helping you build faster, smarter, and more scalable applications.
ever come across "MultiSubnetFailover"? SQL server - ODBC - ADO.NET all support it .... Could the Jade presentation client connect in the same way? This would mean you don't need to change DNS in a DR take-over... the client just connect to the next active end point ....
Would also have to take Jade load balancing into account in the design of this.
Reference location - https://www.sqlshack.com/sql-server-always-on-listeners/