Opening the SQL Prompt Command Palette

A few years ago SQL Prompt added a command palette to let you search the commands available. This is similar to the same concept in Visual Studio Code, ADS,...

Quickly Creating a tsqlt Test for a Query

One of the things that I feel is important to building better software is testing your code. It should be easy and simple to test code and determine if...

SQL Saturday Denver 2023–VCS Primer for the Database slides

My slides are here: VCS Primer Denver 2023 This was an overview of what version control is, and the basics of Git. Not too many questions, but if you...

Yet another kind of orphan users in SQL Server

Yet another kind of orphan users in SQL Server

Or YAOU for short. (This silly acronym, I just made it up so don’t try...

A Study in SQL Server Ad hoc Query Plans

A Study in SQL Server Ad hoc Query Plans

We, (or maybe it’s just my dismissive attitude towards it), often think of ad hoc...

Get Configuration Change History From the SQL Server Error Logs

Get Configuration Change History From the SQL Server Error Logs

There are several options if and when you need to see if any configuration change was...

A New Word:Wildred

wildred –adj. feeling the haunting solitude of extremely remote places – a clearing in the forest, a windswept field of snow, a rest area in the middle of nowhere...

Deneb – powerful visual for advanced reporting

Introduction
For one of our customers we needed to create customized reports that could not be easily implemented by using standard Power BI components. We explored different ways how to...

Friday Flyway Tips: Copying the Migration Number

It’s a small thing, but copying the migration number can be a pain. However, we’ve made this easier in Flyway 6.5.4. I’ve been working with Flyway Desktop for work...

Friday Flyway Tips–Flyway Parameters

Flyway is a command line tool with lots of options and parameters. Working with those is a pain, but we’ve made this easier in Flyway Desktop 6.5+. In this...