Why Customers Are Looking At Azure
As a Principal Consultant with Pragmatic Works, I have many conversations with customers about moving to Azure. As a Consulting...
2018-09-19
319 reads
Apply for the 2019 Idera ACE Program
Sharing this before I forget, Idera is taking applications for their 2019 ACE Program. If you’re wanting to do more...
2018-09-19
765 reads
Public Service Announcement: check your backup notifications
The Azure cloud platform lost a data centre for a number of hours recently due to inclement weather. This affected...
2018-09-19
235 reads
What is Projectsv13 in SQL Change Automation?
I got this question recently from someone that was evaluating the SQL Change Automation client in Visual Studio. After setting...
2018-09-19
1,723 reads
All about PASS Summit 2018
Here are the things you must/should probably know about PASS Summit 2018, as told by me. First Timers Read this...
2018-09-19
250 reads
Three skills to look for in a technology partner
SQL Treeo’s founder and CEO, Danny Riebeek, reflects on his 20+ years in the IT industry. Q: What prompted you...
2018-09-19
286 reads
Overview of SQL Joins in SQL Server
The ability to combine results from related rows from multiple tables is an important part of relational database system design. In SQL...
2018-09-19
637 reads
Midlands PASS Reboot!
If you’re in or near the Columbia, SC area, we are rebooting the Midlands PASS Chapter. Here is our first...
2018-09-19
629 reads
Databases and DevOps, It’s Not Just Me
Anyone who subscribes to my blog or my YouTube channel as well as anyone following me on social media knows...
2018-09-19
325 reads
You can’t DELETE TOP (x) with an ORDER BY
Did you know you can’t do this?
DELETE TOP (10)
FROM SalesOrderDetail
ORDER BY SalesOrderID DESC;Msg 156, Level 15, State 1, Line 8
Incorrect...
2018-09-27 (first published: 2018-09-19)
3,213 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