How to Find Missing Rows in a Table

When someone says, “Find all the rows that have been deleted,” it’s a lot easier when the table has an Id/Identity column. Let’s take the Stack Overflow Users table:

Bucket Sort Algorithm in Python to Sort a List of Array Values

Learn about how to implement a simple bucket sort algorithm using Python code to sort a list of array values.

The ANSI PADDING Table

Database Sharding to help Improve Performance and Maintenance Tasks

In this article, we will review the benefits and drawbacks of using database partitioning (sharding) to help improve performance and maintenance tasks.

Using pre-commit to prevent simple mistakes

Git hooks are a useful way of triggering code quality scripts. The pre-commit tool provides us with a way of doing this and tapping into the huge library of scripts already in existence to ensure our code complies with general linting and formatting good practice.

How to Create a Box and Whisker Plot in Power BI Desktop

In this article, we look at how to build a box and whisker plot chart using Power BI Desktop with a step-by-step walkthrough.

The Programming Languages We Use

Steve comments on some programming languages and how we approach those we choose to use.

Replacing text

Subqueries in MySQL

A subquery is a type of query that is embedded—or nested—into a data manipulation language (DML) statement. The subquery itself is typically a SELECT statement, although you can also use a TABLE statement or VALUES statement. Even so, the SELECT statement continues to be the most common choice for subqueries, and that’s the one I focus on in this article.

How to Create a Power BI report using MySQL data

Introduction In this article, we will learn to create a Power BI report using MySQL data. The article will teach us to use the MySQL Workbench (something like the SSMS, but for MySQL). We will do the following in this article. First, we will connect and create a database in MySQL. Secondly, we will create a […]