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

Try, Try Again, Until It's Right

A cloud migration for DoorDash interested Steve, primarily because it didn't work, but they were able to back out and try again.

Getting a List of Names

Who Still Uses SP_ for Naming?

You shouldn't use sp_, and you should use DevOps.