T-SQL Tuesday #183 Invite: Tracking Permissions

It’s time for T-SQL Tuesday again and this month I’m hosting. I realized that I didn’t host in 2024 and since I run the thing, I ought to be...

Declaring a Complex PK in a CREATE TABLE: #SQLNewBlogger

Recently I was talking with someone who had not named any of the primary keys (PKs) in their database. They used system generated names and when they ran comparisons,...

Monday Monitor Tips: Using the PowerShell API

Redgate Monitor has grown tremendously from its early days and I find many customers using this to monitor lots of servers, like thousands. In those cases, some of tasks...

Taking File Backups

Words vs Data

Are you clear in your reporting. Steve notes that sometimes we might leave too much up to interpretation by the end user.

Advice I Like: Why am I doing this?

You are never too young to wonder “Why am I still doing this?” You need to have an excellent answer – from Excellent Advice for Living I’d say that...

Another AI Faux Pax

I was experimenting with a local model (article) and as a part of this, I pulled down a web interface for my model in a container. I ran it...

Data Debt

The idea of data debt seems both silly and obvious to Steve. We all have too much data and it's out of control.

Precision and Scale I

Creating vs. Maintaining

When you create something, do you think about the future? Steve asks the question today.