MSSQL - What are aggregate functions in SQL?
When working with databases, managing and analyzing large amounts of data efficiently is crucial. This is where SQL (Structured Query Language) comes into play, SQL provides »
Fix for Age of Empires 2 lag that gets worse and worse as you play
Every other month I play a game of Age of Empires and recently I found that it had started to lag. It would start out fine »
Google sheets - How to use sumif or sumifs to sum cells in a range based on a condition
In Google sheets you can use sumif to conditionally sum values in a range depending on a criteria. For example the following formula will sum numbers »
Google sheets - How to use countif to count the number of matching cells in a range
In Google sheets you can use countif to conditionally count cells in a range. For example the following formula will count numbers larger than zero in »
C# - How to create, build and run a "hello world" console app on Linux
This post describes how to create a simple Console application and run it on Linux, for this we will be using WSL (Windows Subsystem for Linux) »
C# - How to Work with Files and Folders
In C# you have several ways to interact with files and folders, the most common are the File, Directory and FileInfo classes. Using these classes you »
Getting Conquest: Frontier Wars to work on Windows 11
If you are like me and know about the epic 2001 game Conquest Frontier wars you may have run into some issues when starting this game. »
Blackduck synopsys scan script no longer working and returns 404 as of March 2023
Is your synopsys scan no longer working as of the 1st of March 2023? Well it is because it is no longer there (404). It has »
Git - How to reset changes from a specific commit
You can revert a single commit in git using git revert <commit>, below is a step by step guide on how to do this. »
Git - How to force a git pull and overwrite local changes
In this post we will use a newly created remote repository and two local repositories cloned from that remote. We will then push a change and »