My Toolbox - AI
I trusted AI to redesign this entire blog. The layout, the CSS, the deployment pipeline, the shortcodes. I use it to build home automation, organize my notes, fix my...
2026-06-24 (first published: 2026-06-07)
350 reads
From SQL Saturday to Day of Data
A behind-the-scenes look at Day of Data Jacksonville 2026, the transition from SQL Saturday, and everything that went right—and wrong—along the way.
2026-06-26 (first published: 2026-06-06)
137 reads
PostgreSQL 18 Finally Makes BUFFERS the Default. Here Is Why That Matters
You run EXPLAIN ANALYZE on a slow query, stare at the plan, and something still feels off. The estimated rows look reasonable, the node timings add up, but you...
2026-06-05
38 reads
A New Word: La Guadière
la guadière – n. a glint of goodness you notice in something that you wouldn’t expect, which is often only detectable by sloshing them back and forth in your...
2026-06-05
32 reads
Microsoft Purview data governance best practices
Microsoft Purview can be the best data governance tool in the world, but it will still be useless if people do not know it exists, do not trust the...
2026-06-04
84 reads
AI Insights for Database Monitoring: A DBA’s Perspective
Second in a series on Ai and databases. One Story, three signals – I have a backup of a critical database that has failed three times, the recovery point...
2026-06-05 (first published: 2026-06-04)
32 reads
Crash-Consistent MongoDB Snapshot and Restore with Everpure Fusion
I’ve been working on a project that combines two things I spend a lot of time with: MongoDB sharded clusters and Everpure FlashArrays. The goal is a production-grade backup...
2026-06-04
27 reads
AI and Data Engineering on the Edge: The Good, the Bad, and the Overhyped
Running AI and data pipelines on the edge instead of the cloud has gone from a niche embedded concern to a default option on a lot of architecture diagrams....
2026-06-03
32 reads
UNION vs UNIONALL: #SQLNewBlogger
While writing another post I realized my UNION query didn’t work as one might initiall expect, so I decided a short post was worth writing. This is based on...
2026-06-03
42 reads
Deciphering Data Architectures Is Now Available in Multiple Languages
Since the release of my book Deciphering Data Architectures: Choosing Between a Modern Data Warehouse, Data Fabric, Data Lakehouse, and Data Mesh, I’ve been fortunate to hear from readers...
2026-06-02
19 reads
Blogs
Methodology for dealing with bad data in production
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
How to Provision an Azure SQL Database
Aside from spinning up a SQL Server instance container, the free Azure SQL Database...
Claude finds two cryptographic weaknesses (but the sky isn’t falling)
By Brian Kelley
If you haven't seen the announcement, Anthropic was able to utilize Claude (Mythos Preview)...
Forums
Why SQL Server Database Attach fails and how to repair it
Comments posted to this topic are about the item Why SQL Server Database Attach...
Fixing P1 Queries
Comments posted to this topic are about the item Fixing P1 Queries
BIT_COUNT() IV
Comments posted to this topic are about the item BIT_COUNT() IV
Question of the Day
BIT_COUNT() IV
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers