Press "Enter" to skip to content

Day: January 13, 2026

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