Microsoft MVP 2026: Ten Years on the Data Platform
I’m honored to announce that I’ve been renewed as a Microsoft MVP for the tenth consecutive year, recognized in the Azure SQL and SQL Server technical areas under Data...
2026-07-16
37 reads
Blog Posts
Azure – HorizonDB
As Open Source – PostgreSQL and AI is a growing and powerful DB system, AWS and Google already have AWS Aurora and Google AlloyDB, which are Cloud Native PostgreSQL...
2026-07-15 (first published: 2026-07-14)
91 reads
Building AgentDBA’s Slack Escalation
Until now, a CRITICAL finding did the right internal routing, but the last mile was a log line — useful for an audit trail, useless at 3am. v1.2.0 closes...
2026-07-15
27 reads
Changing the Owner Removes Permissions: #SQLNewBlogger
This is actually inspired by an article SQL Server Central, which taught me something new. I decided to verify what was in the article and do some research. The...
2026-07-15
65 reads
Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables
Every PostgreSQL migration eventually hits the same fork in the road. The database is small enough to dump and restore in a maintenance window, or it isn't. Once you...
2026-07-15 (first published: 2026-07-03)
215 reads
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly invisible to many. Those countless sleepness nights are a testament to our dedication. Whether that...
2026-07-15 (first published: 2026-07-06)
579 reads
The “best” tool
I had a question the other day that constantly pops up on my feed whether it’s on social media or people asking Q&A at a conference etc. And that...
2026-07-15 (first published: 2026-07-13)
26 reads
A New Chapter: Why I Made the Move from Dayforce to ESO
A New Chapter: Why I Made the Move from Dayforce to ESO Over the past several weeks, many of you have probably noticed subtle hints throughout my blog. A...
2026-07-14
18 reads
DataSaturday Rheinland – Slides
The slides for my session “The €100 data warehouse on the Azure data platform” can be found on GitHub. It was a calm event, probably because of the good...
2026-07-14
12 reads
Lean Six Sigma – Brief
When you have a project or system, it has to be optimized, tuned, and we must ensure it is consistently performing better. For this, we should use the Lean...
2026-07-14
17 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
Kontak BCA KCP Semanggi Telp:08218154392
WA CS (08218154392) Wisma GKBI, Jl. Jenderal Sudirman No.28 Suite G 01, RT.14/RW.1, Bend....
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