How Do the Experts Become Experts?
How do the experts get to that level? A few thoughts today in a guest editorial from Kathi Kellenberger.
2026-06-10
141 reads
How do the experts get to that level? A few thoughts today in a guest editorial from Kathi Kellenberger.
2026-06-10
141 reads
2026-06-08
228 reads
Is a data model important in modern software? Steve thinks it is and gives a few reasons why we might want to spend a little time on ensuring we have good models as we build software.
2026-06-05
150 reads
2026-06-03
105 reads
Lessons on impostor syndrome from a marketer apply to technologists as well.
2026-06-01 (first published: 2022-09-09)
415 reads
A Thank You message to the original founds of the PostgreSQL project and members of the community that have been working so hard for 30 years.
2026-05-30
252 reads
Do meetings and paperwork take a toll on administrators? Steve draws a comparison to some of the changes in the US healthcare system.
2026-05-29 (first published: 2020-10-14)
238 reads
It is not existing knowledge but the skill of acquiring new knowledge rapidly that will help you overcome imposter syndrome.
2026-05-27 (first published: 2020-09-19)
525 reads
Books used to be the source of knowledge, but times have changed.
2026-05-25
182 reads
There I was, walking around Amsterdam, radio in hand (OMG! He's talking about radios again!), automatically transmitting Active Packet Report System (APRS) signals every 90 seconds. Same radio I had used in Chicago a couple of weeks ago and in Poland last week. I was on the correct frequency and, as I say, I had […]
2026-05-23
155 reads
If you spend your days tuning queries, managing pipelines, or keeping a production database...
I’ve been rebuilding my three-site SQL Server demo lab, and I ran into something...
By SQLPals
SQL Server gMSA: Why DBAs Still Aren't Using It in 2026 ...
Putting this here as we're currently on SQL Server 2019 installed on Windows Server...
Comments posted to this topic are about the item Never is Not the Policy
Comments posted to this topic are about the item Automating SSAS Multidimensional Security Audits...
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