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 […]
A few weeks ago, I was trying to figure out why my Korg X50 music workstation was not sending MIDI data to my MacBook Pro. While the Korg X50 has its own sound library and can function without the MacBook, the use of software made it easy for me to do audio recordings. But what […]
One of the most common error you’ll encounter when you try to join a SQL Server instance as a replica in an Always On Availability Group is the dreaded Error 35250. You’ll find a ton of blog posts and articles on how to resolve this particular error. The goal of this blog post is […]
You don’t qualify! Imagine hearing those words from someone telling you that you’re not enough. Insufficient. You didn’t meet the standard. I’ve heard a lot of that when I started looking for a job after graduating from college. An engineering degree wasn’t enough to get hired. It didn’t help that I failed seventeen […]
Given Microsoft’s announcement of SQL Server 2022 preview, you somehow get an idea of the frequency of releases for future SQL Server versions. This translates to more database upgrade and migration work that SQL Server DBAs have to do. However, keeping up with the latest and greatest version is not practical from a business standpoint. […]
In partnership with Brent Ozar (Twitter | blog). The idea behind this partnership started last year when Brent was kind enough to spend one Saturday morning with me over breakfast at the Bar Siena Restaurant in Chicago. I have been thinking about launching my online course – Windows Server Failover Clustering for the Smart SQL Server […]
I teach about failover clustering for SQL Server – whether it’s Failover Clustered Instances or Availability Groups. Failover clustering does not have to be confusing nor complicated. It just has to work. And when things we are responsible for don’t work, we get the blame. There’s a reason behind the running joke about the Default […]
By continuing to use the site, you agree to the use of cookies. more information
The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.
