Mercy Bassey in MySQL

Replicating MySQL databases in Docker Containers

In my prior article, “Running a relational database with Docker”, I showed how to spin up a Docker container with...

13 June 2025 10 min read

Aaron Bertrand in Database Administration

SQL Server 2025 : Zstandard Backup Compression

Whether you are a bank or a hot dog stand, creating backups is a boring but essential part of managing...

11 June 2025 15 min read

Jagdish Mohite in PostgreSQL

Securing PostgreSQL Against Injection, Misconfiguration, and Privilege Escalation

PostgreSQL is a robust and trusted database platform, but it’s not invincible. The PostgreSQL Global Development Group “takes security seriously,”...

06 June 2025 22 min read

Kellyn Pot'Vin-Gorman

Oracle ASM: A Simple Solution or Another Complexity? (part 1)

For highly performant Oracle databases, the storage must be scalable, resilient, and easy to manage—especially as infrastructure complexity grows with...

05 June 2025 6 min read

Aisha Bukar in MySQL

MySQL vs. PostgreSQL: Date and Time Data Types

Date and time data types are important because they help track and manage time-based information in databases. This includes things...

03 June 2025 21 min read

Robert Sheldon in MongoDB

Moving from SQL to MongoDB’s MQL

People new to MongoDB often come to the platform with a background in relational database management systems (RDBMSs) such as...

30 May 2025 27 min read

Mercy Bassey in MySQL

Running a MySQL database in a Docker Container

Relational databases provide a structured approach for storing and organizing large volumes of data into tables consisting of rows for...

29 May 2025 14 min read

Goodness Woke in Security and Compliance

Zero-Trust Architecture for Cloud-Based AI Systems

Cloud-based artificial intelligence’s growth has transformed how businesses analyze data and get insights, but it has also brought with it...

27 May 2025 25 min read

Louis Davidson in T-SQL Programming

DISTINCT and UNION: What happens when you use them together?

When I was perusing my LinkedIn feed the other day, I came across this thread about using SELECT *. In...

26 May 2025 11 min read

Joe Celko

Data Encoding Schemes

You probably noticed that when you get a bill or bank statement, it uses the current modern Western version of...

22 May 2025 15 min read

Simple Talk Editor in SQL Server

SQL Server 2025 is in Public Preview!

On Monday, May 19, 2025, SQL Server 2025 was announced as finally going to be in public preview. Instead of...

21 May 2025 3 min read

Bravin Wasike in DevOps

What are the Key DevOps Performance Metrics You Should Track?

Successful DevOps teams rely on data-driven decision-making to continuously improve software delivery and operational performance. Understanding the right DevOps performance...

16 May 2025 28 min read

Chisom Kanu in MySQL

MySQL Shell Basic Configuration Management (Part 4 – Optimizing MySQL Performance)

Welcome back to our journey of understanding MySQL performance tuning using MySQL Shell. So far, we’ve covered essential topics like...

15 May 2025 17 min read

Rodrigo Ribeiro Gomes in Database Administration

Recovering data in SQL Server without full backup

In more than 10 years of experience, I have dealt with cases where someone has performed incorrect operations on a...

13 May 2025 32 min read

Louis Davidson in Editorials

What’s Your Price?

Everyone has a price, and that price takes many forms. It could be money, loved ones, comfort, duty, or a...

12 May 2025 7 min read

Farooq Aziz in Snowflake

Parent – Child Task Automation in Snowflake via Task Graph

In the fast-paced world of business, fast, effective data management is crucial. One of the places where this is the...

09 May 2025 12 min read

Anil Kumar Moka in Snowflake

Real-time Data Streaming in Snowflake

Real-time data ingestion has become essential for modern analytics and operational intelligence. Organizations across industries need to process data streams...

08 May 2025 24 min read