Aaron Bertrand in SQL Server

SQL Server 2025 ZSTD Backup Compression Guide

SQL Server 2025 adds Zstandard (ZSTD) backup compression with LOW, MEDIUM, and HIGH levels. Compare ZSTD vs MS_XPRESS performance, syntax,...

11 June 2025 15 min read

Edward Pollack in SQL Server

TempDB Resource Governor Space Controls in SQL Server 2025: A Complete Guide

SQL Server 2025 introduces the ability to use Resource Governor to help manage TempDB resources automatically. This article dives into...

09 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

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

Edward Pollack in SQL Server

SQL Server Developer Standard Edition: A Gift to Developers!

SQL Server Developer Edition has for years provided a free data platform to test and develop applications in an environment...

21 May 2025 9 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

Laerte Junior in Sysadmin

SQL Server 2022 on Ubuntu 24.04 step by step

Microsoft does not yet support this edition of Ubuntu, but there are some workarounds to make it work. This should...

20 May 2025 5 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

Ben Johnston in SQL Server

A complete guide to Azure SQL Managed Instance server and database configuration options

A tested reference of sp_configure, ALTER DATABASE, and tempdb options that aren't supported in Azure SQL Managed Instance -plus the...

13 May 2025 10 min read

Rodrigo Ribeiro Gomes in Database Administration

Recover SQL Server Data Without Full Backup

Recover deleted or updated SQL Server data without a full backup. Step-by-step guide using transaction log analysis, DBCC PAGE, and...

13 May 2025 33 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

Dennes Torres in T-SQL Programming

Azure SQL Native JSON Data Type: Query Techniques

Explore Azure SQL's native JSON data type with CHECK constraints, JSON_ARRAYAGG, JSON_OBJECTAGG, and JSON_OBJECT functions. These features are coming to...

07 May 2025 16 min read