Monthly Archives: December 2023

Clearing Intellisense in SQL Prompt

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?

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

Breaking Biometrics

In the movies, when someone needs to bypass some sort of fingerprint biometric system, they use tape to lift a fingerprint, or in the more gory films, cut off a body part. In any case, there have been a lot … Continue reading

Posted in Editorial | Tagged | Comments Off on Breaking Biometrics

Executing One Line in VSCode–#SQLNewBlogger

I wrote about arrays in PowerShell last week, but I realized one of the things I did while experimenting was look up how to run code a line at a time. I’m sure you can Google for that, but I … Continue reading

Posted in Blog | Tagged , , | Comments Off on Executing One Line in VSCode–#SQLNewBlogger