T-SQL Tuesday #197 Invitation – An impactful session or two from a conference

I am delighted to host this month’s T-SQL Tuesday invitation. If you are new to this blog party, I encourage you to check out the rules. If you are...

Monday Monitor Tips: Intelligent Alert Thresholds

At the recent Redgate Summit in Chicago, I demo’d (lightly) the ML based Alert thresholds in Redgate Monitor and decided to write a little about this. This is part...

The Burrito Bot: AI-Powered Search in SQL Server 2025

A while back I posted about a couple of side projects that I’ve been working on when I get the chance. One of those was the Burrito Bot…a bot...

SQL Server Security – TDE Encryption

Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this feature encrypts a physical layer of Database files Data/log files protection at Disk / storage...

A Las Vegas Break

Only a little break for me. I’m actually heading to Las Vegas today for  the Red Rock Rave volleyball tournament with a team of 13 year olds. We’ve been...

PowerShell Remoting for SQL DBAs: WinRM + SSH Guide (Updated 2026)

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...

The 2026 Redgate Summit in New York City

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...

Finding and Updating Duplicate IDs: #SQLNewBlogger

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...

Monitoring Fabric Mirroring for SQL 2025

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...

“We love to debate minutiae”

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....