PowerShell Remoting for SQL DBAs: WinRM + SSH Guide (Updated 2026)
Originally published in 2023, this post never made it into Google's index, so I'm republishing it...
2026-04-03 (first published: 2026-03-26)
612 reads
We’re coming back to New York, which is exciting for me. I love NYC. The Redgate Summit 2026 – New York City comes back on May 5, 2026. You...
2026-04-03 (first published: 2026-03-25)
182 reads
Finding duplicates was an interview question for me years ago, and I’ve never forgotten it. Recently I got asked how to easily do this and delete them, so I...
2026-04-01 (first published: 2026-03-18)
243 reads
I previously wrote about how the underlying technology for Fabric mirroring changed with SQL Server 2025. The latest version of mirroring that uses the SQL Server Change Feed is...
2026-04-01 (first published: 2026-03-24)
393 reads
I am guilty as charged. The quote was in reference to how people argue about details in fitness or finances that are more detailed than is useful to them....
2026-03-30 (first published: 2026-03-13)
233 reads
As someone who works in DevOps, I’m always focused on creating systems that are efficient, scalable, and reliable. But when it comes to the cloud, one critical piece often...
2026-03-30 (first published: 2026-03-15)
214 reads
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person twice in May 2026. With summer vacations coming up, this is a perfect time of...
2026-03-30
40 reads
Following up on my Part 1 baseline, the journey from 2017 onward changed how we look at the “Engine.” We moved from Service Packs to a faster world of...
2026-03-28 (first published: 2026-03-27)
37 reads
Continuing from Day 5 where we covered notebooks, HuggingFace and fine tuning AI now Day 6 is inside of AI , how AI understand us, as computer do not...
2026-03-27 (first published: 2026-03-06)
207 reads
EightKB is back again for 2026! The biggest online SQL Server internals conference is back…it’s all happening on August the 20th! We’ve open our call for speakers, you can...
2026-03-27 (first published: 2026-03-18)
224 reads
By SQLPals
Why sys.fn_dblog Is Undocumented And Why It's Still There Why sys.fn_dblog...
When I put together the invitation for T-SQL Tuesday #202, I wasn't sure what...
By Steve Jones
My life has some crazy travel stretches for sure. Between speaking, office visits, customer...
Comments posted to this topic are about the item Implementing Type 4 Slowly Changing...
Comments posted to this topic are about the item The Disabled Index
Comments posted to this topic are about the item Server-Level Table sizes
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