I was looking at my phone, waiting for my Amazon order to arrive. I heard a notification confirming that my delivery had arrive. The photo-on-delivery feature is a great way to confirm that the package was indeed delivered and in the right address. To my surprise, I see an unfamiliar porch in the […]
I recently got back from a wilderness camping trip in upstate New York. It’s an opportunity for me to disconnect and enjoy the opportunity to be alone in nature. Wilderness camping means you will be off the grid for a few days. This means no phone signals, no public restrooms, no grocery stores, nothing. […]
Deploying SQL Server Always On Availability Group solutions is not an easy task. There are a lot of moving parts outside of SQL Server that Always On Availability Groups depend on. There’s the network, Active Directory, DNS, Windows Server Failover Cluster, etc. And even when Microsoft provided a wizard that guides you through the […]
When something “just works”, we tend to have the attitude of “set it and forget it”. This is especially true when everything is smooth sailing with the day-to-day operations. But when a major disaster happens – a natural calamity, a hardware failure, an end-user mistake, etc. – stress levels are thru the roof. We […]
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 […]
