I couldn’t go thru all of the questions during the session. So, this is Part 2. It’s inevitable that you will be migrating your SQL Server databases throughout it’s lifecycle. But migrating a standalone database is not the same as when they’re in a high availability solution. This episode of the Practical SQL […]
It’s inevitable that you will be migrating your SQL Server databases throughout it’s lifecycle. But migrating a standalone database is not the same as when they’re in a high availability solution. This episode of the Practical SQL Server HA/DR Show covers what you need to consider when when migrating SQL Server high availability solutions. […]
Every SQL Server Always On Availability Group solution fall into these two (2) categories – ones that you built and ones that others built. Simple, right? The problem lies when somebody else – a different team, a consultant, a managed services provider – built the solution, didn’t follow design and implementation best practices, and […]
One of the advantages of working as an independent consultant is the opportunity to work with SQL Server DBAs with different backgrounds from different cultures. My curiosity would lead me to asking questions about their experience working with Always On Availability Groups. A large number of them do not have any experience working with […]
If there’s one thing that remained the same ever since enterprise technology was made available to us, it’s BACKUPS. The way we’ve done backups have evolved – from punch cards, magnetic tape storage, local hard drives, SAN/NAS, all the way to the cloud. Yet we still have the need to do them. While most […]
Ever since I started doing the Practical SQL Server HA/DR Show, I noticed a trend on the questions that people submit using the online form. More often than not, the questions fall under the “HOW” category. Sure, as technology professionals, we get paid to DO the work. So, it makes sense to know the […]
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 […]
