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.

Attaching Databases

Breaking Biometrics

Fingerprint readers on laptops are shown not to be as secure as they could be, and primarily because the manufacturers haven't done a good job implementing the secure protocols.

A New Word: Guiltwrights

giltwrights  – n. the imaginary committee of elders that keeps a running log of your mistakes, steadily building their case that you’re secretly a fraud, a coward, a doofus,...

A SQL Prompt AI Experiment with Window Clauses

SQL Prompt has an EAP with some AI capabilities. I was asked to do some testing, and while I’ve done relatively little, I did find some time to play...