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

From Planning to Practice: Setting Up Your FinOps Framework

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

Presenting Twice in May 2026

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

SQL Server Journey Part 2: Modern Era (2017 – 2026) – AI/Cloud First

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