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,652 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,478 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,307 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,700 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,178 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)
5,005 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,375 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,965 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,333 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)
12,025 reads
By gbargsley
One of the first things I review when I inherit a new SQL Server...
By Arun Sirpal
It’s 07:43. Someone’s already left a message. “Something’s wrong with the DB server.” You...
By davebem
I’ve had a Dropbox account for years. Like a lot of people, I started...
Comments posted to this topic are about the item Follow Your Hunch
Comments posted to this topic are about the item What Happens When You Ask...
Comments posted to this topic are about the item Detecting Characters
I have a SQL Server 2022 English default installation on a server. I want to detect if there are any upper case characters in rows and I have this code:
SELECT CustomerNameID,
CustomerName
FROM dbo.CustomerName
WHERE CustomerName = LOWER(CustomerName)
Here is the sample data I am testing with:
CustomerNameID CustomerName 1 John Smith 2 Sarah Johnson 3 MICHAEL WILLIAMS 4 JENNIFER BROWN 5 david jones 6 emily davis 7 Robert Miller 8 LISA WILSON 9 christopher moore 10 Amanda TaylorHow many rows are returned? See possible answers