Tag Archives: DevOps

Who Still Uses SP_ for Naming?

Posted on December 13, 2023 by way0utwest

An interesting post recently from Chad Callihan on the reasons why someone shouldn’t use sp_ to prefix their stored procedures. This is advice that I’ve seen for years, but I haven’t run into this lately with many customers. It seems … Continue reading →

Posted in Editorial | Tagged , | 6 Comments

Comparing Two Scripts with kdiff3

Posted on November 27, 2023 by way0utwest

I had a customer recently ask if SQL Compare could show them the differences in two scripts they’ve written. They weren’t using version control (tsk, tsk, shame), but saw SQL Compare and the “Scripts folder” option. This isn’t used for … Continue reading →

Posted in Blog | Tagged , , | 1 Comment

Does Management Care About the Database?

Posted on November 8, 2023 by way0utwest

Many of the services that businesses use are taken for granted. In an office, management expects electricity, water, and heat just work. If they don’t, then often a crisis is declared and funds are spent to rectify the situation. I’ve … Continue reading →

Posted in Editorial | Tagged , | 2 Comments

When Work Isn’t Done

Posted on November 3, 2023 by way0utwest

Software development can be a challenge for each of us with lots of demands and the need to ensure your code solves a problem correctly, efficiently, and completely. Juggling the workload by yourself is one thing, but add in a … Continue reading →

Posted in Editorial | Tagged , | 2 Comments