Author Archives: way0utwest

Unknown's avatar

About way0utwest

Editor, SQLServerCentral

Friday Flyway Tips: Searching a Migration

Posted on October 11, 2024 by way0utwest

This was actually a cool tip I saw internally from one of the product managers, when trying to find specific text in a migration. I’ve been working with Flyway Desktop for work more and more as we transition from older … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Friday Flyway Tips: Searching a Migration

Adding Row Numbers to a Query: #SQLNewBlogger

Posted on October 9, 2024 by way0utwest

I realized that I hadn’t done much blogging on Window functions in T-SQL, and I’ve done a few presentations, so I decided to round out my blog a bit. This post will start with the ROW_NUMBER() function as a gentle … Continue reading →

Posted in Blog | Tagged , , , | 5 Comments

Keep. It. Simple.

Posted on October 9, 2024 by way0utwest

I get a tech newsletter most days, which has news that I enjoy, but interspersed among the news and ads are projects, frameworks, or repos, most of which I’ve never heard of before. I used to read these, but it … Continue reading →

Posted in Editorial | Tagged | Comments Off on Keep. It. Simple.

T-SQL Tuesday #179: The Detective’s Toolkit

Posted on October 8, 2024 by way0utwest

It’s time for the monthly T-SQL Tuesday blog party. This month a longtime friend, Tim Mitchell is hosting and he’s got a neat invite. He’s asking us how to dig into a request and figure out th meaning in our … Continue reading →

Posted in Blog | Tagged , | Comments Off on T-SQL Tuesday #179: The Detective’s Toolkit