The best UI client for Redis on Windows, Mac, and Linux

Published on 18/08/2025

Redis Insight is the official client for exploring and managing your Redis databases on Windows, mac...

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!

# 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 Database Indexes Work

Published on 24/10/2022

Why and how creating indexes can speed up your queries, or slow them down if they are poorly designe...

Should you store data in a file or a database?

Published on 02/03/2022

Is it necessary to systematically store your data in a database? When is a simple file sufficient?

## 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!

Database: Differences between replication and fragmentation (sharding)

Published on 26/07/2021

You see the terms "replication" and "sharding" pop up when it comes to databases, and you're not sur...

MongoDB: Resolving the "TransientError - Transaction aborted" error

Published on 20/07/2021

Learn how to fix the MongoDB “TransientError – Transaction aborted” error: common causes, best pract...

What is a transaction in a database?

Published on 12/07/2021

Essential concept for maintaining data integrity in the database.