A Thrill of Hope

I realize that this isn’t the last Database Weekly editorial of the year – that honor is reserved for Louis Davidson next week. However, as we approach the end of the year and various holiday celebrations, one of my favorite Christmas carols has been of particular encouragement to me recently.

2023 hasn’t gone exactly how I had hoped or envisioned in a few ways. And, unfortunately, at least at the start of 2024, I may not see the change I’m hoping for.

Still, as I look back over this past year there are many blessings that I didn’t anticipate. Connections with old friends within my tech circles and local community. New friends from different continents at conferences and work. Opportunities to learn about myself, my family, my interests, and the data technology that I never get tired of.

As I realize how much I have to be thankful for, O Holy Night, one of my favorite Christmas carols, comes to mind and provides encouragement for the days that lie ahead. Even when I’m weary, there is a thrill of hope that awaits me each day. When I’m uncertain about what’s next, a new morning breaks and opportunity shines through.

There is much to have hope about… and many reasons to bring hope to others. Don’t lose sight of what matters most and the opportunities that you’re given to impact the community around you for good. While our technology world may be ever changing, it’s the people that stay true and matter most.

Happy Holidays… and here’s to spreading some hope in the new year!

Ryan Booz

Join the debate, and respond to the editorial on the forums

If you can convert a SQL file to HTML, then you can inspect your Flyway migration files in a browser. This is especially useful if your SQL is color-coded with the same conventions as it was in your IDE. It is even better still if your browser can allow you to scan through many files, moving from file to file with a single click. This article will demonstrate how to do this with a few PowerShell scripts.

This article demonstrates a PowerShell automation technique that will allow you to run any Flyway build or migration task on any number of projects and databases, hosted on a range of RDBMSs. It handles all connection and authentication details securely, makes it easier to automate database testing and can send detailed alerts when Flyway encounters an error.

A database assertion test aims to check that data within a relational database conforms to specific business rules. This article demonstrates how to run these assertion tests automatically in Flyway, checking that the queries under test always produce the expected results.

Generative AI created mass interesting in AI but c...

Kendra Little demands change: According to Microsoft’s documentation, “Database compatibility level … allow[s] the SQL Server Database Engine to be upgraded while keeping the same functional…

Over the years, SQL Server Statistics have been discussed in countless blog posts, articles, and presentations, and I believe that they will remain a core topic for a while when speaking about performance. Why is that? Well, if we were to consider the equivalent of Maslow’s hierarchy of needs for database performances, statistics would be a foundational needs of a database system (namely the “physiological” needs) as they are one of the most fundamental pieces of information needed to build execution plans.

In the past week, we have dedicated our efforts to a service request where our customer asked questions:   Whether DataIO signifies the utilization of memory by the Buffer Pool. The rationale...

Kendra Little has a note for us: In Azure SQL Managed Instance, you get to use Resource Governor, even in the General Purpose tier. This is…

Today, we are announcing that your MySQL 5.7 and PostgreSQL 11 database instances running on Amazon Aurora and Amazon Relational Database Service (Amazon RDS) will be automatically enrolled into...

Content warning: burnout, health issues I have not been looking forward to writing this blog post. I started the series, inspired by Brent Ozar’s series, because being able to...

While I was at a conference recently, someone aske...

This article describes the practical uses of NATUR...

Ed Oldham takes us through a common problem: If you are currently using Microsoft Fabric you will have some sort of capacity associated with your…

A couple of months ago where I work, a major produ...

Ryan Lambert clues us in: One of the key elements to using PostGIS is having spatial data to work with! Lucky for us, one big…

Lemme start this off by saying this is probably ir...

The Stack Exchange network logs a lot of web traffic – even compressed, we average well over a terabyte per month. And that is just a summarized cross-section of our overall raw log data, which we load into a database for downstream security and analytical purposes. Every month has its own table, allowing for partitioning-like sliding windows and selective indexes without the additional restrictions and management overhead. (Taryn Pratt talks about these tables in great detail in her post, Migrating a 40TB SQL Server Database.)

None Other Locking hints are funny. Normally I see them in awful products like Dynamics, on select queries, and hilarious levels of blocking and deadlocking issues ensue. Another place...

Imagine this: you have several directories full of SQL script files, and you need to know where a certain table is used. You’d rather like the context too, so...

Everything started in 1993, 30 years ago! This fir...

Learn how to add a new data file to a SQL Server o...

Andrew Pruski goes messing around: When I first started working with SQL on Linux one of the first things I did was to remove the…

Erik Darling plays the roles of both Goofus and Gallant here: All sorts of bad things happen when you do this. You can’t index for…

Hugo Kornelis continues a series on explaining the execution plans for window functions: This is part twenty-six of the plansplaining series. And already the fourth episode about…

In this article I focus on duplicates and how to control them. In order to understand duplicates correctly, you need to understand the concepts of distinctness and equality, which I’ll cover as well.

Data validation is key when ingesting from externa...

I show how to use metadata to avoid costly reads w...

Nein Nein Nein Just like you can’t fix a broken bone with good vibes, you can’t fix parameter sniffing with idiocy. More on that later, though. Like many other...

A little while back, my coworker was having trouble with a query and asked me about a strange thing they were seeing in the execution plan: The estimated rows...