Westbound and down, roll ’em up and truckin’
A little less than 2 years ago, my wife and I loaded up our cats and dog and moved from...
2017-12-20
445 reads
Blog Posts
A Basic Bot using Azure Bot Services
I wanted to break out my comfort levels and do something different from Azure SQL Database or straight SQL Server....
2017-12-19
588 reads
Do You Really Need Real-Time?
It wasn’t so long ago that the first day of the month was the most common trigger event for updating...
2017-12-19
401 reads
How To Create Multi-Object JSON Arrays in SQL Server
Recently I was discussing with Peter Saverman whether it would be possible to take some database tables that look like...
2017-12-19
8,331 reads
How To Create Multi-Object JSON Arrays in SQL Server
Recently I was discussing with Peter Saverman whether it would be possible to take some database tables that look like this:
And output them so that the Cars and Toys...
2017-12-19
115 reads
How to Update @@SERVERNAME to Actual Machine Name?
The @@SERVERNAME Global Variable
The system global variable @@SERVERNAMEcan be used to return the name of the machine the SQL Server...
2017-12-19 (first published: 2017-12-07)
4,710 reads
Key Sets, or Inverted Keys - defining a key as a set of tuples
TL;DR:
I have been doing a lot of thinking about data models for the last couple of weeks. I have, just...
2017-12-19
479 reads
Mapping SQL Trace to Extended Events
Since I started actively participating in SQL community, I found it is very common that people will approach to seek...
2017-12-19
2,201 reads
Moving to an Azure SQL Database via Command Line
I have moved many databases to Azure via different methods but I recently came across a new way. Well technically...
2017-12-19 (first published: 2017-12-07)
1,558 reads
Power BI Custom Visuals Class (Module 82 – Text Filter)
In this module you will learn how to use the Text Filter Custom Visual. This visual allows you to filter...
2017-12-19
628 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