EightKB 2026: Registration is Open!
It’s that time of year again! EightKB is back on August 20th at 13:00 UTC, and registration is open right now. It’s completely free. No catch, just a full...
2026-08-06
128 reads
TRY_PARSE Limitations: #SQLNewBlogger
I got a notification from a question I’d posted at SQL Server Central: Getting the Average. A user had posted their repro didn’t work, with no real comment. As...
2026-08-05
74 reads
SQL Server sa Account Security: Rename, Disable & Best Practices
SQL Server sa Account Security: Rename, Disable & Best Practices
In the Windows administration world, it's pretty much a standard practice to rename the local administrator...
2026-08-19 (first published: 2026-08-05)
468 reads
Stanford Emerging Technology Review 2026 Report is out
Artificial Intelligence and quantum computing are two areas of emerging technology that receive most of the tech news. However, the Stanford Emerging Technology Review tries to include any relevant...
2026-08-19 (first published: 2026-08-04)
308 reads
How I Troubleshoot a Slow SQL Server Live
No two SQL Server environments are alike. A fix that resolves a performance issue in one environment may not work in another because every SQL Server instance has different...
2026-08-04
217 reads
T-SQL Tuesday #201 Invitation: Temp Tables, Friend or Foe?
My T-SQL Tuesday #201 invitation. Do temp tables help performance or hurt it? I argue moving data into a #temp table is usually the wrong reflex, and invite you...
2026-08-04
79 reads
Monday Monitor Tips: The MCP Server
I have been experimenting with MCP servers in a few ways, and pressing on our Redgate Monitor team to add one to their system. They did, started adding tools,...
2026-08-14 (first published: 2026-08-03)
449 reads
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK
Every morning somebody on the team runs the same check. Thirty tables in the staging schema, and the only thing anyone wants to...
2026-08-17 (first published: 2026-07-31)
342 reads
A New Word: Mauerbauertraurigkeit
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company you generally enjoy, like a poker player who keeps folding a promising hand in order...
2026-07-31
121 reads
Methodology for dealing with bad data in production
Pinal Dave wrote up his methodology for what to do when you discover bad data in production. If you’ve never been in this situation, having a plan beforehand is...
2026-08-17 (first published: 2026-07-30)
364 reads
Blogs
Accessing the Data API Builder MCP Server from VS Code
By Steve Jones
I recently started playing with the MCP Server for SQL Server, which is a...
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...
Forums
STRING_AGG DISTINCT
Has anyone written a wrapper function (or similar) around STRING_AGG() to allow the retrieval...
In-place OS upgrade or migration to new OS?
Putting this here as we're currently on SQL Server 2019 installed on Windows Server...
Never is Not the Policy
Comments posted to this topic are about the item Never is Not the Policy
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_CustomerPhone
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.CustomerContact rebuildAfter I do this, what will I see for the index status? See possible answers