When mirroring was first released for Azure SQL Database, it used Change Data Capture (CDC). That is still what is used to mirror SQL Server 2016 – 2022. SQL...
2026-03-25 (first published: 2026-03-11)
261 reads
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released patches for SQL Server to address privilege escalation vulnerabilities in supported versions. Time to patch!
2026-03-25 (first published: 2026-03-12)
446 reads
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-03-25 (first published: 2026-03-24)
17 reads
A while ago I blogged about a use case where a pipeline fails during debugging with a BadRequest error, even though it validates successfully. If you’re wondering, this is...
2026-03-23 (first published: 2026-03-06)
171 reads
Continuing from Day 6 we learned Embeddings, Semantic Search and Checks, on Day 7 we would learn about Vectors and Vector Databases. this is a place where AI data...
2026-03-23 (first published: 2026-03-07)
282 reads
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-23 (first published: 2026-03-18)
20 reads
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-03-23 (first published: 2026-03-18)
12 reads