I decided to focus on a theme every week for the Practical SQL Server HA/DR Show. This week’s theme – Monitoring HA Solutions. I couldn’t count the number of times that I’ve seen customer environments running complex and expensive Always On Availability Groups yet don’t have a monitoring solution. I don’t understand how someone […]
Imagine getting a phone call in the middle of the night. While still figuring out who it was on the other line, you get a text message from your manager. He’s telling you that the databases are offline and that the operations team have been working on it for the past hour. But they’re stumped […]
I decided to focus on a theme every week for the Practical SQL Server HA/DR Show. This week’s theme – Patching and Maintaining HA Solutions. Regular care and feeding of digital assets – servers, apps, platforms, etc. – is essential to keeping them up and running. Hotfixes and patches are being released on a […]
A common administrative task that you need to deal with when managing an Always On Availability Group solution is to recreate SQL Server logins on all replicas. That’s just a fact. Because at any given point in time, an automatic failover can happen and move the Availability group to a different replica. If you don’t […]
I did my very first AMA session live almost a month ago and I’ve had great results. People were interacting during the live Q&A session while some sent follow-up questions afterwards. Given the below freezing temperatures where I’m at, I’ll keep doing this indoors for now until I can stay outside for longer than 5 […]
One of the subjects I had in senior high school was technology and home economics. Since my teacher majored in architectural drafting, she taught us how to read blueprints to have an idea about how structures are built. That’s when I noticed a crack on our wall near the TV. In the Philippines, walls are mostly […]
For more than a decade-and-a-half of working with SQL Server high availability and disaster recovery, I’ve gotten hundreds of questions from clients, event attendees, and training class students. That number has increased when Microsoft introduced Always On Availability Groups. I’m guessing it’s because of the level of complexity of the technology that tech professionals are […]
We heard the earthquake warning device echoing loudly throughout the building. This wasn’t a drill. We left everything on our desks and started to head out. Taking the elevator was not an option so it’s a good thing that we were just on the 5th floor and not on the 17th. We spent almost two […]
Have you ever felt like managing a SQL Server Always On Availability Group is making your life miserable? It’s severely messing up with your sleep cycle? It’s causing you to miss very special occasions? Even missing meals? If so, you’re not alone. In fact, I see this going on all the time with the […]
I was privileged to join one of Brent Ozar’s Office Hours podcast. In case you’re not aware, Brent and his amazing team host weekly podcasts where you can ask your SQL Server-related questions. Since I was joining in, attendees were encouraged to ask SQL Server high availability and disaster recovery-related questions. Here’s the video recording […]
