Design Concepts for Better Power BI Reports Part 3: Gestalt Principles
The Gestalt principles of visual perception describe how humans tend to organize visual elements into groups or unified wholes to...
2017-12-18
715 reads
Blog Posts
My SQL Server Management Studio Setup
We’re all creatures of habit, and work more efficiently when we know exactly where to find the tools we need....
2017-12-18
341 reads
Power BI – Problem, Design, Solution (Folder Source Option for JSON files)
Hello Everyone! In this episode of the “Problem, Design, Solution” series we will be talking about the “Folder” option inside...
2017-12-18
619 reads
Query Store Wait Statistics with sys.query_store_wait_stats
The second best thing to questions that people ask is when I sit down to write a book. It’s so...
2017-12-18
738 reads
Restrict the usage of a SQL Server Authenticated Application Id
SQL Server login ids may not be the most secure thing in the world but they are likely to be...
2017-12-18 (first published: 2017-12-06)
1,724 reads
SQL Server 2016 – How to use Dynamic Data Masking (DDM)?
Dynamic Data Masking (DDM) is new feature of SQL Server 2016. DDM helps in preventing unauthorized access to sensitive data....
2017-12-18
1,016 reads
SQL Server DBCC CHECKDB – Going Parallel
DBCC CHECKDB has the ability to perform parallel checking of objects. However, it absolutely depends on the edition of SQL...
2017-12-18
321 reads
The Fine Art Of Translation
I remember being thoroughly baffled in grade school by word problems. How in the world was I supposed to translate...
2017-12-18
360 reads
T-SQL Tuesday #097: Learning Plans
If you are not progressing, you are regressing. In the same vein, if you are not learning, you are regressing.
Related Posts:
T-SQL Tuesday #102: Giving Back May 8, 2018
T-SQL...
2017-12-18
14 reads
T-SQL Tuesday #097: Learning Plans
Stylishly Late
I am fabulously late and therefor breaking the guiding rules that make up TSQLTuesday. Where’s the ruler to slap...
2017-12-18
476 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