The Ultimate Guide to Understanding SQL Joins

Published on 02/10/2025

SQL joins allow you to combine data from multiple tables. Here is a simple guide for beginners, illu...

Learning how to return JSON with SQL Server

Published on 28/10/2024

Sometimes, returning rows from your SQL Server database isn't enough, and JSON is the best solution!

Create a stored procedure with SQL Server

Published on 21/10/2024

Stored procedures are the equivalent of functions in classic programming, but what are their advanta...

Creating a transaction with SQL Server

Published on 18/06/2024

Need to perform atomic operations on SQL Server? Here's an article that explains step by step how to...

# Understanding the CAP Theorem in 2 Minutes

Published on 08/04/2024

Also known as "Brewer's theorem" after its author's name, the CAP theorem is essential to know when ...

How do you sort results by multiple columns in SQL?

Published on 04/12/2023

Need to sort data by multiple fields in SQL? It's possible with ORDER BY!

How do I replace part of a text in SQL?

Published on 23/05/2022

Need to find occurrences of a text in a column and replace them throughout the table? Here's the sol...

## How to choose between SQL and NoSQL?

Published on 03/08/2021

or why the relational model is the right answer in 95% of cases!