The 2026 Redgate Summit in New York City
We’re coming back to New York, which is exciting for me. I love NYC. The Redgate Summit 2026 – New York City comes back on May 5, 2026. You...
2026-04-03 (first published: 2026-03-25)
173 reads
Blog Posts
Finding and Updating Duplicate IDs: #SQLNewBlogger
Finding duplicates was an interview question for me years ago, and I’ve never forgotten it. Recently I got asked how to easily do this and delete them, so I...
2026-04-01 (first published: 2026-03-18)
232 reads
Monitoring Fabric Mirroring for SQL 2025
I previously wrote about how the underlying technology for Fabric mirroring changed with SQL Server 2025. The latest version of mirroring that uses the SQL Server Change Feed is...
2026-04-01 (first published: 2026-03-24)
354 reads
“We love to debate minutiae”
I am guilty as charged. The quote was in reference to how people argue about details in fitness or finances that are more detailed than is useful to them....
2026-03-30 (first published: 2026-03-13)
203 reads
From Planning to Practice: Setting Up Your FinOps Framework
As someone who works in DevOps, I’m always focused on creating systems that are efficient, scalable, and reliable. But when it comes to the cloud, one critical piece often...
2026-03-30 (first published: 2026-03-15)
200 reads
Presenting Twice in May 2026
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person twice in May 2026. With summer vacations coming up, this is a perfect time of...
2026-03-30
20 reads
SQL Server Journey Part 2: Modern Era (2017 – 2026) – AI/Cloud First
Following up on my Part 1 baseline, the journey from 2017 onward changed how we look at the “Engine.” We moved from Service Packs to a faster world of...
2026-03-28 (first published: 2026-03-27)
26 reads
AI: Blog a Day – Day 6: Embeddings – How AI Understands
Continuing from Day 5 where we covered notebooks, HuggingFace and fine tuning AI now Day 6 is inside of AI , how AI understand us, as computer do not...
2026-03-27 (first published: 2026-03-06)
201 reads
EightKB 2026
EightKB is back again for 2026! The biggest online SQL Server internals conference is back…it’s all happening on August the 20th! We’ve open our call for speakers, you can...
2026-03-27 (first published: 2026-03-18)
213 reads
SQL Server Journey (Part 1)- Enterprise Database 2016
Continued thinking about my Journey blog where we have to look back at the revolutionary of SQL Server till SQL Server 2025. I would like to brief more on...
2026-03-27 (first published: 2026-03-26)
17 reads
Blogs
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
A New Word: Mauerbauertraurigkeit
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
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...
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
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