Get That Profiler Feel in Extended Events
I know. You love Profiler. I hear you. You’re wrong, but that’s OK. Kidding… mostly.
Unfortunately though, I think a lot...
2017-11-29 (first published: 2017-11-20)
1,401 reads
Blog Posts
How to get started with Always Encrypted for Beginners Part 1
Encryption has always been intriguing to me but seemed like it could be a very complex process to set up....
2017-11-29
1,321 reads
How to Help with dbatools Comment-based Help
I wrote a post over on the dbatools website about how to get involved with improving comment-based help
Working on the CBH is a great way to get started with...
2017-11-29
6 reads
Introducing SQL Operations Studio
Note: This is content that I originally wrote for our upcoming book, SQL Server 2017 Administration Inside Out, that did...
2017-11-29
706 reads
Introduction to Extended Events
Since I started playing with Extended Events, it has been my favorite toy for performance troubleshooting. It was introduced in...
2017-11-29
891 reads
Pluralsight for Another Year
One of the ways that I try to keep current and learn is through Pluralsight. I’m lucky to get a...
2017-11-29
1,209 reads
Server Roles and Azure Active Directory in an Azure SQL Database
This video explains the built in server roles in an Azure SQL Server and demonstrates how to give a login...
2017-11-29
616 reads
SQL Puzzle – Word Scrambler
I’ve been writing crosswords for the last few months and to change things up I thought I would do a...
2017-11-29
565 reads
SSAS Tabular – Large Dimension Performance II
What are the limits?
What are the limits?
Of course, as a follow-up to my last article you might ask at least...
2017-11-29
152 reads
2 Ways to Loop through collections in Pester
In my last post I showed you how to write your first Pester test to validate something. Here’s a recap
Decide...
2017-11-28
406 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