First steps with DaVinci Resolve for video editing

A couple of months ago I took some videos with a GoPro during we moved all of our stuff into our new apartment. I thought it would look especially cool to have a time lapse video of me filling my bookshelf. Before I could share the video, I wanted to edit it a little bit. … Continue reading First steps with DaVinci Resolve for video editing

Find closest date before or after event (MATLAB)

It’s the second time since I have been using MATLAB that I need to find the closest date to a given target date in an array. Of course I didn’t remember how I did it the last time and I couldn’t find a solution that suited my needs on the internet. So I decided to … Continue reading Find closest date before or after event (MATLAB)

May 1st in Austria

Besides the International Workers’ day (also called May Day) Austrians (and also people from some other countries) use May 1st to erect a maypole and celebrate! All my Austrian and German blog readers know the tradition, so I thought I’d share the impressions of this years maypole event in English on my blog. The tradition … Continue reading May 1st in Austria

Copy environment variables between SSIS catalogues on different servers

Problem Usually when developing SSIS packages, you want the project to run on different servers, e.g. development, test and production server. If you have many environment variables creating all of them is tedious and unnecessary work. I’ll show you how you can copy environment variables between SSIS catalogues that are located on different servers. Solution … Continue reading Copy environment variables between SSIS catalogues on different servers

Accessing MSSQL Server with R (RSQLServer with dplyr)

Recently I have been starting to use dplyr for handling my data in R. It makes everything a lot smoother! My previous workflow – running an SQL query, storing the results as CSV, loading it in RStudio – is now history. With dplyr you can directly query data from many different databases in a very … Continue reading Accessing MSSQL Server with R (RSQLServer with dplyr)

Fix the display of maps marker lists in twentyfifteen

In this blog post I’ll show you how to fix a problem I had with displaying the list of markers below a map. The table that lists the markers was formatted completely wrong. For me this problem came up with Maps Marker (Pro) but it can also happen if you embed Google Maps. I’m using … Continue reading Fix the display of maps marker lists in twentyfifteen

Accessing your Fitbit data

Since I am a data junkie and bought my Fitbit Charge HR mainly because I wanted to collect and analyse data about myself, I was looking for ways to download the data to your computer. For most people the great stats overview in the app and in the online dashboard will be sufficient but some … Continue reading Accessing your Fitbit data

Learning Club 05-07: Starting to love rmarkdown (Naive Bayes, Clustering, Linear Regression)

I remember when I had an R course at university I was really not a fan of rmarkdown and knitr. But since I participate in a Learning Club, where people are encouraged to document and present their code, data and results, I started to love it. Prior to that I’ve always documented my assignments at the university either … Continue reading Learning Club 05-07: Starting to love rmarkdown (Naive Bayes, Clustering, Linear Regression)

Netflix Socks Part 1: Set up the Arduino

Some weeks ago Netflix posted a cool project on their website, Netflix socks that will pause your show when you fall asleep. Since I fall asleep a lot during watching TV, I thought this was a cool idea for a small project. In this post I’ll show you how to set up the Arduino for … Continue reading Netflix Socks Part 1: Set up the Arduino

Karten in Blog Posts einfügen

Da ich Karten und GPS Daten sehr interessant finde, bastle ich gerne Karten und füge sie z.B. hier auf meinen Blog ein. Prinzipiell fallen mir 3 Möglichkeiten ein, Karten in Blog Posts einzubinden. Zu jeder dieser 3 Arten stelle ich euch ein konkretes Beispiel vor und erkläre euch die Vor- und Nachteile. Externe Karten einbinden: … Continue reading Karten in Blog Posts einfügen