Keeping track of database changes in SQL Server with EntityFramework, let’s go over your options with sample implementations.

All code with some UnitTests can be found at the Github repository.

This month our QA TechEvent was “SQL Training”. Goal was to score most points by solving more and more complex SQL exercises against three datasets: countries of the world, teachers + departments (postgres) and the football worldcups (sql server).

Which country scored the most owngoals? Read on to find out!

typicode/husky : Git hooks made easy 🐶 woof!

I picked up a UserStory to make a small adjustment.

The story was simple enough as was the required change but… Looking at the code, how was it supposed to work? It looked like it just.. Shouldn’t…

Took some time but I found out, the behavior of the software was defined in the IOC registration, at startup, with Autofac.

Q: How do you install Node?
A: Well, you don’t!

You install NVM (Node Version Manager) because every project uses a different versions and they are not always that compatible!

How to load some initial data after spinning up a mongo with Docker.

If you want to follow the examples:

git clone https://github.com/itenium-be/Docker-Mongo
cd Docker-Mongo
docker compose up -d --build

# After fiddling, force re-creating the mongos:
docker compose down -v
docker compose up -d --build

It seems that pretty much everyone is using some sort of UI for their git interactions.

Which is obviously fine, until they are about to create a commit, in which case it’s using the “add all changes”-button and commit.

Good PR hygiene starts with keeping your commits small and focused: check your changes and exclude everything that is not part of the UserStory per se.

That’s why I advocate the use of git add --patch which gives you fine-grained control of exactly what you’re going to commit!

You’ve got yourself a brand new Synology. Now you need ssh, git and Docker so you can actually start using it for more than, you know, mere file storage.