Advice I Like: Failure

If it fails where you thought it would fail that is not a failure. – from Excellent Advice for Living This is a great quote, especially for those of...

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

Growing Artificial Intelligence

This week Steve Jones discusses artificial intelligence and one of the building blocks that will be needed: data.

The DBA's Twelve Days of Christmas

On the first day of Christmas my new DBA sent to me A table with a primary key On the second day of Christmas my new DBA sent to me Two Foreign Keys, and A table with a primary key On the third day of Christmas my new DBA sent to me Three stored procs […]

The Tally Table

The tally table is a valuable tool for a SQL Server developer, but how many of you understand how to create and use one?