Manager of One
Are you a manager of one? Steve Jones say show this might be a good thing to be. You might improve your chances of landing the next job by showing your employer that you can be more productive.
2009-10-12
113 reads
Editorials
Investing In Your Career
Do you invest in your own career? Should you? Steve Jones asks the question in today's Friday poll.
2009-10-09
203 reads
Are you looking to Hadoop?
Hadoop is an interesting new software project in the Linux world that deals with large data sets. Steve Jones wonders if anyone in the SQL Server world has started working with it.
2009-10-08
1,353 reads
Is Your Server Vendor Providing the Quality, Innovation, and Support You Need?
We should get help from vendors, as well as support, but what about innovation? Today's guest editorial from Brad McGeHee asks if the third party tool vendors for SQL Server are doing enough to provide value for the cost of their tools.
2009-10-06
60 reads
DBAs and the Fear of Maintenance Plans
The Maintenance Plan wizard offers a quick and simple route to make sure essential database maintenance tasks are performed and scheduled. However, it needs to be used with a lot of care, and is no substitute for the judgment, experience and common sense of a flesh and blood DBA.
2009-10-05
388 reads
The Incidental DBA
There are lots of technical people that are forced to be DBAs by necessity. However there is another class of DBAs, the Incidental DBAs. Andy Warren brings a guest editorial that reminds us about this group of people that work with SQL Server.
2009-10-02
196 reads
In Praise of Barebones Applications
The English voice of IT reason, Phil Factor, brings us a guest editorial. Today he waxes about the overbearing processes used to build internal corporate applications.
2009-10-01
194 reads
Generation X
Steve Jones is a part of Generation X, who surprisingly seems to be more Web 2.0 oriented than Generation Y.
2009-09-30
145 reads
Security Focus
Are IT administrators focusing on the wrong attacks when securing their systems? Should we as DBAs and developers care? Steve Jones argues that we want to be aware of these issues.
2009-09-29
107 reads
Importing Data and New Hardware (Database Weekly)
Steve Jones looks at some of the interesting news this week in the SQL Server world.
2009-09-28
82 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