While R is a popular tool used by data scientists it is also a tool that can be used by anyone that collects any type of data. I am not an expert in R, but I have been able to use it to analyze the metrics data that we collect from servers. I find it
If you need to do multiple installations of DB2 and want to standardize how they are installed, one way to do it is by using response files. The command is simple, you just run db2setup and provide the response file as a parameter. Below is an example. If you always install the same instance (db2inst1),
If you need to migrate a VM from one Azure subscription to another subscription there is a quick way to do it using PowerShell. You can find the script in my GitHub repository. At a high level these are the two steps we do: Create a copy of the boot disk directly from one subscription
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
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
