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

Louis Davidson in Career

What about Loyalty?

My last editorial asked the question, “What is your price?” The point is that everyone has a situation right now...

02 June 2025 5 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

Dennes Torres in Blogs

Using Parameters with DAX in Report Builder

This is something we expect to be simple, but it has a lot of secrets. Using parameters in DAX queries...

29 May 2025 4 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

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

Louis Davidson in Conferences

SQL Saturday Raleigh 2025 Roundup

Phew, this is the end of a run of events with little time between them. You know what though, despite...

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

Louis Davidson

First LLM Technical Editor Test – Office and Web-based Copilot with a VERY wrong article

Next up, I am going to give Microsoft Copilot its chance to check for technical inaccuracies in my obviously very...

19 May 2025 19 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

Louis Davidson in Books

Introduction to PostgreSQL for the Data Professional

Learning something new has elements of bliss and terror. We all know the bliss of learning something new. The first...

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

Register for Simple Talk

Articles