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

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