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! Continue reading “SQL-Basics – Subqueries: Update column with values from another column”
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 a Data Scientist in 6 months a hacker’s approach to career planning I build my own learning road map for this year: Continue reading “My personal road map for learning data science in 2018”
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. Continue reading “Personal Retrospective 2017”
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?
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. Continue reading “Atlassian Roadshow “Agile Evolution in Companies””
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 have to adapt interface changes” (renamed functions, added function parameter, different dynamic behavior )
But for a customer tool like a portal what does semver mean? Continue reading “Versioning Software – Semantic Versioning vs. Product Versioning”
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 Fill (or Ctrl + E)
The rest of the B column should be filled with the last names
Repeat for first name in column C