State Transition Constraints
About two decades ago, I introduced the concept of transition constraints to show Data Validation in a […]
Featured
Oracle ASM: Monitoring and Managing (Part 2)
In the first part of this series, we explored the fundamentals of Oracle Automatic Storage Management (ASM)—a […]
Replacing a Column in a Large Active SQL Server Table
In a previous post I showed how to use a batching strategy to remove large amounts of […]
Getting started with Azure Database for PostgreSQL Flexible Server
Along with its many other cloud services, Microsoft now offers Azure Database for PostgreSQL Flexible Server, a […]
DevOps vs. SRE: Bridging the Gap, Not Building Walls (Part ...
Understanding the Divide — DevOps vs. SRE Explained The conversation around DevOps versus Site Reliability Engineering (SRE) […]
Replicating MySQL databases in Docker Containers
In my prior article, “Running a relational database with Docker”, I showed how to spin up a […]
SQL Server 2025 : Zstandard Backup Compression
This article is part of a series of posts on the forthcoming SQL Server 2025 release. Once […]
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 […]
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 […]
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. […]
Moving from SQL to MongoDB’s MQL
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the […]
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 […]
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 […]
Data Encoding Schemes
You probably noticed that when you get a bill or bank statement, it uses the current modern […]
SQL Server 2025 is in Public Preview!
On Monday, May 19, 2025, SQL Server 2025 was announced as finally going to be in public […]
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 […]
MySQL Shell Basic Configuration Management (Part 4 – Optimizing MySQL ...
Welcome back to our journey of understanding MySQL performance tuning using MySQL Shell. So far, we’ve covered […]
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 […]
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 […]
Real-time Data Streaming in Snowflake
Real-time data ingestion has become essential for modern analytics and operational intelligence. Organizations across industries need to […]
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 […]
MySQL Index Overviews: Hash Indexes
Welcome back to the MySQL indexing series! We’ve already covered the nuances surrounding indexes in MySQL as […]
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 […]
Working with the MongoDB Database Tools
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the […]
How to Load a Date Dimension in Microsoft Fabric using ...
With the popular data transformation tool dbt (data build tool), we have a bunch of interesting features […]
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 […]
Oracle’s Limited Cloud Vendor Licensing
It’s nothing new for vendors to find ways to lock in customers to their products and cloud […]
Working with MongoDB Shell
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the […]
Data Elements on a Nominal Scale
“On a scale from 1 to 10, what color is your favorite letter of the alphabet?” –Slogan […]
Multi-Version Concurrency Control (MVCC) in PostgreSQL: Learning PostgreSQL with Grant
It’s a tale as old as time. You want to read data. Your mate wants to write […]
The CREATE DOMAIN Statement
One of the least known, least used features of SQL is the CREATE DOMAIN statement. It does […]
The Wide World of GiST Indexes
In Parts I (Solving the Overlap Query Problem in PostgreSQL) and II (Overlapping Ranges in Subsets […]
MySQL vs PostgreSQL – String Datatypes
A very common task in creating a database is to store string data. For example, words, paragraph(s) […]
Scales & Measurements
if you’re going to work with databases, you probably ought to know something about data. In particular, […]
Importing and exporting data in MongoDB Compass
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the […]
Implementing Enterprise Data Security in Snowflake: Practical Concepts
As a data engineer who’s spent the last few years implementing enterprise-scale security in Snowflake, I’ve witnessed […]
MySQL Shell Basic Configuration Management (Part 3 – Disk I/O ...
This is part of a series of posts from Chisom Kanu about using MySQL Shell in the […]
Beyond Single-Cloud: A Peek into Multi-Cloud
The digital landscape is rapidly evolving, and the question has progressed from whether to adopt cloud technology […]
AI in SQL Server 2025: Embeddings
One of the cornerstones of AI is a concept called embeddings. Virtually every AI model, whether for […]
MySQL Index Overviews: Descending B-Tree Indexes
Most anyone who works with indexes should be familiar with B-tree indexes. These are the most commonly […]
Exploring Scalar Solutions to Complex Data Math
There are many functions and tools available to database professionals that can solve data math challenges, regardless […]
Accessibility, and the Need for Ingenious Simplicity in Computer Scripts, ...
I’m very keen on accessibility in computer systems. Nowadays we tend to take a rather superior attitude […]
Creating Time Series Collections in MongoDB
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the […]
Temporary Tables
There is a feature of SQL I have not seen used much and probably with good reason. […]
Loading Models from Source Data with dbt
The data transformation tool dbt (data build tool) has become more and more popular over the past […]
MySQL Shell and Basic Configuration Management (Part 2 – Memory ...
Part 2 in the series: A Comprehensive Beginners Guide to Configuration with MySQL Shell. In the first […]
VIEW Objects
A view is a virtual table, created when it’s invoked by the < view name>. The goal […]
Customizing the Export and import of Parquet Files in SQL ...
Previously, we introduced and discussed the Parquet file format and SQL Server and why it is an […]
Oracle Architecture Overview
I often fall back to the tried-and-true methods to understanding Oracle environments. Yes, sometimes the older ways […]
Five changes to SQL Server I’d love to see
I’ve had lots of wish lists over the years, from Ladybug to Connect to UserVoice, and very […]