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.
In level 4 of the stairway to AlwaysOn we look at creating a Windows Server Failover Cluster.
In Level 5 of this stairway, we help you understand and deploy a Failover Cluster Instance (FCI).
You have dropped a column and wondering why you haven't recovered any space? Let's take a look.
One of the features in SQL Server Management Studio (SSMS) that I find very useful is to have a list of registered servers and databases in SSMS. This lets me quickly pick from a number of servers rather than flipping the drop down in the connection dialog. This post looks at this feature and how […]
Learn about Azure CLI and how to manage your Azure resources using commands instead of using the Azure portal.
In celebration of their 25th anniversary in 2024, Redgate, as the host of PASS Summit, is thrilled to introduce the PASS Summit Futures Scholarship. This initiative aims to empower the next generation of data professionals from diverse backgrounds.
Applications are open internationally to students and early-career professionals. Each of the 10 lucky winners will be awarded:
Steve has a quick turnaround between trips that was a bit unexpected. Is there compensation for this?
This article shows how to get started with the PostgreSQL API in Azure Cosmos DB.
I’ve talked about it before; you shouldn’t have a backup strategy, you should have a recovery strategy.
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
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...
I have an issue where I have a Bill of Material list of items...
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...
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