A Last Minute Trip to the EU
My life has some crazy travel stretches for sure. Between speaking, office visits, customer trips, I can be on the road a lot. As it is, I’ve flown across...
2026-09-14
24 reads
The Voice of the DBA
The Book of Redgate: Hours
I have said and written this many times: Redgate Software is the type of company I’d want to build if I founded another company. It’s a great place, and...
2026-09-11
47 reads
PostgreSQL Support in the Data API Builder
Next week I’m at VS Live in San Diego (register and join me) and one of my talks is on the Data API Builder. I want to show how...
2026-09-09
22 reads
T-SQL Tuesday #202: 100 Hours
It’s time for T-SQL Tuesday again and this is a great prompt to start writing. I might have written about this before, but it’s a story that sticks with...
2026-09-16 (first published: 2026-09-08)
70 reads
Advice I Like: Lots of Ideas
“A multitude of bad ideas is necessary for one good idea” – from Excellent Advice for Living Whenever we read about the success of someone or something, we often...
2026-09-04
50 reads
Updating the Data API Builder
I was updating my session for the Data API Builder (DAB) recently, mostly to work with the MCP server capabilities. As I was trying to get this working, I...
2026-09-11 (first published: 2026-09-02)
229 reads
A Daily Report from Claude
Redgate had some Claude training recently, which I went through as my knowledge has been gained in bits and pieces and is fragmented. I wasn’t sure I’d get a...
2026-08-31
70 reads
A New Word: Gnossienne
gnossienne– n. the awareness that someone you’ve known for years still has a private and mysterious inner life. One of the things I’ve learned throughout my life is that...
2026-08-28
44 reads
Using the SIGN() Function: #SQLNewBlogger
I was trolling the docs and noticed the SIGN() function. I have never written this in production code, but it is an interesting function. This post looks at where...
2026-09-07 (first published: 2026-08-26)
446 reads
Monday Monitor Tips: Configuring Access to the MCP Server
I have been experimenting with MCP servers in a few ways, including the Redgate Monitor MCP Server. It took me a few tries, and some help from engineers to...
2026-08-31 (first published: 2026-08-24)
343 reads
Blogs
Why sys.fn_dblog Is Undocumented And Why It's Still There
By SQLPals
Why sys.fn_dblog Is Undocumented And Why It's Still There Why sys.fn_dblog...
T-SQL Tuesday #202 SQL Server Outage You’ll Never Forget: A Roundup
When I put together the invitation for T-SQL Tuesday #202, I wasn't sure what...
A Last Minute Trip to the EU
By Steve Jones
My life has some crazy travel stretches for sure. Between speaking, office visits, customer...
Forums
Implementing Type 4 Slowly Changing Dimensions in SQL Server
Comments posted to this topic are about the item Implementing Type 4 Slowly Changing...
The Disabled Index
Comments posted to this topic are about the item The Disabled Index
Server-Level Table sizes
Comments posted to this topic are about the item Server-Level Table sizes
Question of the Day
The Disabled Index
I run this code on SQL Server 2022.
CREATE TABLE Drink
(
drinkid INT NOT NULL
CONSTRAINT DrinkPK PRIMARY KEY CLUSTERED,
drinkname VARCHAR(20),
rating NUMERIC(2, 1)
)
GO
INSERT INTO Drink
(
drinkid,
drinkname,
rating
)
VALUES
(1, 'Margarita', 4.5),
(2, 'Mojito', 4.3),
(3, 'Old Fashioned', 4.7),
(4, 'Martini', 4.4),
(5, 'Cosmopolitan', 4.2)
GO
ALTER INDEX drinkpk ON dbo.drink DISABLE
GO
SELECT * FROM dbo.Drink
GO
What is the result? See possible answers