Adding a new shared disk to Windows Server failover Cluster is not a complex process but special care must be taken when you want to use the new disk for any existing SQL Instance. In this article, we will show you all the required steps to add the disk to WSFC and then to properly assign it to an existing SQL role in the WSFC.
2024-09-16
1,065 reads
Deploying IaaS solutions in Microsoft Azure offers benefits that leverage agility, resiliency, and scalability built into the underlying platform. However, when dealing with business-critical workloads, customers typically want to also provide high-availability and disaster recovery capabilities in a manner that they can control. Trying to implement this approach in the cloud by following the procedures applicable in on-premises datacenters frequently presents challenges. This article focuses on these differences in the context of deployment of SQL Server Failover Clustering in Azure.
2017-09-29
3,141 reads
The article is about Configuring TempDB Database on Local Disk in SQL Server 2012/2014 Failover Cluster to improve performance.
2017-03-08
2,556 reads
By Steve Jones
I had a customer recently ask about a change in one of their constraints...
This is not database related, so if you’re not interested in hearing about something...
By Steve Jones
SQL Saturday Austin 2025 is in just a few days. I am honored to...
Comments posted to this topic are about the item fetch an execution plan from...
Is there a best practice way for the team to keep track of changes...
I have a query that is performing poorly It has a left join to...
I have a long running backup of the Sales database during a maintenance window that is going to take another 2 hours to complete on SQL Server 2022. I also need to perform some proactive work and add another file (ndf) to the Sales database to handle the expected growth of the next month. Can I do both simultaneously?
See possible answers