Google Cloud Platform (GCP) gives you the option to add a startup script to your instance. The script will run every time the instance is started. The startup script can be a Windows batch script, PowerShell or a shell script if using Linux. For Windows instances you have the option to add a sysprep-specialize script
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