Recharged on the 4th of July
After a week of vacation, Steve Jones feels recharged and ready to head back to work. Today we celebrate the holiday with a blooper reel.
2009-07-06
59 reads
Editorials
The Busman's Holiday
It's a holiday weekend, but for some DBA's it's hard to escape the unwanted clutches of IT...
2009-07-06
87 reads
The Independence Day Ruckus
Steve is away this Fourth of July, so we asked Brian Donahue, head of the Red Gate product support team, and an American "exiled" in the UK, to reflect on what Independence Day means to him.
2009-07-03
81 reads
Stress
Developers and DBAs both tend to lead stressful lives. Occasionally, things don't go to plan, and this stress can then build to pretty intolerable levels. Without adaptive methods of dealing with stress, things can go very wrong...
2009-07-02
284 reads
What is the Best Way to Test SQL?
Over the past five or so years, encouraging progress has been made with regard to testing .NET application code...I wish I could say that the same progress had been made with testing SQL.
2009-07-01
557 reads
Documenting Database Code: Structured Headers
When you're doing any database development work, it won't be long before you need to seriously consider the documentation of your routines. Should we, as a community, propose a common standard for T-SQL headers, and the information that should go into them?
2009-06-30
498 reads
Disaster Recovery - An Afterthought?
Disaster Recovery is always ranked by DBAs and managers as one of the most important things to have set up. Yet many people working with databases don't spend time on this. Steve Jones has a few comments from the news this week.
2009-06-29
436 reads
What's Your Ideal DBA Job?
Brad engages in a little Summer daydreaming, and wonders what the Ideal DBA job would look like...
2009-06-29
370 reads
Making Demands
Imagine you are invited to speak somewhere and you have a bit of power. Have some fun with this Friday's poll and let us know what you'd demand.
2009-06-26
121 reads
Making Demands
Imagine you are invited to speak somewhere and you have a bit of power. Have some fun with this Friday's poll and let us know what you'd demand.
2009-06-26
444 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
ALAMAT BCA KCU TEGAL Tlp:08218154374
Hub Via Wa 628218154374 Alamat Jl. A. R. Hakim No.2, Mangkukusuman, Kec. Tegal Tim.,...
ALAMAT BCA KCU SALATIGA Tlp:08217555651
Hub Via Wa 628217555651 Alamat Jl. Jend. Sudirman Jl. Diponegoro No.15, Salatiga, Kec. Sidorejo,...
ALAMAT BCA KCU PEKALONGAN Tlp:0817825533
Hub Via Wa:62817825533 Alamat Jl. Diponegoro No.27, Dukuh, Kec. Pekalongan Utara, Kota Pekalongan, Jawa...
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