Skip to content Skip to sidebar Skip to footer

Monthly Archives: July 2026

Git Deep Dive: What HEAD Really Is

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…

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…

Accessing an Azure Linux VM Using SSH on Windows

When creating a Linux VM in Azure we have two options for configuring authentication: Regular username and password Using an SSH public key Username and password need no introduction. The purpose of this blog is to show how we can…

Using JSON Inside SQL Server: Use Case 1

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…

TSQL Tips: Window Functions

I use window functions a lot however; I often find myself having to remind myself on certain syntaxes or the different outputs between two functions. The following code snippet is used just as a reminder on what is available and…

Hidden Gems in C# Exception Handling

The TRY/CATCH/FINALLY exception handling has been around since C# 1.0 and you are very unlikely to find a developer who does not know how to use them. What may not be so obvious is that there are a number of…