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

The Upgraded Procedure part 2

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

Deleting the Standby file

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

How Would You Design This: Scheduling Classes

One of the challenges for many database developers is coming up with a good design that not only meets the specifications but also performs well in queries. Relational databases often seek some level of normalization, which reduces the update load for a system but might require more effort work from developers to write queries. Many […]

If You Build It, Will They Use Linux?

Microsoft built SQL Server on Linux. Are people coming to use it? Are you?

Flexing for the Cloud

The cloud requires new skills, but it's also using a lot of what you know. Ask questions, learn, and then help evaluate if it makes sense for your situation.

Opening Multiple Symmetric Keys