KDA: Echoes of Deception - Case 7
A fugitive cyber-criminal, a wingsuit, and 24 million flight records. Somewhere between Doha and Dublin, Krypto jumped between planes mid-air.
2026-07-24 (first published: 2026-07-16)
140 reads
Do This Before You Contact Your SQL Server Consultant
Say you need outside help. You’ve exhausted all the things that you could do and, still, nothing works. So, you decide that calling in for help is the next...
2026-07-24 (first published: 2026-07-16)
504 reads
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
52 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
39 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
81 reads
T-SQL Tuesday #200 - I Bet It's Bad if I See...
T-SQL Tuesday is a monthly blog party hosted by a different community member each month. This month, Brent Ozar
(blog) asks us to fill in the blank:
When I’m looking at...
2026-07-14
37 reads
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)
99 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
32 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
23 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
17 reads
Blogs
From DBA or Data Engineer to AI Engineer: A Realistic Path
If you spend your days tuning queries, managing pipelines, or keeping a production database...
Asynchronous Replication of Snapshots from an ActiveCluster Pod to a Third Array
I’ve been rebuilding my three-site SQL Server demo lab, and I ran into something...
SQL Server gMSA: Why So Many DBAs Still Aren't Using It in 2026
By SQLPals
SQL Server gMSA: Why DBAs Still Aren't Using It in 2026 ...
Forums
Never is Not the Policy
Comments posted to this topic are about the item Never is Not the Policy
Automating SSAS Multidimensional Security Audits with PowerShell
Comments posted to this topic are about the item Automating SSAS Multidimensional Security Audits...
Rebuilding All Indexes
Comments posted to this topic are about the item Rebuilding All Indexes
Question of the Day
Rebuilding All Indexes
I have added a few indexes to one of my tables in SQL Server 2025:
ALTER TABLE dbo.CustomerContact
ADD CONSTRAINT PK_CustomerContact
PRIMARY KEY (CustomerID);
-- Create index on CustomerEmail
CREATE INDEX IX_CustomerContact_CustomerEmail
ON dbo.CustomerContact (CustomerEmail);
CREATE INDEX IX_CustomerContact_CustomerEmail
ON dbo.CustomerContact (phone);
I then do this to disable one index:
alter index IX_CustomerContact_CustomerPhone on dbo.CustomerContact disableI see this when I check the index status:
I decide to rebuild all indexes with this command:
ALTER INDEX ALL ON dbo.CustomerContactAfter I do this, what will I see for the index status? See possible answers