The Voice of the DBA

A New Word: the whipgraft delusion

• by Steve Jones

• The Voice of the DBA

whipgraft delusion – n. the phenomenon in which you catch your reflection in the mirror and get the sense that you’re peering into the eyes of a strange, as...

2023-12-22

Creating a Scripts Folder in SQL Compare

• by Steve Jones

• The Voice of the DBA

While I was at a conference recently, someone asked me about the Scripts Folder feature in SQL Compare and how to set that up. This post just looks at...

2023-12-20

Using DATETRUNC–#SQLNewBlogger

• by Steve Jones

• The Voice of the DBA

I saw someone using DATETRUNC recently in some code and realized I hadn’t really looked at this function before. It’s one that was added in SQL Server 2022, though...

2023-12-19 (first published: 2023-12-18)

Friday Flyway Tips–Deploying Migrations with a Target

• by Steve Jones

• The Voice of the DBA

Recently I was working with Flyway Desktop (FWD) and helping a customer work on deploying part of their work. They weren’t sure how easy this could be, but this...

2023-12-15

A New Word: Nementia

• by Steve Jones

• The Voice of the DBA

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

2023-12-15

Clearing Intellisense in SQL Prompt

• by Steve Jones

• The Voice of the DBA

I got this question from an account rep: if a customer is using SQL Prompt and a snippet, for example AT, that was also used as an alias, is...

2023-12-13

Executing One Line in VSCode–#SQLNewBlogger

• by Steve Jones

• The Voice of the DBA

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

2023-12-11

Friday Flyway Tips–Comparison Options

• by Steve Jones

• The Voice of the DBA

Recently a customer asked how they could get index changes to be captured in Flyway Desktop. In their case, they wanted a different fill factor, but I decided to...

2023-12-08

A New Word: Guiltwrights

• by Steve Jones

• The Voice of the DBA

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

2023-12-08

TryHackMe Advent of Cyber

• by Steve Jones

• The Voice of the DBA

I posted that I was thinking about the AdventOfCode this year, but wasn’t sure I’d spend the time. Someone then posted a link to the TryHackMe advent calendar. I...

2023-12-06