A big concern for most DBAs and sysadmins supporting SQL Server Always On Availability Groups is that they’re stuck doing operational support. And they have never had the opportunity to design a solution from the ground up. Most of the time, someone will design and implement the solution while they end up supporting it […]
Your effectiveness and success on the job depend so much on your ability to solve problems. In fact, you get paid to solve technical problems every day. Effective problem solving is a very important skill as a SQL Server DBA and IT professional, isn’t it? But . . . How many times have […]
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 […]
