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 […]
With the popular data transformation tool dbt (data build tool), we have a bunch of interesting features […]
On Friday, April 25, Simple Talk is excited to be a sponsor of PGDay Chicago 2025. This […]
I preface a lot of what I write with whether or not it is for a “practical” […]
On the weekend of April 5, 2025, I attended (and Redgate sponsored) SQL Saturday Richmond. Having lived […]
The Postgres database management system was originally designed as object-relational. We remind why PostgreSQL is an object-relational […]
As started in part 1 of this series, I have set out to test an LLMs ability […]
Database Frontiers is a new database conference hitting the spotlight come October 15th, 2025. Here’s everything you […]
It’s nothing new for vendors to find ways to lock in customers to their products and cloud […]
I spend a lot of editing articles from various authors about a wide variety of topics. I […]
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the […]
“On a scale from 1 to 10, what color is your favorite letter of the alphabet?” –Slogan […]
It’s a tale as old as time. You want to read data. Your mate wants to write […]
A few weeks ago, I delivered some sessions about vector search in Fabric Databases and Azure SQL. […]
On April 5, 2025, Simple Talk will be a sponsor at SQL Saturday #1106 in Richmond Virginia. […]
I was recently on a project to migrate a very transactional installation of SQL Server to Azure […]
Loading data into Snowflake is a common need. Using Python and pandas is a common go-to solution […]
One of the least known, least used features of SQL is the CREATE DOMAIN statement. It does […]
Let’s analyse why we would like to query an SQL Endpoint. Once we understand why, we can […]
In Parts I (Solving the Overlap Query Problem in PostgreSQL) and II (Overlapping Ranges in Subsets […]
A very common task in creating a database is to store string data. For example, words, paragraph(s) […]
This is part of a series of posts from Aisha Bukar comparing MySQL and PostgreSQL. You can […]
The second I wrote down the idea for a blog posts on Distractions, I knew there had […]
if you’re going to work with databases, you probably ought to know something about data. In particular, […]
The holidays truly are over, and it is time to hit the road again here at Simple […]
I wrote about lakehouse maintenance before, about multiple lakehouse maintenances, published videos about this subject and provided […]
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the […]
As a data engineer who’s spent the last few years implementing enterprise-scale security in Snowflake, I’ve witnessed […]
This is part of a series of posts from Chisom Kanu about using MySQL Shell in the […]
The digital landscape is rapidly evolving, and the question has progressed from whether to adopt cloud technology […]
The other day, my lovable coworker and frequent Simple Talk writer: Grant Fritchey, sent this post on […]
Fabric Database was a great announcement during Ignite Conference. The announcement spread all around, a great new […]
One of the cornerstones of AI is a concept called embeddings. Virtually every AI model, whether for […]
I’ve been working in the Azure space for the last few years and less with full server […]
Most anyone who works with indexes should be familiar with B-tree indexes. These are the most commonly […]
There are many functions and tools available to database professionals that can solve data math challenges, regardless […]
I was editing an article the other day that uses the BIT_COUNT function that was added to […]
Let me cut to the chase. If you are like me, you may have been searching for: […]
In this second installment of our series comparing Frappe and Laravel, we probe into critical aspects of […]
I’m very keen on accessibility in computer systems. Nowadays we tend to take a rather superior attitude […]
Recently I had a severe problem with SQL endpoints and I was required to build a quick […]
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the […]
I spent a few weeks away from the office in early January, just like last year, mostly […]
There is a feature of SQL I have not seen used much and probably with good reason. […]
Before jumping into the news and code, let’s start from the beginning: Why does someone use Azure […]
Today’s topic pertains to 99.999% of all people, young, old, and all age ranges . I am […]
The data transformation tool dbt (data build tool) has become more and more popular over the past […]
Part 2 in the series: A Comprehensive Beginners Guide to Configuration with MySQL Shell. In the first […]
Security is important regardless of your industry, whether it’s finance, retail, e-commerce, or the broader world of […]
At first sight, the new Copy Job may seem only one more redundancy: Why do we need […]
A view is a virtual table, created when it’s invoked by the < view name>. The goal […]