Press "Enter" to skip to content

Author: Kevin Feasel

Bars vs Lines in Visuals

Published 2025-10-29 by Kevin Feasel

Cole Nussbaumer Knaflic contrasts a pair of visual options:

Bringing clarity to your data storytelling doesn’t usually mean you need to learn and use more chart types. It does mean choosing visuals that are appropriate for your data and what you’re trying to communicate. Two of the most useful tools in our graphing toolkit—bar charts and line graphs—often do the heavy lifting. Knowing when to use which (and when to switch) can make all the difference.

This lesson came up recently as I revisited our new book, storytelling with data: before & after. I’ll share two scenarios where the choice between bars and lines matters. They are both from Chapter 2, which is titled “embrace basic graphs.”

Read on for an initial chart that is using the wrong type of visual, and then how we can tell different stories using the same data based on our choice of visual.

Leave a Comment

Local Variables and Cardinality Estimates in SQL Server

Published 2025-10-29 by Kevin Feasel

Erik Darling lays out an explanation of what SQL Server does to estimate the cardinality of queries using local variables. Erik covers some of the conceptual questions around how a compiler could work, and then explains what SQL Server does.

Erik talks about dependency on specific behavior and how people get upset when things change, and he’s absolutely right. My favorite example of this is the “quirky update” technique people used back in the day prior to SQL Server 2012 to calculate running totals. That technique was something that relied on unsupported, accidental but repeatable behavior around creating clustered indexes on temp tables. Even though the SQL Server team explicitly stated that this behavior could change at any time, it was clear that they didn’t go out of their way to break that functionality.

Leave a Comment

Executing Data Factory Pipelines from Logic Apps

Published 2025-10-29 by Kevin Feasel

Andy Brownsword automates a workflow:

When building Azure Logic Apps we can use the Azure Data Factory connector to start a pipeline. However that action simply triggers a pipeline and doesn’t wait for it to finish. If your downstream logic depends on the output – for example to collect a file – this can cause issues.

In this post I’ll demonstrate how to control the Logic App flow to wait for the pipeline to complete before proceeding.

Read on to see how, as well as some additional ideas of how to improve the pattern.

Leave a Comment

Merging the Measures of Two Power BI Semantic Models

Published 2025-10-28 by Kevin Feasel

Jon Vöge declares a hostile takeover:

Now, how you best maintain multiple copies/variants of the same Semantic Model is a whole other discussion but as a one-off, I was asked to merge the Measures of the two models.

Initially, the question actually stumped me as my usual tool of choice for external manipulation of semantic models Tabular Editor does not have a great native way to solve this. 

Jon lists a variety of options and then gets the job done with ALM Toolkit.

Leave a Comment

Packaging and Publishing Python Packages via Poetry

Published 2025-10-28 by Kevin Feasel

Osheen MacOscar forces me into alliteration:

So far, in the previous blog we covered creating our package with Poetry, managing our development environment and adding a function. In the current blog post we’ll be covering the next steps with package development including documentation, testing and how to publish to PyPI.

Read on for several tips on making Python code package-ready and then how to distribute it via PyPi.

Leave a Comment

PostgreSQL Synchronous Replication is Asynchronous

Published 2025-10-28 by Kevin Feasel

Jeremy Schneider doesn’t wait for a response:

Postgres database-level “synchronous replication” does not actually mean the replication is synchronous. It’s a bit of a lie really. The replication is actually – always – asynchronous. What it actually means is “when the client issues a COMMIT then pause until we know the transaction is replicated.” In fact the primary writer database doesn’t need to wait for the replicas to catch up UNTIL the client issues a COMMIT …and even then it’s only a single individual connection which waits. This has many interesting properties.

Click through for the pros and cons of this technical decision.

Leave a Comment