Monthly Archives: November 2023

Running a Command Line SQL Compare Comparison

Posted on November 8, 2023 by way0utwest

Recently a customer was looking to automate some of their SQL Compare checks, but they wanted to do this in a dynamic way, since they needed to do this at scale. Their idea was to not have a SQL Compare … Continue reading →

Posted in Blog | Tagged , , | 4 Comments

Does Management Care About the Database?

Posted on November 8, 2023 by way0utwest

Many of the services that businesses use are taken for granted. In an office, management expects electricity, water, and heat just work. If they don’t, then often a crisis is declared and funds are spent to rectify the situation. I’ve … Continue reading →

Posted in Editorial | Tagged , | 2 Comments

T-SQL Tuesday #168 – Mature Window Functions

Posted on November 7, 2023 by way0utwest

It’s time for T-SQL Tuesday and I’m hosting this month. I usually do one a year, just because I can and being responsible for a month keeps me engaged in the party. This month my invitation is on Window functions … Continue reading →

Posted in Blog | Tagged , , | 16 Comments

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

Posted on November 6, 2023 by way0utwest

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 would also work for a self-referencing FK. It does, and I … Continue reading →

Posted in Blog | Tagged , , | 1 Comment