Single User Mode – Back to Basics
Starting SQL Server in single-user mode should be a tool every data professional holds in the bag. This is an essential tool that can be used in multiple scenarios...
2018-05-31
309 reads
Single User Mode – Back to Basics
In a recent article, I took you on a trip through how to hack (ethically) a SQL Server to regain...
2018-05-31
582 reads
Power BI Data Security – Power BI Report Server
Power BI Report Server was released as a way to host reports on premises. It was one of the highest...
2018-05-31
537 reads
Getting SQL Agent going for SQL Server on Linux–#SQLNewBlogger
It’s actually a simple procedure, but I thought I’d write a short note to help me remember. The procedure is...
2018-05-31
484 reads
Updated query to view data in the error log
This is one of my favorite scripts. It pulls all of the data from the error log and dumps it...
2018-05-31
382 reads
SQL Saturday 769 Melbourne & 771 Sydney
For those not aware there’s some excellent local SQL events coming up here in Melbourne and Sydney… SQL Saturday 769 (Sat 30 Jun 2018) Melbourne. SQL Saturday 771 (Sat 07 Jul 2017)...
2018-05-31
23 reads
SQL Saturday 769 Melbourne & 771 Sydney
For those not aware there’s some excellent local SQL events coming up here in Melbourne and Sydney…
SQL Saturday769 (Sat 30 Jun 2018)...
2018-05-31
382 reads
Birthday Musings and Deploy Using PoshSSDTBuildDeploy
Hello!
It is my birthday: another year older, another year not necessarily wiser. I’m planning on spending the evening watching the BBC and eating pizza. There are worse ways to...
2018-05-31
21 reads
Lost that SQL Server Access?
Losing access to a SQL instance is never a desirable situation - for the DBA. When the people that are supposed to have access, lose that access, all hope...
2018-05-30
23 reads
Lost that SQL Server Access?
As a data professional can you recall the last time you needed to support a SQL Server instance for which...
2018-05-30
880 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