Introduction Building a practical data governance framework can feel like building a house: you need a strong foundation, reliable materials, and the right team to make it all work. Data governance is crucial for organizations to manage, protect, and utilize their data effectively. A well-defined framework...
2025-02-13
20 reads
The post Data Governance: The Invisible AI Accelerator appeared first on Joyful Craftsmen.
2025-01-31 (first published: 2025-01-20)
283 reads
The post Challenges Enterprises Face When Adopting AI appeared first on Joyful Craftsmen.
2025-01-22 (first published: 2025-01-14)
322 reads
The post The pros and cons of self-service BI: What every industry leader should know appeared first on Joyful Craftsmen.
2025-01-20 (first published: 2024-11-04)
748 reads
2025-01-16
10 reads
2025-01-09
10 reads
Ut enim ad minim veniam, quis nostrud exercitation ullamco labo-
ris nisi ut aliquip ex ea commodo consequat.
2025-01-09
9 reads
The post Data Strategy Checklist for 2025 appeared first on Joyful Craftsmen.
2024-12-20 (first published: 2024-12-16)
409 reads
The post How to Build Data Management for Unstructured Data appeared first on Joyful Craftsmen.
2024-12-16 (first published: 2024-12-10)
454 reads
The post Lukáš Karlovský: I got the green light from management and built Fabric specialization from scratch appeared first on Joyful Craftsmen.
2024-12-11 (first published: 2024-12-05)
1,071 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 ...
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...
Comments posted to this topic are about the item 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