Novice

In the first part of this tutorial series, SQL101 / Relational Database Management Systems, we went through the process of installing a Relational Database Management System (SQL Server Express), installing SQL Server Management...

A lot of SQL tutorials go through the ins and outs of writing SQL Statements, however, I wanted to do something slightly different and more comprehensive in this tutorial set. I...

The INDEX() function returns the index of the current row in the partition, without any sorting with regard to value. The first-row index starts at 1. For example, the table below...

Tableau Extensions were introduced in version 2018.2 and has massively opened up Tableau to the world of eager developers; literally speaking, this has the potential to be the biggest game changer...

A friend messaged me to ask he could create a grid layout for different visualisations, for example, a 3×3 grid. I immediately thought about a Dot Matrix visualization and how I could create...

In my free time I try to build a few web applications, this is an essential part of my personal learning and attempt to keep relevant. Having an application that delivers great functionality is great, but...