You can have multiple instances of SQL Server spread across multiple nodes to create some semblance of load balancing but each instance is still Active/Passive.

Ask 10 people 'What is high availability?' and you might get 15 different answers. For the purposes here, HA will be defined as ensuring SQL Server is operating when and as needed. 'When' takes into ...

If the Main site SQL server goes out, the Mirrored server get elevated to active status. This elevation can be manual or automatic.

When designed to support SQL Server, the failover cluster creates a high-performance, high-availability environment that is easy to manage.

A step-by-step guide to using SAN-less failover clustering software to support SQL Server’s Always On Failover Clustering in the public cloud The thing about clouds is that they can change shape ...