Louis Davidson in Editorials

Having no idea where to start

I think this is my favorite idea for a blog post, because the idea for this blog came about when...

07 April 2025 4 min read

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 Blogs

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

Louis Davidson in Conferences

Sponsoring SQL Saturday Richmond This Week

On April 5, 2025, Simple Talk will be a sponsor at SQL Saturday #1106 in Richmond Virginia. Having worked for...

31 March 2025 2 min read

Ben Johnston in Blogs

Managed Instance Gotchas – Error Conditions

I was recently on a project to migrate a very transactional installation of SQL Server to Azure SQL Managed Instance...

31 March 2025 9 min read

Anil Kumar Moka in Snowflake

Load Data into Snowflake Using Python with Pandas

Loading data into Snowflake is a common need. Using Python and pandas is a common go-to solution for data professionals....

30 March 2025 16 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 Blogs

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

Mercy Bassey in DevOps

The Concepts of TestOps

There’s no way you talk about software without mentioning testing or software testing. No software should ever be shipped if...

21 March 2025 18 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

Louis Davidson

Distractions

The second I wrote down the idea for a blog posts on Distractions, I knew there had to be two...

17 March 2025 5 min read

John Kerski in Cloud

The complexity of using Power BI in US Sovereign Clouds

“I hate to tell you this, but it’s not available for us yet.” This is an all-too-common phrase I find...

13 March 2025 7 min read

Bravin Wasike in DevOps

Securing the DevOps Pipeline Part 1: Tools and Strategies for Safer Deployments

Protecting Your CI/CD from Build-Time Threats DevOps has transformed software delivery, but with rapid deployments come increased security risks. As...

12 March 2025 16 min read

Kathi Kellenberger in Featured

Introduction to GitHub Actions Part 1: Getting Started

GitHub is one of the most popular services on the planet for storing documents. That includes everything from PowerPoint presentations...

11 March 2025 5 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

Louis Davidson in Blogs

Simple Talk on the Road In March

The holidays truly are over, and it is time to hit the road again here at Simple Talk. In March...

06 March 2025 3 min read

Dennes Torres in Blogs

How Shortcuts affect Lakehouse’s Maintenance

I wrote about lakehouse maintenance before, about multiple lakehouse maintenances, published videos about this subject and provided sample code about...

05 March 2025 3 min read

Register for Simple Talk

Articles

Having no idea where to start

Data Quality: The Foundation for Business Agility and Growth

Multi-Version Concurrency Control (MVCC) in PostgreSQL: Learning PostgreSQL with Grant

Fabric Database: Advanced Vector Search Features

Sponsoring SQL Saturday Richmond This Week

Managed Instance Gotchas – Error Conditions

Load Data into Snowflake Using Python with Pandas

The CREATE DOMAIN Statement

Fabric: Query a SQL Endpoint from a Notebook

The Wide World of GiST Indexes

The Concepts of TestOps

MySQL vs PostgreSQL – String Datatypes

MySQL vs. PostgreSQL: Character Sets and Collations

Distractions

The complexity of using Power BI in US Sovereign Clouds

Securing the DevOps Pipeline Part 1: Tools and Strategies for Safer Deployments

Introduction to GitHub Actions Part 1: Getting Started

Scales & Measurements

Simple Talk on the Road In March

How Shortcuts affect Lakehouse’s Maintenance