Author Archives: way0utwest

Unknown's avatar

About way0utwest

Editor, SQLServerCentral

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

A New Word: Nementia

Posted on December 15, 2023 by way0utwest

nementia – n. the post-distraction effort to recall the reason you’re feeling particularly anxious or angry or excited, trying to retrace your sequence of thoughts like a kid gathering the string of a downed kite. I’m pretty level headed, but … Continue reading →

Posted in Blog | Tagged , | Comments Off on A New Word: Nementia

Clearing Intellisense in SQL Prompt

Posted on December 13, 2023 by way0utwest

I got this question from an account rep: if a customer is using SQL Prompt and a snippet, for example AT, that was also used as an alias, is there a way to avoid it triggering the snippet or do … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Clearing Intellisense in SQL Prompt

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