Image of author: Ganesh Gopal Masti Jayaram

Ganesh Gopal Masti Jayaram in Databases

Data Quality: The Foundation for Business Agility and Growth

We live in a world awash with vast amounts of data. Today’s modern enterprises generate and rely on vast amounts...

04 April 2025 14 min read

Grant Fritchey in PostgreSQL

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 data. You’re stepping...

02 April 2025 15 min read

Dennes Torres in Microsoft Fabric

Fabric Database: Advanced Vector Search Features

A few weeks ago, I delivered some sessions about vector search in Fabric Databases and Azure SQL. Let’s talk about...

02 April 2025 6 min read

Ben Johnston in Databases

5 key problems from a SQL Server to Azure SQL Managed Instance migration (and how to avoid them)

Planning an Azure SQL Managed Instance migration? Here are five surprises a real transactional SQL Server move uncovered - and...

31 March 2025 10 min read

Anil Kumar Moka in Snowflake

Loading Data into Snowflake with Python and Pandas: write_pandas, DataFrame to Table, and File-Based Loading

Loading data into Snowflake using Python and pandas - connecting via the Snowflake Python Connector, writing DataFrames to tables with...

30 March 2025 17 min read

Joe Celko in Theory and design

The CREATE DOMAIN Statement

One of the least known, least used features of SQL is the CREATE DOMAIN statement. It does not exist in...

27 March 2025 6 min read

Dennes Torres in Microsoft Fabric

Fabric: Query a SQL Endpoint from a Notebook

Let’s analyse why we would like to query an SQL Endpoint. Once we understand why, we can dig into how...

26 March 2025 5 min read

Lee Asher in PostgreSQL

The Wide World of GiST Indexes

In Parts I (Solving the Overlap Query Problem in PostgreSQL) and II (Overlapping Ranges in Subsets in PostgreSQL) of...

25 March 2025 15 min read

Aisha Bukar in MySQL

MySQL vs PostgreSQL – String Datatypes

A very common task in creating a database is to store string data. For example, words, paragraph(s) or even documents....

20 March 2025 22 min read

Aisha Bukar in MySQL

MySQL vs. PostgreSQL: Character Sets and Collations

When working with strings in a database system, you need to ensure that the data is stored, sorted, and compared...

17 March 2025 18 min read

Joe Celko in Theory and design

Scales & Measurements

If you’re going to work with databases, you probably ought to know something about data. In particular, we don’t put...

07 March 2025 11 min read

Robert Sheldon in MongoDB

Importing and exporting data in MongoDB Compass

When working with MongoDB, you’ll likely need to import or export document data from time-to-time. You can use MongoDB Compass...

05 March 2025 16 min read

Anil Kumar Moka in Snowflake

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 firsthand how challenging...

04 March 2025 16 min read

Chisom Kanu in MySQL

MySQL Shell Basic Configuration Management (Part 3 – Disk I/O and Storage Optimization)

So far, in our previous articles on MySQL optimization, we’ve looked at basic configuration management and memory and CPU tuning...

27 February 2025 15 min read

Louis Davidson in T-SQL Programming

Crazy number of Parameters… and a challenge

The other day, my lovable coworker and frequent Simple Talk writer: Grant Fritchey, sent this post on X: So I...

24 February 2025 35 min read

Rodrigo Ribeiro Gomes in T-SQL Programming

SQL Server 2025 Embeddings: AI Vector Search Explained

Understand embeddings and vector search in SQL Server 2025. Learn how to convert text to numerical vectors, calculate similarity with...

18 February 2025 48 min read

Ben Johnston in SQL Server

SQL Server 2022 CU Updates and Error Code 0x851A0043

I’ve been working in the Azure space for the last few years and less with full server installations. Azure leaves...

18 February 2025 5 min read

Lukas Vileikis in MySQL

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 used data structures...

13 February 2025 11 min read

Edward Pollack in T-SQL Programming

Exploring Scalar Solutions to Complex Data Math

There are many functions and tools available to database professionals that can solve data math challenges, regardless of complexity. A...

12 February 2025 17 min read

Kellyn Pot'Vin-Gorman

What is Oracle RAC and Why Use it for Scaling Workloads?

Oracle Real Application Clusters (RAC) is a database clustering solution that enables multiple servers to operate as a single, unified...

10 February 2025 6 min read