Monthly Archives: March 2025

A Couple Quick GENERATE_SERIES Tests

Posted on March 5, 2025 by way0utwest

I had someone reach out about generate_series() recently, saying they hadn’t realized this was a new feature in SQL Server 2022. They were wondering if it was better than using a tally table. I didn’t want to do an exhaustive … Continue reading →

Posted in Blog | Tagged , | 2 Comments

The Job Outlook for Database Professionals

Posted on March 5, 2025 by way0utwest

This is a strange time for many technology professionals and their employment. It seems many organizations have open positions and are struggling to fill those slots with qualified candidates (one look at this). At the same time, many other organizations … Continue reading →

Posted in Editorial | Tagged | Comments Off on The Job Outlook for Database Professionals

A Poor Data Model

Posted on March 3, 2025 by way0utwest

Recently there was some online complaints about social security numbers (SSNs) in the US being duplicated and re-used by individuals. This is really political gamesmanship, so ignore the political part. Just know that social security numbers appear to be one … Continue reading →

Posted in Editorial | Tagged | 2 Comments

What is Deferred Name Resolution?

Posted on March 3, 2025 by way0utwest

One interesting concept in SQL Server is Deferred Name Resolution. This is something many developers struggle with understanding how this works and where it works. In the Microsoft docs, there is a specific section in the CREATE TRIGGER docs that … Continue reading →

Posted in Blog | Tagged , | Comments Off on What is Deferred Name Resolution?