The Low End
Today Steve Jones talks about those products we consider "low-end." Products like Access or VB. Are they a problem for us?
2010-12-14
180 reads
Editorials
How Do You Work When You are Not at Work?
Things have evolved since the days of essential pagers and landline connections. Or have they? Brad ponders how the nature of remote working is evolving, and invites you help others learn from your experiences.
2010-12-13
182 reads
iPads for Christmas
A contest from Red Gate and Steve Jones could get you a copy of SQL Monitor and an iPad for Christmas. Steve Jones talks about how you can enter, and perhaps win an iPad for yourself this holiday season.
2010-12-13
1,783 reads
Shrinking Databases
One piece of advice that is often given to new SQL Server administrators is not to shrink their databases. But they seem to do it often enough anyway. For this Friday's poll, Steve Jones asks if we should do away with shrink.
2010-12-10
992 reads
Certified Private Clouds
Microsoft is working to certify vendors to build private clouds, which Steve Jones thinks is a great idea.
2010-12-09
175 reads
Costing Cool Projects
Can you accurately determine the cost or benefit of a new, cool project up front? Steve Jones thinks not, but coming up with new projects can be a way to set yourself apart from others.
2010-12-08
117 reads
Elections
Steve Jones found a very fascinating way that might keep elections more secure, verifiable, and also more open.
2010-12-07
110 reads
How will SSDs change SQL Server storage arrays?
If SSDs are about to make obsolete one of the major driving forces behind the development of SANs (disk latency) then how is the storage array going to change in the near future?
2010-12-06
530 reads
Speed
We are always looking for more speed from our computer systems, but are they getting faster? Steve Jones has a few comments on why this might not be the case.
2010-12-06
168 reads
Coding With Music
Today Steve Jones has a poll that asks about your work environment, and specifically what type of noise works best for you.
2010-12-03
202 reads
Blogs
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
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...
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