Rotating Keys
This Friday's poll deals with security. Steve Jones asks how often you might rotate those encryption keys to ensure that your systems are secure.
2010-01-29
160 reads
Editorials
Arrogance Has No Place in Security
Arrogance has no place in assessing threats and attempting to build security to mitigate them.
2010-01-28
127 reads
The Dying Administrator
Is the SAN administrator dying out as a job? Steve Jones comments on an article that suggests it might be.
2010-01-27
197 reads
The IT Explosion
So many people are joining the IT industry all the time and Steve Jones talks about the attitudes that they bring with them.
2010-01-26
220 reads
Keeping up with Technology
Phil Factor believes that we have become so immersed in the idea that administrators or accountants can run technical enterprises, unaided, that we are in danger of forgetting the vital creative contribution of the technologist.
2010-01-25
125 reads
We'll go no more a' tibbling
Phil Factor points out the limitations and irritations of Hungarian Notation.
2010-01-25
881 reads
Forgetful Databases
Chris Massey gives a speedy book review, discusses the erosion of data privacy in the so-called Digital Age, and considers the implications for DBAs of a possible solution.
2010-01-22
274 reads
How Do You Handle the Stress of Being a DBA?
How do you deal with all the pressures, stress, and problems in being a DBA? Today we have a guest editorial from Brad McGehee that asks the question.
2010-01-21
667 reads
Help Others, Help Yourself
There is something to be said for helping others. However it isn't necessarily a selfless act. Guest writer Tim Mitchell talks a little about how helping others has helped him.
2010-01-20
226 reads
Perfect is the Enemy of Good
Today we have a guest editorial from Andy Warren. We all would love to have perfect code, but is always worth the time? Andy Warren notes that cutting a corner or two might make sense at times.
2010-01-19
158 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