This series will cover the following three Advanced Windows Failover Cluster Options with SQL Server AlwaysOn availability group configuration to demonstrate how they differentiate from one another and how they work.
When should you use Storage Pools for your Windows VM in Azure?
If you are creating a SQL Sever failover cluster instance (FCI) in Azure, you can use Storage Spaces Direct (S2D) and configure Storage Pools to set-up the Cluster Storage.
The other main reason for using Storage Pools in Azure is ..
Continuing on from our previous posts about Databricks, we are now going to look at structured streaming. For this series of blog posts we are going to use some data from the Seattle Fire Service that is updated every 5 minutes.
As not everyone has access to an Azure subscription or the resources..
One of the common customer queries we get at Coeo is how to provide high availability for SQL Server. I have been advocating the use of SQL Server Failover Cluster Instances (FCI) to provide high availability for over 10 years. However, during a review of our reference architecture the question..
I’ve blogged previously about the need to configure a quorum witness on failover clusters and now with Windows Server 2016 there’s a great new quorum option – a cloud witness.
Since Window Server 2008, the role of what we used to call the “Quorum Disk” in a Failover Cluster has changed significantly and it’s now referred to as a “witness” because its only job is to help the nodes in the cluster decide who should be running the cluster resources in the event that they..
I recently had to install a SQL Server 2008 R2 failover cluster on Windows Server 2012 R2. Some of you may be wondering if this is actually supported. A quick look at the hardware and software requirements for SQL Server 2008 R2 indicates that it is indeed supported.
I came across an interesting case today that I thought it was worth doing a quick blog post about. I was working with a customer who was migrating onto their newly built SQL Server 2014 clustered instance. Part of the pre-migration testing was to fail the SQL Server service between the two nodes to..
In my previous post I discussed an instance where SCOM was failing to monitor the space of a SQL Server database. In this latest post I want to bring to light an issue that was altogether more serious.
I particularly wanted to write this post because, although there are a number of possible reasons..