Category: SQL Server

PostAre You (Still) In The Business Of Running Databases?

This blog post is the second in a series that covers designing and implementing hybrid SQL Server high availability and disaster recovery solutions with Microsoft Azure.   As I was reading the news this week, it’s hard to ignore the announcement of General Motors laying off hundreds, if not thousands, of employees in their Michigan-based manufacturing plants. […]

PostGetting Into The “Dating Phase” with the Cloud

This blog post is the first in a series that covers designing and implementing hybrid SQL Server high availability and disaster recovery solutions with Microsoft Azure.   I’m sure you’ve seen a lot of status updates on your social media feeds this past Valentine’s Day. Whether you’re searching for a new partner or in an […]

PostMaking Sense of the Windows Server Failover Cluster Debug Logs For Mere Mortals

[callout]WARNING: If you’ve gone thru part 1, part 2 and part 3 of this series of blog posts and your SQL Server databases running on a Windows Server Failover Cluster (WSFC) are still offline and unavailable, I would recommend escalating it to a more senior engineer or calling Microsoft support before reading further. Regardless of […]

PostReviewing the Windows Event Logs to Find Hints That Can Cause Availability Issues

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 [callout]This blog post is the third in a series that talks about the process that I follow when troubleshooting availability of SQL Server failover clustered […]

PostReviewing the SQL Server Error Logs to Find the Two Most Common Keywords That Can Cause Availability Issues

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 [callout]This blog post is the second in a series that talks about the process that I follow when troubleshooting availability of SQL Server failover clustered instances and […]

PostThe Biggest Challenge I Had in Mastering Windows Server Failover Clustering for SQL Server

I’m re-launching my online course Windows Server Failover Clustering (WSFC) for the Smart SQL Server DBA. The course took a year-and-a-half in the making. But mastering the concepts I covered in the course took over a decade. With the continuous improvement that Microsoft has invested in the WSFC technology over the years, implementing and managing it has […]

PostExploring The Windows Server Failover Cluster Dependency Report

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 [callout]This blog post is the first in a series that talks about the process that I follow when troubleshooting availability of SQL Server failover clustered […]

PostWho Says Quotas Are Only For Sales

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 to […]

PostBeyond Technical Reasons: Running a Single Instance or a Multi-Instance SQL Server Failover Cluster

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 per SQL Server FCI […]

Copyright © 2018 Learn SQL Server High Availability & Disaster Recovery

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.

Close