SQL Server Failover Clustered Instances (FCI) and Availability Groups (AG) depend a lot on Windows Server Failover Clustering (WSFC). Understanding how the underlying WSFC platform works can help us maintain availability of our databases This blog post is the third in a series that talks about the process that I follow when troubleshooting availability of SQL Server failover […]
SQL Server Failover Clustered Instances (FCI) and Availability Groups (AG) depend a lot on Windows Server Failover Clustering (WSFC). Understanding how the underlying WSFC platform works can help us maintain availability of our databases This blog post is the second in a series that talks about the process that I follow when troubleshooting availability of SQL Server failover […]
With the continuous improvement that Microsoft has invested in the WSFC technology over the years, implementing and managing it has become a lot easier. I started doing my Gone Clustering in 60 Minutes presentation back in 2010. And I’m still amazed at how much it has improved. But I still talk about the frustrating hardware compatibility […]
SQL Server Failover Clustered Instances (FCI) and Availability Groups (AG) depend a lot on Windows Server Failover Clustering (WSFC). Understanding how the underlying WSFC platform works can help us maintain availability of our databases This blog post is the first in a series that talks about the process that I follow when troubleshooting availability of SQL Server failover […]
Ever since I started working on projects involving SQL Server Always On Availability Groups back in 2012, the most common issues I’ve come across with have nothing to do with SQL Server. After my presentation on Architecting SQL Server Availability Groups at the Seacoast SQL Server User Group in New Hampshire, someone approached me […]
When asked about best practices on running multiple SQL Server failover clustered instances (FCI) on a multi-node Windows Server Failover Cluster (WSFC,) a common response from SQL Server experts might include the following: – appropriately allocating enough hardware resources on all of the nodes in the WSFC – appropriately configuring maximum server memory settings […]
This week, I had the amazing opportunity to do a webcast for the PASS High Availability and Disaster Recovery Virtual Chapter covering the five things that you need to consider when deploying SQL Server Failover Clustered Instances (FCI) and Availability Group (AG) replicas in a Disaster Recovery Site. I’ve written several blog posts about this topic and […]
[callout]Replace SQL Server DBA with your career or role and the lesson will apply regardless.[/callout] We’ve all followed successful people – rockstars, entrepreneurs, public figures, Hollywood actors, even geeks like Bill Gates or Mark Zuckerberg. I’m sure you’re like me, intrigued as to what made them really successful so you can emulate what they did. […]
And the registration is now OPEN! I’m excited to re-open limited-time registration for my online course Windows Server Failover Clustering (WSFC) for the Smart SQL Server DBA course. Head on over to the main site. Registration for this course will only be available from 23-October 10:00 AM Eastern time to 29-October-2017 10:00 PM Eastern time. After that, you […]
While working on the video ad for my SQL Server Always On Availability Group: The Senior DBA’s Ultimate Field Guide training program, I couldn’t help but take stock of the different skills I had acquired throughout my lifetime to come up with the final result. – started playing piano at 5 – learned how to […]
By continuing to use the site, you agree to the use of cookies. more information
The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.
