Friday Flyway Tips: Chaining Commands for State-based Deployments

One of the cool things I’ve seen with the new Flyway CLI is that I can combine multiple actions together in one call, which can make the process of...

A New Word: Querinous

querinous – adj. longing for a sense of certainty in a relationship; wishing there were some way to know ahead of time whether this is the person you’re going...

How to clear the SSMS cache?

How to clear the SSMS cache?

If you are reading this, it's probably because you too have this rare need to clear the SSMS cache for...

Master SQL Subqueries with This Free Course

Want to boost your SQL game? Check out this free course, SQL Subqueries: Real-World Exercises for All Levels. It covers subqueries – a must-have tool for any SQL pro....

Test Post 2

Ut enim ad minim veniam, quis nostrud exercitation ullamco labo-
ris nisi ut aliquip ex ea commodo consequat.

Test Post

Introduction to OpenAI and LLMs – Part 3

My previous blog posts on this topic were Introduction to OpenAI and LLMs, the “what” part (what is OpenAI and LLM), and the “how” part Introduction to OpenAI and LLMs –...

Using Flyway Prepare for State-Based Deployments

One of the neat enhancements made to Flyway was the addition of state-based workflows and tooling. A lot of people have loved SQL Compare or SQL Source Control for...

How I Migrated to Azure PostgreSQL Flex from Single Server

I did a couple of posts previously on dumping/restoring Azure PostgreSQL databases and also using the Azure migration tool. I had to ultimately do a combo of those because...

Have a Plan for Your Personal Downtime

Most of us know that spending a lot of time on social media and surfing the web isn't good for us, but we still do it. Why? Because it...