PASS First Timers Guide and Schedule
Hi there ho there everybody! I am now a Big SisterFearless Leader of a group of PASS Summit first timers!...
2011-09-17
777 reads
Blog Posts
Beyonders
It has been a looooong time since I wrote a little book review. It’s nice to take time out with...
2011-09-16
557 reads
Beyonders
It has been a looooong time since I wrote a little book review. It’s nice to take time out with a little fantasy to ease and please the brain....
2011-09-16
7 reads
Come and get your Data Education!
We all have been to various training courses throughout our professional career. Many follow a similar standard curriculum or course...
2011-09-16
923 reads
Conflict Resolution
More than once I’ve run into situations where I’m working with two people/groups that don’t get along. Especially as a...
2011-09-16
622 reads
Dreaming
It’s easy to get so busy with life you forget to dream, at least for me. Most of us have...
2011-09-16
709 reads
Import Data from AS400 to SQL Server
The process to import data from AS400 uses a SQL Server Linked server. The Linked Server points to an ODBC...
2011-09-16
17,160 reads
St. Louis SQL Server Users Group Feedback
You know I share what feedback I get from conferences. I don’t usually get feedback from users groups (well, I...
2011-09-16
864 reads
Ways to save money on Microsoft Software
If you are a developer and are on your own, or working for a company that does not have an...
2011-09-16
958 reads
Analytic Functions – FIRST_VALUE / LAST_VALUE
This post is part of the series discussing the new Analytic functions in SQL Server “Denali”, CTP3.
Analytic Functions in SQL...
2011-09-15
4,044 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
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
Automating SSAS Multidimensional Security Audits with PowerShell
Comments posted to this topic are about the item Automating SSAS Multidimensional Security Audits...
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