Implementing a SQL Server HA/DR solution does not stop after production go-live. Once the system is ready for users, your job switches to operational support. This is where care and feeding is needed to make sure that the databases are highly available and will not be offline for an extended period of time. This […]
Most IT Professionals – DBAs and sysadmins alike – spend a lot of time on the technical details of an HA/DR implementation. They learn as much as they can about a specific feature, the best practices approach to deployment, and the caveats specific to their use case. And every time an outage occurs, the focus […]
We are just coming out of an extended power outage that started this past weekend after a destructive storm ravaged the city. And while we already got power back on, there are other nearby communities that are still either on generators or completely without electricity. Transmission lines were down, trees uprooted, some were even […]
A common question that I get asked a lot is whether Microsoft officially supports a specific configuration … or not… – Can I add the secondary replica in an Always On Availability Group as a publisher in a transactional replication topology? – Is running a guest Windows cluster on VMWare supported by both VMWare […]
This question came up during a conversation I had with a client. He is a consultant who wanted to become an expert in SQL Server Always On Availability Groups. He is constantly being assigned to projects that involve working with the technology. Yet he does not have the skills to confidently troubleshoot a problem nor […]
I’ll be doing this on a weekly basis so make sure you keep an eye out for announcements on my social media profiles (LinkedIn | Twitter | YouTube)
Do you sometimes get discouraged? – You’ve been trying to learn SQL Server Always On Availability Groups for months – even years – and you feel like giving up because it’s too complicated and confusing. – You attempted to set it up from the ground up – but failed miserably. You started to question […]
As SQL Server DBAs working with Always On Availability Groups, sometimes our hands are tied when working with “black box” systems. – the host machine running your Always On Availability Group VMs that is causing outages. Your Always On Availability Groups are experiencing a lot of unexpected failovers and outages. But since it’s a […]
I was reviewing a client’s Always On Availability Group architecture last week and spoke to their internal team about their design choices. They brought me in to find out what’s causing unexpected outages and how to prevent them from happening in the future. The DBA team is top-notch and one of the smartest group […]
– Are you dealing with too many incidents and outages with your SQL Server Always On Availability Groups? – Are you in constant firefighting mode trying to keep the lights on? – Do you get woken up in the middle of the night when the databases unexpectedly become unavailable? – Do you feel like your […]
