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 […]
Featured
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 […]
Introduction to MySQL Shell and Basic Configuration Management (Part 1)
The database is an important part of any application and setting it up correctly is key to […]
Frappe’s Configuration vs Laravel’s Code-Centric Customisation
This article compares the Frappe and the Laravel frameworks, focusing on key technical differences in customization, database […]
When Should You Employ Snowflake Materialized Views?
I’ve used both Snowflake views and materialized views with varying degrees of success. Both have their place […]
A gentle introduction to dbt
In a typical data warehouse project, data is loaded, transformed and stored into a data store using […]
Introduction to Oracle Database for Database Professionals
Oracle Database, often referred to simply as Oracle, is one of the most powerful and widely used […]
MySQL Index Deep Dive: Clustered B-Tree Indexes
If you’re a frequent reader of the Simple-Talk blog, you’re no stranger to indexes as we’ve covered […]
Overlapping Ranges in Subsets in PostgreSQL
In Part I of this series, we explored overlap queries and the problems that accompany them, along […]
Working with MongoDB Indexes
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the […]
Essential Strategies for Optimizing Snowflake Performance and Reducing Costs
In today’s data-driven enterprise environment, businesses increasingly rely on Snowflake’s cloud data warehouse for handling large-scale data […]
Hiring and Motivating Technical Polyglots in Data Analytics
In this article, I will discuss hiring and motivating technical polyglots. A polyglot is a person who […]
Breaking Down Ignite: A Pragmatic Look at the Conference’s Best ...
The amount of news brought by Ignite is huge. I was not expecting to find so many […]
Reading and Writing Parquet Files in SQL Server
When analytic data is stored directly in SQL Server, a clustered columnstore index is an ideal place […]
Data Control Language (aka Security)
Like ancient Gaul, SQL is divided into three sub- languages. The DDL (Data Declaration Language) declares the […]
Demystifying Continuous Integration vs. Continuous Delivery: Part 2
Welcome to part 2 of our Demystifying Continuous Integration vs. Continuous Delivery series. In Part 1 of […]
Connecting to MongoDB through Python
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the […]
AI and Databases
Although it is probably true to say that “AI is reshaping the landscape of database technology“, it’s […]
Transactions
By now, pretty much everyone has heard the stories about the first computers. They were huge, cost […]
MySQL Index Overviews: FULLTEXT B-Tree Indexes
If you’ve been following Simple Talk for a while, you know that we’re fans of databases and […]
How To Embed Your Azure Logic Apps in a Metadata-driven ...
In this article, I am going to explain how you can dial your productivity up to 11 […]
Consistency and Concurrency in NewSQL Database Systems
Companies today require database systems that are reliable and capable of efficiently handling large volumes of data […]
Creating Views in MongoDB
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the […]
Quick Tricks to Make Your Power BI Model Smaller, More ...
Power BI has been a leading data visualization tool in the market for years. It can be […]
Frappe and ERPNext: Leveraging ERP Capabilities for Business Solutions (Part ...
In business operations and management, the integration of large Enterprise Resource Planning (ERP) systems has become paramount. […]
Rounding Numbers
I would hope by now everybody has figured out when you see a price like $39.99 that […]
Boosting Database Development Efficiency Using AI SQL Code Generators
Database development has become more complex over the years due to the introduction of new data and […]
How To Use Managed Identities in your Azure Logic Apps
Azure Logic Apps are a cloud-based service where you can create low code workflows to automate your […]
AWS Services Using SQL for Big Data Analysis
SQL’s ability to manipulate data makes it relevant for people creating tools for data analysis. Analysts can […]
Working with Schema Validation in MongoDB
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the […]
Database Sharding: Strategies for Seamless Scaling and Performance Optimization
Companies of all sizes and across industries are struggling to cope with an explosion of data never […]