Categories
Opinion

Increase Productivity by Quantifying Simpler Tasks

The full title of this article should really be “Increase Productivity by Quantifying Simple Tasks; Protect Complex Task Productivity by Not Quantifying It”. This is the result of a study by Aruna Ranganathan, co-authored by Alan Benson, that studied workers in a garment factory and I’ve added my opinion because sometimes I’m a narcissist like […]

Categories
Opinion

Skipping the Chasm: How a Crisis Accelerates Progress

Full credit to Geoffrey Moore, whose seminal “Crossing the Chasm” keeps proving to be a useful book thirty years after it was written. Credit also to Hans Baumhardt who introduced me to the book and who critically shaped my thinking about work and life. What I hope do, now that the credits are over, is […]

Categories
Programming

Execute Raw SQL Scripts in Entity Framework Core

Most of the time, Entity Framework Core will just do the right thing. Every now and then, though, you’ll find that it’s doing something in a bit of a sticky way and you’ll want to take control. Usually it’s when you’re deleting a range on a table with cascading deletes. Here’s an example of the […]

Categories
Programming

Simple Conditional Updates to Entities in ASP.NET Core MVC

When you accept a view model in your .NET Core MVC application, you can request that only certain fields are bound, like this [Bind(“Title”)]. Neat. But when you want to apply the changes to your domain object, you often want to do a similar thing and only update certain fields (and only if they really […]

Categories
Opinion

The Fly on the Windshield

Every organisation has to deal with this problem. It has been described in many different ways, including the famous quaductionism of “Urgent vs Important” to the simplicity of phrases like “firefighting”. Yes, it’s all those tasks that people seem to want now, which are stopping you from doing the real work. My analogy for this […]

Categories
Browsers

Switch Off Rich Link Pasting in Edge

There is a cool new feature in Microsoft Edge that pastes links with rich formatting. If you copy a link from the page or from the address bar, it will paste in a rich format, so instead of seeing https://www.example.com/ you’ll see Example Website (example.com) and it will already be linked to your selected destination. […]

Categories
Analytics

What Data is Missing?

When you start collecting data at scale, you need to decide when to invest in keeping “all the datas” and when to keep only a sample. When it comes to sampling, you need to ensure that the parts you discard and the parts that you keep are a truly representative sample. That means you need […]

Categories
Opinion

Working With Public Coronavirus Data

The UK Government provides public datasets that can be used by the media or the public. One such dataset contains information collected for the Coronavirus pandemic and its impact on people living and working in the UK. The problem with this dataset, though, is that we weren’t able to record the data until after the […]

Categories
Automation Programming

Remove Blank Lines From a File with PowerShell

When importing a file full of data into a test system, I discovered that the CSV library I was using to do all the work was stopping when it reached a blank line. That makes sense, it thinks the data has ended. On inspection, I found quite a lot of blank lines, so there was […]

Categories
Psychology

The Dunning-Kruger Snap

This is a short post, which assumes you are already familiar with the Dunning-Kruger Effect. Simply put, the Dunning-Kruger Snap is a double realisation; part direct and part meta. The first part of the realisation is driven by tipping your knowledge past a precipice that triggers an epiphany of how little you know. It’s when […]