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 […]

Identify a Slipstream Installation

Internal Staff Growth

How do you approach adding to your team? Steve asks if you look internally or externally as a default.

SQL Server 2025 RegEx and AI

One of the language changes in SQL Server 2025 that I’ve seen a lot of people mention is the addition of RegEx functions to T-SQL. I decided to take...

T-SQL Tuesday #192: SQL Server 2025 Backup Changes

I hosted this month, but I decided to put my own entry in as well. There are more things in this release than I expected, probably because of the...

Do You Really Need HA?

Steve asks the question about whether or not a particular environment really needs HA implemented.

The New Database CheckDB

Creating a Striped Backup Set with AI

I needed to test a striped backup, so I decided to ask the AI’s for help. This is part of a series of experiments with AI systems. The Problem...

Getting the Indexed Columns