Press "Enter" to skip to content

Month: January 2026

A Deep Dive into PostgreSQL Arrays

Published 2026-01-14 by Kevin Feasel

Radim Marek talks arrays:

The official documentation provides a good introduction. But beneath this straightforward interface lies a set of more complex properties than most of us realise. Arrays in PostgreSQL are not just “lists” in a field. They have their own memory management strategy, their own index logic, and a lot of edge-case scenarios.

As it goes with boringSQL deep-dives, this article will explore the corners of array functionality that might break your production.

Click through for some not-boring explanation around arrays in PostgreSQL.

Leave a Comment

2026 Data Professional Salary Survey Results

Published 2026-01-14 by Kevin Feasel

Brent Ozar has another year of data:

The results are in! You can download the raw data in Excel for all 10 years and do some slicing and dicing to find out whether you’re underpaid, overpaid, or what it looks like for folks who are out there looking for work.

This year, I added a couple of new items to the survey asking about folks who are unemployed and currently looking for work. In hindsight, I wish I would have done this long ago so that we could have a baseline to know whether things have gotten better or worse. Ah, well – the best time to plant a tree was 20 years ago, and the second-best time is now. Let’s dig into the data and see what we find.

Click through for Brent’s initial findings and have fun analyzing the data.

Leave a Comment

Changing Power BI Dashboard Themes by Toggle

Published 2026-01-13 by Kevin Feasel

Valerie Junk demonstrates a process:

In this tutorial, I will recreate a project I built last year: a mini Power BI dashboard with a toggle button to change its appearance. When you toggle the button, the background color changes, the logo and snow switch images are updated, and the visuals are restyled accordingly (including the color of the trees). 

This project combines different tutorials I created in the past, which cover dynamic color changes and the lollipop visual.
At the bottom of this page, you will find a step-by-step video, and you can download the file from the download page.

Click through for instructions, the video, and a zip file to work from.

Leave a Comment

Sequence Integer Overflows and BIGINT in PostgreSQL

Published 2026-01-13 by Kevin Feasel

Laurenz Albe performs a migration:

In a previous article, I recommended using bigint for sequence-generated primary keys (but I make an exception for lookup tables!). If you didn’t heed that warning, you might experience integer overflow. That causes downtime and pain. So I thought it would be a good idea to show you how to monitor for the problem and how to keep the worst from happening.

Read on for the downtime-rich solution (thanks to table blocking), as well as a solution that requires less downtime.

Leave a Comment

Working with Git in SSMS 22

Published 2026-01-13 by Kevin Feasel

Daniel Calbimonte answers a question:

In SSMS 22, there is Git integration to manage SQL code versions and repositories. How do you use this functionality?  Can you walk through a step-by-step example?

I’ll admit that I’m not too wild about using Git in SSMS. I don’t have anything against the idea, but I’ve always used separate tools like Visual Studio and VS Code for project and source control management.

Leave a Comment

Microsoft Fabric Eventstream Pricing

Published 2026-01-13 by Kevin Feasel

Anasheh Boisvert puts on the green eyeshade:

In this blog post, we’ll walk through Eventstream’s pricing model to give you a clear understanding of how it works and help you navigate it with confidence.

By the end of this post, you will be able to:

  • Comprehend how Eventstream pricing is structured across its components.
  • Understand the relationship between Eventstream components and billing meters.
  • Review detailed pricing examples to support precise and confident cost estimation.

Read on for a breakdown of the components and several examples.

Leave a Comment

IOPS Slider in Azure SQL Managed Instance Next-Gen

Published 2026-01-13 by Kevin Feasel

John Morehouse cranks that slider to the right:

If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to boost memory or I/O, you had to scale the whole instance, paying for extra CPU you might not need—and hoping the upgrade fixed the bottleneck.

It worked but wasn’t elegant and could be slow or awkward. Scaling sometimes took hours when time was of the essence.

The Next-Gen Azure SQL Managed Instance marks a major shift from the old model. It was way overdue.

The downside is that there’s still a per-CPU hard cap on IOPS and it’s low. Granted, it’s only about two orders of magnitude lower than what I’d expect from a decent on-premises solution, but that’s still enough to limit severely my ability to recommend SQL Managed Instance to anybody.

Leave a Comment

Using REGEXP_LIKE in SQL Server 2025

Published 2026-01-12 by Kevin Feasel

Jared Westover dives in:

Microsoft added several new features in SQL Server 2025, including an exciting suite of regular expression (regex) functions. After years of anticipation, there’s no longer a need to rely on CLR to use regex capabilities. As an experienced SQL developer, I enjoy finding specific rows, and the function that stands out to me is REGEXP_LIKE. I was drawn to it by its name, mainly because I frequently use the LIKE predicate. Right now, we are deciding whether to use it.

Read on for the results of Jared’s testing.

Leave a Comment