A blog post about writing blog posts
I recently wrote about how I teach, in response to a T-SQL Tuesday post from 2010. This is a continuation of that theme, suggested by my own editor. Thanks,...
2021-03-26 (first published: 2021-01-13)
188 reads
Born SQL with Randolph West
Security update for all supported versions of SQL Server (CVE-2021-1636)
Microsoft announced updates today for all supported versions of SQL Server, for a privilege escalation vulnerability that leverages Extended Events. For security reasons no further details have been provided, but...
2021-01-12
1,331 reads
T-SQL Tuesday Retrospective #008: Gettin’ Schooled
To view posts about previous T-SQL Tuesday entries, please use this tag. The late, great, Robert Davis invited us on Independence Day 2010 to write about Gettin’ Schooled: We...
2021-01-06
22 reads
2020 was certainly a year on the calendar
According to my blog post schedule, this is the final post of the year. It’s nothing more than a coincidence, but making it through the worst year in living...
2020-12-30
56 reads
Goodbye PASS
“It was the best of times, it was the worst of times, it was the age of wisdom, it was the age of foolishness, it was the epoch of...
2020-12-23
50 reads
Announcing the Calgary Data User Group
In 2018 I started a new user group called the Calgary Data User Group, and hosted one session called “The Ethics of Machine Learning.” It was well-attended and its...
2020-12-16
30 reads
T-SQL Tuesday Retrospective #007: Summertime in the SQL
This is the seventh post in my retrospective attempt to answer every T-SQL Tuesday invitation. In the beginning of June 2010, Jorge Segarra invited us to write about our...
2020-12-09
39 reads
T-SQL Tuesday Retrospective #006: What about blob?
I am revisiting old T-SQL Tuesday invitations from the very beginning of the project. On May 3, 2010, Michael Coles invited us to write about how we use LOB...
2020-12-02
28 reads
T-SQL Tuesday Retrospective #005: Reporting
A few weeks ago, I began answering every single T-SQL Tuesday from the beginning. This week it’s the fifth entry, and on April 5th, 2010, Aaron Nelson invited us...
2020-11-25
29 reads
Setting yourself up for online streaming success, PASS Virtual Summit style
Last week I presented on three separate occasions during what is considered the biggest Microsoft Data Platform conference of the year, the PASS Summit: Full-day pre-conference session Speaker Idol...
2020-11-18
77 reads
Blogs
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...
SQL Server gMSA: Why So Many DBAs Still Aren't Using It in 2026
By SQLPals
SQL Server gMSA: Why DBAs Still Aren't Using It in 2026 ...
Forums
Never is Not the Policy
Comments posted to this topic are about the item Never is Not the Policy
Automating SSAS Multidimensional Security Audits with PowerShell
Comments posted to this topic are about the item Automating SSAS Multidimensional Security Audits...
Rebuilding All Indexes
Comments posted to this topic are about the item Rebuilding All Indexes
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_CustomerEmail
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.CustomerContactAfter I do this, what will I see for the index status? See possible answers