In my last post I talked about how to create a SQL Server Availability Group using Alias IP Ranges. In this post I want to share a set of PowerShell scripts that I created to automate that process. You can find the scripts in my GitHub repository. Pre-requisites Before you create the Availability Group there
On a previous post I talked about how to create an Availability Group in GCP. One key requirement to make it work is to change the netmask of the guest OS to be broader than the GCP netmask (for example /16 in guest OS vs. /24 in GCP.) Then you need create routes for the
In the previous post SQL Server Availability Groups in GCP we showed some tips on how to create a SQL Server Availability Group in GCP. To automate that process we created PowerShell scripts that can be found in the GCP GitHub repository. They are also a good reference on how to use PowerShell to manage
I wanted to share some tips on how to create a SQL Server Availability Group in GCP. If you have tried before and put both nodes in the same subnet you may have noticed that it will not work. In order to make it work you need to put the nodes in different subnets. You
If you have multiple SQL Servers and need to keep the schema for those servers synchronized this article will show you an easy way to do it. You will need to download and install xSQL Schema Compare. The application comes with a 2 week trial. This application is very handy when comparing databases. Besides the
