Database performance analysis using R

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

Automated IBM DB2 Installation

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),

Migrate Azure VM from one subscription to another

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

Automate VM configuration with startup scripts in GCP

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

SQL Server Availability Groups in GCP – IP Alias & PowerShell

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

SQL Server Availability Groups in GCP using PowerShell

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

SQL Server Availability Groups in GCP

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

How to compare SQL Server schema from a command prompt

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