This is Part 2 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.
2024-08-01 (first published: 2014-03-06)
5,619 reads
Part 3 of the AO and FCI integration series. This article gets SQL Server configured on the nodes and ready for work.
2024-08-01 (first published: 2014-04-03)
4,460 reads
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,144 reads
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,619 reads
Learn how to get a Failover Cluster Instance set up and configured with Windows and SQL Server. This is part of a series showing how to combine a Failover Cluster Instance of SQL Server with an Always On availability group.
2024-07-23 (first published: 2014-02-10)
10,135 reads
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.
2024-07-23 (first published: 2014-05-20)
4,982 reads
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,059 reads
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)
13,870 reads
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,240 reads
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)
11,903 reads
By Steve Jones
I wrote a piece on the new SUBSTRING in SQL Server 2025 and got...
By Steve Jones
If you aren’t watching the Ignite keynotes today, then you might have missed the...
Short version You want to get this running as fast as possible. Do these...
I changed my email address in Edit Profile page, but it has no effect...
Comments posted to this topic are about the item The case for "Understanding our...
Comments posted to this topic are about the item Specifying the Collation
I am dealing with issues on my SQL Server 2022 instance related to collation. I have an instance collation of Latin1_General_CS_AS_KS_WS, but a database collation of Latin1_General_CI_AS. I want to force a few queries to run with a specified collation by using code like this:
DECLARE @c VARCHAR(20) = 'Latin1_General_CI_AS'
SELECT p.PersonType,
p.Title,
p.LastName,
c.CustomerID,
c.AccountNumber
FROM Person.Person AS p
INNER JOIN Sales.Customer AS c
ON c.PersonID = p.BusinessEntityID
COLLATE @c
Will this solve my problem? See possible answers