This cheatsheet is a GIT 101 on the basic commands that are used on a day to day basis. At the time of writing I was using git version 2.27.0.windows.1. Note: certain actions can be accomplished in more than one way however; I have chosen to show just one way. E.G GIT CHECKOUT <FILE> and … More GIT Cheatsheet with Pictures – Part 1
Search for information on Git HEAD and the chances are you come away with a vague idea and possibly a good idea, but confused. It need not be that way if you look at the essence of why we have a HEAD. I am going to explain in two sentences exactly what it is. Then … More GIT Deep Dive – This is what HEAD really is
From SQL Server 2016, Microsoft provided support for storing and manipulating JSON within a SQL Server database. The aim of this blog is not to teach you how to use JSON but rather a use case for when JSON is a better alternative. For this second example I am going to show you how I … More Using JSON inside SQL Server – Use Case 2
From SQL Server 2016, Microsoft provided support for storing and manipulating JSON within a SQL Server database. The aim of this blog is not to teach you how to use JSON but rather a use case for when JSON is a better alternative. For this example I am going to show you how I implemented … More Using JSON inside SQL Server – Use Case 1
One of the benefits of having the source code is that often the comments in the code can provide good insight into the inner workings that the normal documentation does not. It can also show code that will output more logging when certain options are set. The biggest benefit comes from being able to attach … More Building PGAgent 4.0 from the Source Code using Visual Studio 2019
One of the benefits of having the source code is that often the comments in the code can provide good insight into the inner workings that the normal documentation does not. It can also show code that will output more logging when certain options are set. The biggest benefit comes from being able to attach … More Building PostgreSQL 12 from the Source Code using Visual Studio 2019
Microsoft has released a new monofaced font intended for the windows terminals like Command Prompt or Powershell. The GITHUB project is located here. Let’s install the new font and take a look. Download the Font Navigate to https://github.com/microsoft/cascadia-code/releases and download Cascadia.ttf to your desktop. Install the Font Double click Cascadia.ttf to launch the font viewer. … More The New Cascadia Font for Windows
I spent 14 years on Solaris Unix back in the 80’s and 90’s and then became a windows only developer and engineer. Now almost 20 years later I am back to using it but now with Linux. It is quickly becoming apparent that not only have things changed but now we have a lot of … More Auto-Starting PostgreSQL at Machine Reboot
The idea of this post is to document my journey to building PostgreSQL on a Red Hat Linux server in Microsoft Azure. The post assumes the reader has experience using Microsoft Azure so those steps will not be detailed. A lot of the information came from this Microsoft link. Creating a Linux Virtual Machine From … More Installing a PostgreSQL Cluster in Azure
Denham Coder 