Sharing the Love
Just a few blog posts that you ought to go and read.
First up, Tom LaRock maintains a listing of SQL...
2012-11-30
1,687 reads
Grant Fritchey
- Twitter: @https://twitter.com/gfritchey
- Website: https://scarydba.com
- LinkedIn: https://www.linkedin.com/in/grant-fritchey/
- Bluesky: https://bsky.app/profile/gfritchey.bsky.social
HDInsight: Trying again
And I thought this would be so easy.
Latest attempt. I just did an uninstall of HDInsight. Then I found all...
2012-11-29
1,932 reads
HDInsight: First Pass
I installed HDInsight with no errors. The install is so brain-dead, I couldn’t see how there could be errors. But,...
2012-11-28
895 reads
Treat Yourself to Knowledge
There’s a one day sale going on at Apress today, 11/26/12. All their eBooks are $15. This means you can...
2012-11-26
1,109 reads
Final 2012 Learning Opportunity
There’s still a little time left in the year. I know some businesses have allocated training budgets and if they...
2012-11-21
1,116 reads
Living with the Surface, Maybe
No major updates at the moment. I still haven’t played with remoting through PowerShell. I’m just living with it.
Had an...
2012-11-19
993 reads
HDInsight and Buggy Whips
I sat the through the big announcements at the 2011 PASS Summit about the partnership between Microsoft and Hadoop. I...
2012-11-16
1,212 reads
Remote Desktop and Surface
The Windows RT operating system is not the same as Windows. After all the talk about the upcoming OS and...
2012-11-14
2,371 reads
SQL Server Execution Plans, Second Edition by Grant Fritchey
Every Database Administrator, developer, report writer, and anyone else who writes T-SQL to access SQL Server data, must understand how to read and interpret execution plans. This book leads you right from the basics of capturing plans, through how to interrupt them in their various forms, graphical or XML, and then how to use the information you find there to diagnose the most common causes of poor query performance, and so optimize your SQL queries, and improve your indexing strategy.
2012-11-12
17,095 reads
Surface Problems With Azure
I’ve been posting about the Surface over the last couple of weeks and I’ve tried really hard to be positive...
2012-11-12
998 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