Tag Archives: SQLNewBlogger

Changing the Owner Removes Permissions: #SQLNewBlogger

Posted on July 15, 2026 by way0utwest

This is actually inspired by an article SQL Server Central, which taught me something new. I decided to verify what was in the article and do some research. The summary tl;dr if you change the schema owner, all permissions are … Continue reading →

Posted in Blog | Tagged , , | Leave a comment

Capturing My Own Metrics: #SQLNewBlogger

Posted on July 8, 2026 by way0utwest

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, but since the tables were in a Memory-Optimized table, they couldn’t … Continue reading →

Posted in Blog | Tagged , , | Leave a comment

No Shortcuts for the SQLCMD Batch Terminator: #SQLNewBlogger

Posted on June 17, 2026 by way0utwest

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 post for me that is simple and hopefully serves as an … Continue reading →

Posted in Blog | Tagged , , | Leave a comment

Funny Money: #SQLNewBlogger

Posted on June 10, 2026 by way0utwest

While wandering around the documentation looking for some Question of the Day topics, I learned something new about the money data type. This post discusses what I learned. Another post for me that is simple and hopefully serves as an … Continue reading →

Posted in Blog | Tagged , , | Leave a comment