SQL Prompt Tips–Using $surroundtext$ in a Snippet

A user on the SQL Community Slack was asking about what the $surroundtext$ variable. This post looks at how this can be used in snippets. This is part of...

Using the Import Extension in Azure Data Studio

Learn how this extension in Azure Data Studio makes it easy to import flat files in a CSV or JSON format.

Data Security and AI

Today Steve discusses an aspect of AI that many people are concerned about: data security. Read more and think about how this might affect your organization.

Skipping Checks when Detaching

A New Word: Emodox

emodox – someone whose mood is perpetually out of sync with everyone else around them, prone to feelings of naptime panic, heart-to-heart snark, or dance club pensiveness. I had...

Black Friday 2023

Steve talks a bit about technology and shopping on this US holiday.

Creating a Self Referencing FK in a CREATE Statement–#SQLNewBlogger

I had written about a FK in a CREATE TABLE statement recently, but the second half of this was that after the original question, the person asked if this...

Memories of the PASS Data Community Summit 2023

I’ve been to a lot of conferences, and one that I’ve probably attended the most is the annual PASS Data Community Summit. It’s been listed under various names, but...

Which Thursday is the Holiday?

Further Defining the Window Clause