One of the most popular things in our First Responder Kit is our HA/DR planning worksheet. Here's page one: In the past, we had three columns on this worksheet - HA, DR, and Oops Deletes. In this new version, we changed "Oops" Deletes to "Oops" Queries to make it clear that sometimes folks just update…
Our live webcast topic this week was Q&A - you could bring any HA/DR questions, and we could avoid your answers. Just kidding. Here's the webcast - we apologize for the audio, WebEx is still getting their act together. It cleans up after the first couple of minutes.
https://www.youtube.com/watch?v=G1URY5M09ic
You’d love to know how to make your SQL Servers more highly available, but you’re just not sure what “clustering” is all about. We can help! In this 30 minute video Kendra Little shows you how failover clusters make your SQL Servers easier to manage. She uses diagrams and drawings to teach you the strengths and weaknesses of failover clusters and shows why clustering is becoming even more critical for high availability and disaster recovery.
In our recent webcast on HA & DR basics for DBAs, we got a bunch of questions that couldn't be answered fast enough. Here you go:
I served with High Availability. I knew High Availability. High Availability was a friend of mine. VMware HA, you're no High Availability.
See, for us database administrators, high availability means protection when:
When people buy my virtualization training video, one of the followup questions I get most often via email is, "Can I build SQL Server clusters in VMware and Hyper-V?"
In theory, yes. Microsoft's knowledge base article on SQL Server virtualization support says they'll support you as long as you're using configurations listed in the Server Virtualization Validation Program (SVVP).
If you're using SQL Server 2012's hot new AlwaysOn Availability Groups feature, your databases will go offline when your network connection does - even if you're using asynchronous replication.
This is not a bug. This is working as designed - and it's important to understand the underlying concepts.
Remember that weirdo in high school who had no social skills? Couldn't get a date, worked at the fast food joint as a fry cook, face covered with zits - you know the one. Okay, actually, it was us. Anyway, the point is, we got our act together, didn't we? So did Windows Failover Clustering. …
The options for high availability can get confusing. I was lucky enough to begin working with SQL Server clusters early in my career, but many people have a hard time finding simple information on what a cluster does and the most common gotchas when planning a cluster. Today, I’ll tell you what clusters are, what they’re…
