Finding the Last Last Name in SQL: #SQLNewBlogger

I wrote a piece on the new SUBSTRING in SQL Server 2025 and got asked a question. How do we get the last last name, such as only getting...

Regression Testing: DAX User Defined Functions

User Defined Functions is a new feature in PowerBI currently in public preview. There is a lot of buzz in the air regarding this because it opens new scenarios...

Scooby Dooing Episode 10: The Case of the Copy-and-Paste Consultant

Every Scooby-Doo episode has one thing in common — there’s always a fake ghost. Sometimes, that “ghost” is really just a guy in a mask trying to scare everyone...

SQL Server Reliability: Clearing the Fuzzy Thinking

The terminology around reliability is a mess If you’ve ever said, “We’re covered, it’s replicated,” you’re in good company.   SQL Server is a massive, 35+ year-old product that...

FabCon Vienna 2025 Recap

Holy cow FabCon Vienna was incredible! This recap is extremely delayed because I’ve run into some serious decision fatigue about what to include (and my amazing hubby got me...

Run SQL Server 2025 and SQL Server Management Studio on macOS Tahoe

Short version You want to get this running as fast as possible. Do these four steps, and then check the compatibility section later in this post. Step 1: Install...

SQL Server 2025 GAs Today

If you aren’t watching the Ignite keynotes today, then you might have missed the announcement that SQL Server 2025 officially releases today. The main SQL Server page gives you...

The Roundup for T-SQL Tuesday #192

Last week I asked you to write about SQL Server 2025 and what things you might be looking forward to in the new version. First, as usual, is Rob...

Writing Better Dynamic SQL

Writing Better Dynamic SQL

This updated and "sort" of a style guide is for SQL developers and, to some extent, DBAs, essentially anyone daring (and sometimes...

Accelerated Database Recovery for tempdb in SQL Server 2025

Accelerated database recovery was introduced in SQL Server 2019 and provides fast recovery, instantaneous transaction rollback, and aggressive log truncation. A complete overview of how ADR achieves this is...