The New Software Team
Software teams are changing with AI and this might be an exciting time for developers if they take advantage of the capabilities available.
2026-05-22
104 reads
Editorials
Limit the Blast Radius
AI can go off the rails, as we see in a recent story about an LLM deleting a production database.
2026-05-20
121 reads
What Can AI Really Do?
Steve asks you what you think AI can do for you today, with a few suggestions of what he sees.
2026-05-18
132 reads
We Are Eating Our Own Seed Corn
Last week I stood in front of a classroom at Washington State University and looked out at a room full of students who had done everything right. They had studied hard, were earning their degrees, built their portfolios, and showed up with genuine enthusiasm for careers in technology. They wanted to know what the industry […]
2026-05-16
244 reads
Why I Don’t Like Shared Development Databases
Today, Kendra explains why she doesn't like shared development databases.
2026-05-15 (first published: 2020-01-31)
674 reads
Writing Before Reading
We often learn to write code before we really learn to read it, which seems like a problem to Steve.
2026-05-13 (first published: 2020-05-21)
203 reads
Other IDEs
This editorial was originally published on Jun 17, 2020. It is being republished as Steve is out of town. Let us know if you've changed your SQL IDEs since then. Most of us use SSMS (SQL Server Management Studio) to manage our SQL Server instances or to write database code. However, Microsoft does give us […]
2026-05-11 (first published: 2020-06-17)
774 reads
The New Wave of Security Threats
New AI tools are discovering older vulnerabilities in software, as well as new ones. Get ready for a bunch of patches to come out.
2026-05-09
145 reads
There's Too Much to Learn
Steve has thoughts about those of us struggling to keep up with technology changes.
2026-05-08
161 reads
The Dangers of Dependencies
Single points of failure are bad, but what if an employee's action is the single point of failure for access to services? That would be a bad day for any organization.
2026-05-06
165 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