Video: Designing a SQL Server Always On Availability Groups Topology

As you go thru different phases in your career as a SQL Server professional, you progress from being a technician (primary task is more focused on operations) to a designer/architect (primary task is focused on designing a solution and eventually assists in building it.) A technician will be more concerned about a single aspect of a solution whereas a designer/architect will be concerned about the entire solution.

A common question that I get asked from SQL Server professionals when doing presentations is this: “How do you get more experience designing a solution when my current role does not have enough opportunities to do so?” My typical response is summed up in the statement below:

You become one when you start thinking like one. Click To Tweet

This statement applies to just about anything you can think of.

  • You become an architect when you start thinking like one.
  • You become an engineer when you start thinking like one.
  • You become an consultant when you start thinking like one.
  • You become a writer/blogger when you start thinking like one.
  • You become a CEO when you start thinking like one.

Change starts from within ourselves. When I was working as a data center engineer, I didn’t see my role as simply that of a data center engineer. I saw myself as a consultant – one that provides a solution to a problem. I saw myself as a project manager – one that defines the different aspects of a project implementation and manages scheduling and resources. While my official title is still that of a data center engineer, I thought differently and acted differently. Because actions follow our mindset.

You might be asking, “What does this have to do with designing a SQL Server Availability Groups topology?

A high availability solution like that of SQL Server Availability Groups depend so much on a lot of moving parts. Simply implementing it is not enough to meet the business requirements.  It requires a totally different mindset altogether. Which means thinking outside of the “SQL Server box” and looking at the different components that will affect your design.  When I recorded my very first SQL Server Availability Group video, those who have seen it thought that it was easy as clicking a few options, enabling a few features and configuring it. Little did they know that there were a lot of components that needed to work in order to build a working solution.

This video recording of a webinar I did a few months ago will get you started on how to design and architect a SQL Server Availability Group topology. It challenges you to think differently – to start with what the business needs and focus on a solution that will meet those needs. It also considers the common design patterns that you will see in the field and how I look at each of them with the business requirement/s in mind. My goal is not just for you to become a better SQL Server professional and progress in your career. More importantly, I want you to change the way you think about approaching problems. Because, sometimes, we don’t really need better solutions. We just need a better way to think about and look at problems. You might be surprised that the solution you’ve been searching for is right around the corner.

Enjoy watching the webinar recording.

Feeling helpless and confused when dealing with Windows Server Failover Clustering  (WSFC) for your SQL Server databases?

You’re not alone. I’ve heard the same thing from thousands of SQL Server administrators throughout my entire career. These are just a few of them.

“How do I properly size the server, storage, network and all the AD settings which we do not have any control over?”

“I don’t quite understand how the Windows portion of the cluster operates and interacts with what SQL controls.”

“I’m unfamiliar with multi-site clustering.”

Our servers are setup and configured by our parent company, so we don’t really get much experience with setting up Failover Clusters.

If you feel the same way, then, this course is for you. It’s a simple and easy-to-understand way for you to learn and master how Windows Server Failover Clusters can keep your SQL Server databases highly available. Be confident in designing, building and managing SQL Server databases running on Windows Server Failover Clusters.

But don’t take my word for it. Here’s what my students have to say about the course.

“The techniques presented were very valuable, and used them the following week when I was paged on an issue.”

“Thanks again for giving me confidence and teaching all this stuff about failover clusters.”

“I’m so gladdddddd that I took this course!!”

“Now I got better knowledge to setup the Windows FC ENVIRONMENT (DC) for SQL Server FCI and AlwaysON.”

NOTE: Registration for my online course Windows Server Failover Clustering (WSFC) for the Smart SQL Server DBA will re-open in January 2018. But be sure you do not miss out. This will be the last time that the course will be offered. After this, you will no longer be able to register for the course.


Get notified about the next batch of enrollment so you don’t miss out.

* indicates required

Please note: I reserve the right to delete comments that are offensive or off-topic.

Leave a Reply

Your email address will not be published.