Stairway to AlwaysOn 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.
2020-01-08 (first published: 2014-12-10)
10,243 reads
always on
Stairway to AlwaysOn Level 3: Infrastructure 101
In this next level of the Stairway to AlwaysOn, we will look at the components required to implement a Windows Server Failover Cluster.
2019-03-26 (first published: 2014-10-29)
9,649 reads
2014-11-04 (first published: 2014-10-06)
1,155 reads
Stairway to AlwaysOn Level 2: Storage 101
In this new level of the stairway, we examine the storage knowledge you need for an AlwaysOn configuration.
2020-12-09 (first published: 2014-10-01)
11,302 reads
Stairway to AlwaysOn Level 1: What is "SQL Server AlwaysOn"?
Level 1 of the stairway looks at exactly what the technologies "AlwaysOn", "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.
2019-03-26 (first published: 2014-09-24)
24,717 reads
AAG DB State Monitoring
This script is to help monitor the AAG DB synchronization status. It sends an HTML formatted email if Synchronization status is not "Synchronized" or "Synchronizing"
2014-10-14 (first published: 2014-09-09)
880 reads
SQL Server AlwaysOn Availability Groups Fail the Initial Failover Test
The first test of AlwaysOn in SQL Server 2012 is successful, but after testing to swing back again to your primary replica, you find out that automatic failover works only the first time. How come? Carla Abanes explains.
2014-08-28
7,981 reads
What you need for a Multi Subnet Configuration for AlwaysOn in SQL Server 2012
You have a new project that requires a primary database server in one building and secondary database server in another building to be configured as a Failover Cluster. What are the important points to consider for this scenario?
2014-06-25
3,008 reads
SQL Server 2012 AlwaysOn Groups and FCIs Part 4
This is Part 4 of a series on AlwaysOn and FCI integration in SQL Server. In this article we will learn how to add the iSCSI disk storage to our SQL Server nodes and build the cluster.
2014-05-20
4,124 reads
Why Every SQL Server Installation Should Be a Cluster
In this article, I’ll attempt to “convince” you that every SQL Server you put into production should be a SQL Server Failover Cluster Instance (FCI).
2016-03-25 (first published: 2014-04-15)
13,664 reads
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers