Who Are You Doing It For?
But as I've matured over the years, I came to realize that I needed to ask a critical question, "Who am I doing this for?" When I agree to...
2026-04-10 (first published: 2026-03-30)
216 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
23 reads
Finding the Next Sequence Value: #SQLNewBlogger
I saw a question asking about the next sequence value and decided to try and answer it myself. I assumed this would be easy, and it was, but I...
2026-04-15 (first published: 2026-03-30)
188 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)
28 reads
Google Moves Up Post-Quantum Cryptography Timeline
In cryptography, the RSA and ECC algorithms which we use primarily for asymmetric cryptography are susceptible to Shor's Algorithm in quantum cryptography. Cracking those algorithms with classical computing is...
2026-04-08 (first published: 2026-03-27)
299 reads
The Book of Redgate: No Politics
In today’s world, this might mean something different, but in 2010, we had this value: In our context, this was about being open and transparent. This is the text...
2026-03-27
46 reads
The Burrito Bot: AI-Powered Search in SQL Server 2025
A while back I posted about a couple of side projects that I’ve been working on when I get the chance. One of those was the Burrito Bot…a bot...
2026-04-06 (first published: 2026-03-27)
375 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)
20 reads
Announcements from the Microsoft Fabric Community Conference
A ton of new features for Microsoft Fabric were announced at the Microsoft Fabric Community Conference (FabCon Atlanta 26) last week (see the FabCon keynote here). There were 8000 attendees! Here...
2026-04-08 (first published: 2026-03-26)
1,488 reads
PowerShell Remoting for SQL DBAs: WinRM + SSH Guide (Updated 2026)
PowerShell Remoting for SQL DBAs: WinRM + SSH Guide (Updated 2026)
Originally published in 2023, this post never made it into Google's index, so I'm republishing it...
2026-04-03 (first published: 2026-03-26)
548 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