SQL Tip: pivoting results

Here’s something I always need to Google: how to pivot the results of a query in T-SQL. In the Peergroups application, we help people lend objects from their peers. So, simplified, we have a Request table that includes the following example data: Id Description UserId CreatedDateTime 1 A lawn mower 54 2018-01-21 2 A ladder […]

Read More

Time to look back and forward again!

Another year has past, and as always, I’ll do a quick overview of what happened. I’ll also look at what will happen, making silly predictions and statements about what I will do in the next year. Predictions and statements that usually don’t come to fruition, because, well things happen and interests change. 2017 Peergroups 2017 […]

Read More

Why your test should fail first

I always try to convince other developers that writing your test first is not just about doing TDD the “correct” way (if there even is such a thing). That sounds a little fundamentalist. Rather, it’s about making sure your test is failing and failing for the right reason. Actually, this is only one reason, as […]

Read More

Giving devs access to the registry

This article was written for a friend, who works in a company where developers are local admin on their PC’s, but don’t have access to the registry. I’m not sure if this is a Windows thing, or some custom solution of that company, but needless to say, developers weren’t happy with the situation. This article […]

Read More

Reusing code in tests

When writing tests, you can often end up with tests that have (almost) the same setup. Certain input variables may change, but the structure of the setup code remains the same. When the setup is small, you can copy from one test to another. But when there is more ceremony involved, you will start to […]

Read More

RedStar.Amounts ported to .NET Standard 2.0

Almost a year ago now, I introduced RedStar.Amounts, a .NET library to handle units and amounts in an easy way. The code It allows you to explicitly state what unit a certain amount is measured in. So instead of doing this:

You can do this:

What’s more, you can perform calculations without having […]

Read More

Your project is not special

Pardon the cheeky title, but I’ll explain myself. Of course, your project is special, in that it is your work, your passion, your hobby, or possibly your nail-in-the-coffin although hopefully not. The point I would like to make is that we should avoid thinking our project is an exceptional project, and our specific problems haven’t […]

Read More