T-SQL in SQL Server 2025: The PRODUCT Function

Earlier this year at SQL Saturday Austin 2025, Conor Cunningham gave a keynote that discussed the engineering efforts in the Austin office around SQL Server. One of the things he mentioned was PRODUCT(), which was written there and added to SQL Server 2025 to help with the GDP calculation for the US government. Yep, that's […]

What's Your Theme Music?

Steve asks what theme music you would pick for your next presentation.

Which Object Definitions Are Available?

Done is Better than Good

Getting something done is important, but so is the quality level. Steve has a few thoughts today.

The Ending Substring

The PASS Data Community Summit 2025 Recap

It’s Monday. I’ve been home since Fri night, but with a busy weekend, I’m still recovering from the PASS Data Community Summit. There’s a nice wrap from the crew,...

Finding and Killing Blockers with Redgate AI Tech

Redgate has a research arm, called the Foundry, that has been experimenting with AIs and DBA tasks. This post shows how GenAI tech can be helpful to DBAs in...

Getting The Database Name

Is Data Modeling Common?

Today Steve tasks data modeling and wonders how many people still build and maintain models.

A New Word: Dead Reckoning

dead reckoning– v. intr. finding yourself bothered by somebody’s death more than you would have expected, even if they were only an abstract presence in your life, like a...