In Part 2 of this blog post series, you’ve seen the interaction between SQL Server and the Windows Server Failover Cluster (WSFC). In Part 3, you’ve seen the different WSFC components that make Always On Availability Groups (AG) highly available. If SQL Server and the WSFC need to coordinate and communicate consistently to stay […]
“How can you expect to fix the engine if you don’t even know how it works?” – my friendly neighborhood car mechanic. My 20-year old Nissan X-Trail has been misbehaving recently. I can understand that, given how old it is, it has served it’s purpose. But, no. It still drives great and […]
I’ve always wanted to become a pilot ever since I was a kid. It’s one of the reasons I love traveling. I finally decided to pursue my childhood dream and scheduled an introductory flight. And it was a blast. There were preliminary lessons before we got on the plane. Not a full […]
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 […]
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 bet a lot of IT professionals who are really serious about their work are like me. When they see an error or warning message like this, their first instinct is to find out what the problem is and fix it. That’s what I did when I saw this error while configuring a SQL Server […]
I’ve been wanting to write for the CanITPro.net website for quite sometime now, primarily because there hasn’t been any new content on SQL Server on the site lately. The Canadian IT Pro and developer communities are very vibrant and active, thanks to the effort of Canadian Microsoft MVPs Jean-René Roy (blog) (DevTeach/SQLTeach) and D’Arcy Lussier (Twitter | […]
