All clustering in SQL Server is inherently Active/Passive. A given database can only be online to a single node at any one time.
People use the term Active/Active to indicate they have installed multiple SQL Server clusters, each one with its own set of databases. In this scenario, SQL Cluster 1 can have its active databases on windows cluster node A, and SQL Cluster 2 can have its active databases on windows cluster node B. This means both windows cluster nodes are active, but they are active with completely separate databases.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara