There are two fundamental ways to do this. You could configure a multi-node Always On Availability Group (AG), a feature of SQL Server itself, or you could use Windows Server Failover Clustering ...

Once that's done, you can use this code to go through your environment and store SQL Server configurations. Next time, we'll look at the more advanced configuration management features of SQL ...