Sometimes You screw up your database design and you have redundancies i.e. your database is not normalized. If You want to correct that: Subqueries for the rescue! In our example we have two tables which contain almost the same information: CREATE TABLE installed_device (`id` int, `device` text, `info` text); INSERT INTO installed_device (`id`, `device`, `info`)…
You can comment your queries with — This is a comment in SQL SELECT * FROM my_table — WHERE id = 1
I got confused by all the buzzwords: data science, machine learning, deep learning, neural nets, artificial intelligence, big data, and so on and so on. As an engineer I like to put some structure to the chaos. Inspired by Roadmap: How to Learn Machine Learning in 6 Months and Tetiana Ivanova – How to become…
As this year is coming slowly to an end, I like to use this Sunday to experiment with a little personal Retrospective. We already did two good retros at work so I decided to one for myself.
Last event for this year: ASQF’s #agilebrunch in Nuemberg. Jürgen Mohr invited me to this event because I was curious about Management 3.0 Workshops and Jürgen told me that he was going to hold a short session about M3.0 at this particular event.
Imagine that you come home from a party and you are stopped by the police. They ask you to take a drug test and you accept. The test result is positive. You are guilty. But wait a minute! Is it really that simple?
After the Atlassian Roadshow, the next event I attended was just around the corner. Location The Software Engineering Camp 2017 aka #SWEC17 was hosted again in the rooms of method park in Erlangen-Tennenlohe which is the town where I work at e.solutions GmbH, so no big deal traveling. SWEC16 being my first bar camp ever,…
What can You expect from a day when you are awake at 4am after just 5 hours of sleep still dealing with headache and a cold? Actually a lot 🙂 Thanks to my wife I attended -against all odds- the Atlassian Roadshow “Agile Evolution in Companies” in Nuremberg, on November 14th 2017
Keep it simple, stupid! When we first released our tool to the end user, we proudly named it v1.0.0. This is called semantic versioning – major.minor.patch Makes sense for libraries where a minor change e.g. 1.0.0 to 1.1.0 means interface compatibility, just some new functions. A major change e.g. 1.0.0 to 2.0.0 means “Attention, I…
From time to time you have annoying things to do which you cannot avoid e.g. split names into surname and last name. Here comes the flash fill feature: Given you have the full names in column A Go to cell B1 and enter the last name Go to B2 Go to tab “Data” Click Flash…