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 […]

Converting Data Across Time Zones: An In-Depth Primer

If only the entire world used UTC, wouldn’t life be so much easier? We can dream, can’t we? While some software applications can live in an ecosystem where all dates and times can be stored in a single time zone with no conversions needed, many cannot.

The Time Conversion

Using sp_prepare and sp_execute to utilize prepared SQL statements

Learn about prepared statements in SQL Server, what they are, and how to use them along with the commands sp_prepare and sp_execute.

The Best and Worst Tech of 2022

Steve looks back at the best and worst technology in 2022.

Ethical Hacking Tutorial

This article explains ethical hacking and how this might be a career field worth pursuing.

The Tech That is Gone

As we start a new year, Steve looks back at old technology that doesn't exist anymore.