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
28 reads
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the invitation post, I intentionally kept the prompt broad because change detection looks different depending on...
2026-06-05 (first published: 2026-05-19)
512 reads
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
16 reads
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
46 reads
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
29 reads
As part of my wider work exploring Claude Code and AI-assisted database engineering, I have been looking at how AI can support SQL Server operations. A failed job, missed...
2026-06-03 (first published: 2026-05-17)
503 reads
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is paying off. In Week 1, we learned that quotes are not interchangeable. In Week 2,...
2026-06-03 (first published: 2026-05-18)
433 reads
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
39 reads
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
14 reads
It’s time for T-SQL Tuesday again! And we’re almost to number 200! T-SQL Tuesday is a monthly community blogging event started by Adam Machanic in 2009. Each month a...
2026-06-02
25 reads
It is Friday, the queries are running, and nobody is watching the bill. That...
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Comments posted to this topic are about the item Changes, Happiness, and a Few...
Comments posted to this topic are about the item BCP on Linux
Comments posted to this topic are about the item You Probably Don't Need a...
When running bcp on Linux, what is the field terminator?
See possible answers