Managing Environment Variables with PowerShell
Working with environment variables in Windows is as easy as:
Win + Pause > "Advanced system settings" > "Environment Variables..."
After which you get a tiny, unresizable, form where you can view and manage them. Something better eventually arrived with Windows 10 but still, PowerShell :)
Use Autohotkey to open the window with Left Alt + Pause:
LAlt & Pause::Run % "rundll32 sysdm.cpl,EditEnvironmentVariables"
Less for your git pager
A git diff or git log starts the less program. Perhaps not the fanciest tool but more powerful than you might expect.
This post details the arguments that can be passed to less and also how to navigate once less is running. Things not relevant for git are omitted.
Your current configuration:
git config --get core.pager
If this returns nothing, there is room for improvement there!
TL&DR:
Configure something sensible:
# Short version
git config --global core.pager "less -eFiJM~ -j3 --tabs=3"
# Not so short version
git config --global core.pager "less --LONG-PROMPT --tabs=3 --quit-at-eof --quit-if-one-screen --tilde --jump-target=3 --ignore-case --status-column"
Yaml tutorial
Everyone happy when the downfall Xml was a fact with the widespread use of Json. Less tags, more data. What’s there not to like. It’s also just so much easier for a human to read.
If it wasn’t so straightforward to parse JSON in the omnipresent JavaScript, Yaml might have had a good chance to take over the world being the most readable data serialization language.
NSubstitute Tutorial
The creators of NSubstitute craved a mocking framework with comparable capabilities to the alternatives but with a shorter, more succinct syntax. They have not failed to do so and I loved the NSubstitute syntax right away.
Excel formulas cheat sheet
Version 4.5.3.3 is the last version of EPPlus you can use without a license for commercial use.
See some alternatives if that is a dealbreaker for you!
We now have a blog series on an alternative Excel package ClosedXML
Which is basically on equal footing with EPPlus.
Package Manager Console Entity Framework 6 Migrations profile
This tutorial is about adding the following functionality to the Entity Framework Migrations CLI:
- Execute commands against the project containing the migrations by providing the most likely -Project parameter value
- Allow updating the database using a numeric TargetMigration (-2 = migrate to the third last migration)
JavaScript Testing: Jasmine syntax
The basic example contains the general test suite structure and the two most used matchers toBe() (===) and toEqual() (deep compare), followed by all the other matchers that come out of the box.
To finish some helpers for your workflow: how to only have certain tests run and how to exclude tests.
Create Excels with C# and EPPlus: Miscellaneous
Version 4.5.3.3 is the last version of EPPlus you can use without a license for commercial use.
See some alternatives if that is a dealbreaker for you!
We now have a blog series on an alternative Excel package ClosedXML
Which is basically on equal footing with EPPlus.
Create Excels with C# and EPPlus: Import
Version 4.5.3.3 is the last version of EPPlus you can use without a license for commercial use.
See some alternatives if that is a dealbreaker for you!
We now have a blog series on an alternative Excel package ClosedXML
Which is basically on equal footing with EPPlus.
NSubstitute vs Moq
Comparing NSubstitute syntax with Moq, probably the most used mocking framework out there at the moment.
