Using DATETRUNC–#SQLNewBlogger

I saw someone using DATETRUNC recently in some code and realized I hadn’t really looked at this function before. It’s one that was added in SQL Server 2022, though...

Friday Flyway Tips–Deploying Migrations with a Target

Recently I was working with Flyway Desktop (FWD) and helping a customer work on deploying part of their work. They weren’t sure how easy this could be, but this...

Some Relief But Still Some Concern

Steve is relieved that he hasn't updated sqlmemorial.org this year, but worries he's missed remembering some of our colleagues.

The FK Columns

Merry Christmas 2023

Merry Christmas from Steve in 2023.

Santa Fun

A New Word: the whipgraft delusion

whipgraft delusion – n. the phenomenon in which you catch your reflection in the mirror and get the sense that you’re peering into the eyes of a strange, as...

Building CyberSecurity Skills with an Advent Challenge

Steve has been doing a cybersecurity advent challenge and has found it to be interesting, fun, and career building.

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...

Friday Flyway Tips–Above Target Migrations

Recently I was working with Flyway Desktop (FWD) and practicing deploying certain migrations and not others. I don’t recommend this, but a customer was doing this and I wanted...