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

Specifying the Collation

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

Don't Create Workslop

AI can help us do more, but do we need to do more? Or more importantly, are we doing a good job of producing more useful stuff?

What is the original database name?

A Place where AI Technology Shines

Steve has a few examples of where AI technology works very well.

Being Mindful of Design Time

Do you take the time to model and design your database? Steve thinks this is important, even while trying to make changes quicker to adapt to changing requirements.

Getting the Object Code

T-SQL in SQL Server 2025: Concatenating Strings

Like many of you, I have often put strings together (concatenation) with a simple arithmetical operator: +.  We have a few other ways to put strings together, but in SQL Server 2025, we have a new operator that allows us to put strings together. This is the double pipe (||) operator. This article looks at […]