Javascript - How to remove an element from an array using splice
You can delete an item in an array using the splice function. All you need to know is the index of the element you want to »
C# - An introduction to LINQ
In C#, LINQ (Language INtegrated Query) is a powerful tool for querying and manipulating data. LINQ provides an intuitive way to interact with various data sources, »
C# - How to check if a character is in a string?
In C# you can easily check if a string contains one character or a series of characters using the .Contains() method on the String object. Below »
Google sheets - How to use vlookup to look up values using a key
In Google sheets you can use VLOOKUP to look up a value based on a key. In short VLOOKUP will search for a specific key in »
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 »