Author Archives: way0utwest

Unknown's avatar

About way0utwest

Editor, SQLServerCentral

A New Word: Mottleheaded

Posted on September 20, 2024 by way0utwest

mottleheaded – adj. feeling uneasy when socializing with odd combinations of friend and family, or friends and colleagues, or colleagues and family – mixing a medley of ingredients that don’t typically go together, which risks either watering down your identity … Continue reading →

Posted in Blog | Tagged , | 1 Comment

Bad Stored Procedures

Posted on September 20, 2024 by way0utwest

I don’t see a lot of SQL at The Daily WTF, but this one was great. It’s a stored procedure that was likely just converted from embedded code, as noted by the poster. It’s a strange set of code, that … Continue reading →

Posted in Editorial | Tagged | Comments Off on Bad Stored Procedures

When Do We Worry About Scalability?

Posted on September 18, 2024 by way0utwest

“We need to get the code written for feature X. Can you finish this query today?” We’ve all heard some variation of that request. We have a request or demand, and we need to get it done. We need to … Continue reading →

Posted in Editorial | Tagged , | 1 Comment

Parsing EXE Output in PowerShell

Posted on September 18, 2024 by way0utwest

I saw a post internally that asked this question: Anyone have a handy powershell script testing if the installed flyway version matches a specific string? That seemed simple, but getting program output from PoSh wasn’t something I’ve tried. So I … Continue reading →

Posted in Blog | Tagged , , | 2 Comments