Introduction to PostgreSQL for the Data Professional
Learning something new has elements of bliss and terror. We all know the bliss of learning something […]
simple-talk.com
Managed Instance Gotchas – Configuration Items
In my last post I described issues that might stop your migration to a SQL Server Managed […]
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 […]
Jacksonville SQL Saturday 2025 Roundup
Are SQL Saturdays finally back to the way they should be? This past weekend in Jacksonville Florida […]
MySQL Index Overviews: Hash Indexes
Welcome back to the MySQL indexing series! We’ve already covered the nuances surrounding indexes in MySQL as […]
Data-Based Movie Reviews: Moneyball
A while back, a friend of mine, who is big into baseball, tried to encourage me to […]
Query Lineage in Fabric Lakehouses
I already wrote about query performance analysis in lakehouses, but one secret was left behind: The capability […]
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 […]
Sponsoring PGDay Chicago this week
On Friday, April 25, Simple Talk is excited to be a sponsor of PGDay Chicago 2025. This […]
Exploring the SQL Server CHOOSE Function
I preface a lot of what I write with whether or not it is for a “practical” […]
SQL Saturday Richmond Roundup
On the weekend of April 5, 2025, I attended (and Redgate sponsored) SQL Saturday Richmond. Having lived […]
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 […]
LLM Technical Editor Test – ChatGPT with a VERY wrong ...
As started in part 1 of this series, I have set out to test an LLMs ability […]
Announcing Database Frontiers: a Database Conference You Haven’t Yet Heard ...
Database Frontiers is a new database conference hitting the spotlight come October 15th, 2025. Here’s everything you […]
Oracle’s Limited Cloud Vendor Licensing
It’s nothing new for vendors to find ways to lock in customers to their products and cloud […]
New Series – Testing LLMs as Technical Editors
I spend a lot of editing articles from various authors about a wide variety of topics. I […]
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 […]
Fabric Database: Advanced Vector Search Features
A few weeks ago, I delivered some sessions about vector search in Fabric Databases and Azure SQL. […]
Sponsoring SQL Saturday Richmond This Week
On April 5, 2025, Simple Talk will be a sponsor at SQL Saturday #1106 in Richmond Virginia. […]
Managed Instance Gotchas – Error Conditions
I was recently on a project to migrate a very transactional installation of SQL Server to Azure […]
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 […]
The CREATE DOMAIN Statement
One of the least known, least used features of SQL is the CREATE DOMAIN statement. It does […]
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 […]
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) […]
MySQL vs. PostgreSQL: Character Sets and Collations
This is part of a series of posts from Aisha Bukar comparing MySQL and PostgreSQL. You can […]
Distractions
The second I wrote down the idea for a blog posts on Distractions, I knew there had […]
Scales & Measurements
if you’re going to work with databases, you probably ought to know something about data. In particular, […]
Simple Talk on the Road In March
The holidays truly are over, and it is time to hit the road again here at Simple […]
How Shortcuts affect Lakehouse’s Maintenance
I wrote about lakehouse maintenance before, about multiple lakehouse maintenances, published videos about this subject and provided […]
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 […]
Crazy number of Parameters… and a challenge
The other day, my lovable coworker and frequent Simple Talk writer: Grant Fritchey, sent this post on […]
Fabric Databases Connection Secrets
Fabric Database was a great announcement during Ignite Conference. The announcement spread all around, a great new […]
AI in SQL Server 2025: Embeddings
One of the cornerstones of AI is a concept called embeddings. Virtually every AI model, whether for […]
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 […]
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 […]
SQL Server BIT_COUNT and an Alternative
I was editing an article the other day that uses the BIT_COUNT function that was added to […]
Dark Mode in SSMS 21 and overall first impressions
Let me cut to the chase. If you are like me, you may have been searching for: […]
Frappe and Laravel: Database Management and Migrations
In this second installment of our series comparing Frappe and Laravel, we probe into critical aspects of […]