Tag Archives: DevOps

Try, Try Again, Until It’s Right

Posted on December 15, 2023 by way0utwest

One of the challenges with making changes in a database environment is that undoing those changes can be hard. What’s often preferred is rolling forward with a new change to correct the issue, but that’s often done with limited analysis … Continue reading →

Posted in Editorial | Tagged , , | 4 Comments

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