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.
2024-08-01 (first published: 2014-12-10)
13,410 reads
Perry Whittle
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).
2024-08-01 (first published: 2015-02-11)
7,744 reads
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.
2024-07-23 (first published: 2014-09-24)
29,507 reads
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.
2024-07-23 (first published: 2014-10-01)
14,018 reads
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.
2024-07-23 (first published: 2014-10-29)
11,410 reads
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.
2024-07-23 (first published: 2015-03-25)
12,102 reads
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.
2024-07-23 (first published: 2015-07-01)
7,704 reads
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
2024-07-23 (first published: 2016-03-09)
5,829 reads
Truncate tables where Referential Integrity exists
This script can be useful in test and dev environments to quickly clear tables via the truncate command where referential integrity exists.
2024-05-15 (first published: 2024-05-02)
819 reads
SQL Server 2012 Always On Groups and FCIs Part 4
This is Part 4 of a series on Always On 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.
2023-04-19 (first published: 2014-05-20)
5,033 reads
Blogs
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
T-SQL Tuesday
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Exploring DiskANN: Part 2: PQ, SSDs, caching and beam search
How I used AI for this postChatGPT to generate images based on info specifically...
Forums
Databricks Genie Spaces for SQL Analysts: Natural Language Querying Without Leaving Your Data Platform
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
The Costs of Multiple Platforms
Comments posted to this topic are about the item The Costs of Multiple Platforms
RegEx Functions II
Comments posted to this topic are about the item RegEx Functions II
Question of the Day
RegEx Functions II
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^d') AND BusinessEntityID IN (7,8)See possible answers