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

The PowerShell Array Removal

Parameter Defaults

AI In the Nov 2023 Enterprise

An OReilly Radar report on AI has some interesting data to Steve. Read what he thinks about the state of this technology in 2023.

Migrations are Worth the Effort

Steve prefers database migrations as a way of making changes to a database, though he knows they are hard. He gives a few reasons to choose them.

Statistics Sampling Options

A New Word: Nementia

nementia – n. the post-distraction effort to recall the reason you’re feeling particularly anxious or angry or excited, trying to retrace your sequence of thoughts like a kid gathering...

Comparing Two Scripts with kdiff3

I had a customer recently ask if SQL Compare could show them the differences in two scripts they’ve written. They weren’t using version control (tsk, tsk, shame), but saw...

Finding Database File Growths