Visual Studio Code - How to easily diff and compare two files
In this post I will share four ways to diff and compare files in Visual Studio Code. All of them are built-in and require no extensions. »
Goal met! 25.000 organic and referral traffic in November!
Last month - November - I had 25.066 organic and referral traffic, that is everything that is no direct traffic. In November 2021 this number »
C# - Convert DateTime or DateTimeOffset to and from unix timestamp
In C# you can easily convert a DateTimeOffset to Unix time in seconds or miliseconds using the built-in methods ToUnixTimeSeconds or ToUnixTimeMilliseconds: var dateTimeOffset = DateTimeOffset.Now; »
Google sheets - Conditions using IF THEN ELSE formula
The basic structure of the IF THEN ELSE formula in Google sheets is an IF formula with parameters, it looks like the following: =IF(logical_expression; »
MSSQL - Create a stored procedure with parameters
This post describes how to create a stored procedure in MSSQL that takes parameters. For this we will use the simple table below: CREATE TABLE SomeTable( »
MSSQL - How to use variables in SQL statements
This post will demonstrate how to SELECT from a MSSQL table using a variable. There will be three examples: * Simple select statement * Setting a variable from »
Google sheets - How to create a drop-down list in a cell
You can easily create in-cell drop-downs in Google sheets using the "Data validation" menu point. It can be found under: * Data * Data Validation Located right here »
MSSQL - Creating a table with an auto increment Primary key or adding it later
In MSSQL you can set auto increment for a column using the IDENTITY property. This will often be used on the primary key column, but it »
MSSQL - SELECT Date in a specific format (yyyy-MM-dd, MM/dd/yy, MM-dd/yyyy etc.)
In MSSQL you can easily format datetime strings using the FORMAT function. For the examples in this post we will use a simple table like the »
MSSQL - Having a SELECT statement in a WHERE clause or part of SELECT statement (using subqueries)
For this blog post we will use the following two tables as examples, the scripts are written in SQL for MSSQL but it should be transferable »