Stairway to Always On

Always On is a complex set of technologies that is often misunderstood. In this Stairway you will learn about the Always On technologies, how they fit into the High Availability stack, and how to make good use of them.

• Stairway to Always On Level 1: What is "SQL Server Always On"?

  Level 1 of the stairway looks at exactly what the technologies "Always On", "Failover Cluster Instance" (FCI) and "Windows Server Failover Cluster" are. We'll look at each in detail and summarize where in the High Availability stack they sit.

• Stairway to Always On Level 2: Storage 101

  In this new level of the stairway, we examine the storage knowledge you need for an Always On configuration.

• Stairway to Always On Level 3: Infrastructure 101

  In this next level of the Stairway to Always On, we will look at the components required to implement a Windows Server Failover Cluster.

• Stairway to Always On Level 4: Analyse and Deploy a Windows Server Failover Cluster

  In level 4 of the stairway to AlwaysOn we look at creating a Windows Server Failover Cluster.

• Stairway to Always On Level 5: Analyse and Deploy a Failover Cluster Instance

  In Level 5 of this stairway, we help you understand and deploy a Failover Cluster Instance (FCI).

• Stairway to Always On Level 6: Analyse and Deploy an Always On Availability Group

  In level 6 of this stairway, we will look deeper into Availability Groups and how to set them up along with a Listener.

• Stairway to Always On Level 7: Combining FCIs with Availability Groups

  In Level 7 of this stairway, we look at combining Availability Groups with FCIs for both HA and DR protection.

• Stairway to Always On Level 8: Segregate Mirror Traffic in AlwaysOn

  this article details how to segregate the mirror traffic in an Always On group configuration