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 Blogs

Managed Instance Gotchas – Configuration Items

In my last post I described issues that might stop your migration to a SQL Server Managed Instance (SQL MI)....

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

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

Techniques to query Azure SQL’s new JSON Datatype

The new JSON field type and new functions in Azure SQL brings a new world of possibilities for JSON manipulation...

07 May 2025 15 min read

Lukas Vileikis in MySQL

MySQL Index Overviews: Hash Indexes

Welcome back to the MySQL indexing series! We’ve already covered the nuances surrounding indexes in MySQL as well as walked...

06 May 2025 14 min read

Matt Gantz in T-SQL Programming

Purging Data from a Large Table in SQL Server

Purging data from a table is a common database maintenance task to prevent it from growing too large or to...

01 May 2025 8 min read

Robert Sheldon in MongoDB

Working with the MongoDB Database Tools

The MongoDB Database Tools are a set of command-line utilities for working with MongoDB instances and their data. You can...

29 April 2025 16 min read

Image showing blocks with different faces on (happy, excited, sad, etc)

Louis Davidson in T-SQL Programming

Exploring the SQL Server CHOOSE Function

I preface a lot of what I write with whether or not it is for a “practical” use. One of...

21 April 2025 39 min read

Boris Novikov in PostgreSQL

A Method for Managing Hierarchies in PostgreSQL

The Postgres database management system was originally designed as object-relational. We remind why PostgreSQL is an object-relational rather than just...

17 April 2025 22 min read