Creating a Stored Procedure

A New Word: Attriage

attriage – n. the state of having lost all control over how you feel about someone – not even trying to quench the flames anymore, but lighting other fires...

I Can't Make You Learn

Steve believes that his career and life have become better as he learns more everything. It's the key to improvement.

A Quick Second Opinion

Communication is hard, and it's something most of us can learn to do better. Steve notes that using an LLM for tasks will also help you learn to communicate better.

Capturing My Own Metrics: #SQLNewBlogger

A customer was trying to compare two tables and capture a state as a performance metric. In this case, they were wanting to use Redgate Monitor and custom metrics,...

Checking the Error Log I

No Shortcuts for the SQLCMD Batch Terminator: #SQLNewBlogger

I was messing around with SQLCMD and I realized something I hadn’t known. I’ve never tried it, but the batch separator has to be separate, which I’ll show. Another...

T-SQL Tuesday #200: When I Look at a Query …

This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound big, but this is a monthly party (started by Adam Machanic). We have 12 blog...

Bad IT People

What happens when you have bad IT people working in your company? Steve Jones says that they always will be around, but we might not want to enable them to continue in this business when we find them.

TempDB Facts I