Showing all posts tagged: 'Windows Server'

A 3-post collection

Configuring SQL Server Always On Availability Groups in Azure - Part 3

This is the last of the 3 part blog series where I will explain how to setup Always On using primarily PowerShell and a little bit of GUI. In this section we discuss how to setup and test the Always On SQL Server functionality Prerequisites### You have already completed Part 1 and Part 2 of the series. Part 3 - Prepare the cluster nodes for Always On### You can simply copy paste the code below and execute it step by step in order to implement Part 3 ########################################################## #Step: 1 #Description: Start an Azure PowerShell session # Or start an elevated PowerShell …[read more]

Configuring SQL Server Always On Availability Groups in Azure - Part 2

This is part 2 of a 3 part blog where I will explain how to setup Always On using primarily PowerShell and a little bit of GUI. In this section we discuss how to install and configure the Windows Server Failover Cluster in Azure to support the Always On functionality Prerequisites You have already completed Part 1 of the setup as described here. Part 2 – WSFC configuration You can simply copy paste the code below and execute it step by step in order to implement Part 2 ## PREPARE THE ENVIRONMENT FOR THE CLUSTER DEPLOYMENT ## ########################################################## #Step: 1 #Description: Start an Azure …[read more]

Configuring SQL Server Always On Availability Groups in Azure - Part 1

One of the coolest features in Azure is the fact that you can create Always On Availability Groups and configure a Listeners in order to provide high availability and redundancy to your back-end SQL Server solution. If you want to know more about AlwaysOn and what it can do for you, you can go here. Up until recently, Always On was a bit “hacky” on Azure as we had to use workarounds, especially for the Listener part, which is one of the most important feature as far as applications are concerned. However, the latest patches and updates to Windows Server …[read more]