Categories
General
My bikepacking trip in Italy in March 2023
In the end of March this year I went bikepacking in Italy. I wanted to go on a holiday before starting my new job at SWM and I always wanted to spend a holiday just travelling by bike...
In General, Apr 01, 2023
Thoughts on the 'Last generation'
I want to share some of my thoughts on the group called “Last Generation”. It is a climate action group of people trying to get the german government to stay true to the climate goals...
In General, Feb 26, 2023
Ski touring in 2023: the good, the bad and the ugly
Last week, I spent five days on an organized ski tour with the german alpinism club (DAV). We were staying in a bed & breakfast in the Defereggen valley in eastern Tyrol. I want t...
In General, Feb 07, 2023
Thoughts on the covid situation
Almost exactly three years ago, the first covid infections happend in a chinese city most people in the western world had never heard of. The world has changed a lot based on these ev...
In General, Dec 14, 2022
Welcome
Welcome to my blog.This blog is still work in progress - if you see anything not working or looking weird, I would be happy if you let me know :) .I will write on here about whatever ...
In General, Aug 01, 2022
travel
Experiences travelling by train in Europe
The climate crisis is getting more obvious by the day and everybody should think of his or her part in it and how to reduce their carbon footprint. On the other hand, nobody wants to ...
In travel, Aug 05, 2022
Azure
Upgrading to container app environment workload profiles - or not?
What are container apps?
In Azure, Sep 08, 2023
Setting up a static website with Jekyll, Azure Blob and Github Actions
Introduction
In Azure, Aug 08, 2022
Technical
Snowpro Data Engineer part 3 - Storage & Data protections
Time travel: Time travel up to 90 days, then Fail-Safe 7 days for permanent tables Standard retention: 24 hours Changing retention on schema changes it for all objects in that sche...
In Technical, Snowflake, Oct 18, 2022
Snowpro Data Engineer part 2 - Performance optimization
Local and remote spilling When query does not fit into memory, spilling first goes to local disc of warehouse node, then to remote storage
In Technical, Snowflake, Oct 18, 2022
Snowpro Data Engineer part 1 - Data Movement
After recently having completed my SnowPro Core exam, I am now preparing to take the Snowpro Data Engineer Exam. There is less preparation material, mainly no video series but mainly ...
In Technical, Snowflake, Sep 27, 2022
Snowpro Core preparation part 7 - semi-structured data
I am currently preparing for the SnowPro Core certification which is the standard technical Snowflake certifications. More specialized certifications can be gained after this one is a...
In Technical, Snowflake, Sep 25, 2022
Snowpro Core preparation part 6 - performance tuning
I am currently preparing for the SnowPro Core certification which is the standard technical Snowflake certifications. More specialized certifications can be gained after this one is a...
In Technical, Snowflake, Sep 25, 2022
Snowpro Core preparation part 5 - Overview and architecture
I am currently preparing for the SnowPro Core certification which is the standard technical Snowflake certifications. More specialized certifications can be gained after this one is a...
In Technical, Snowflake, Sep 20, 2022
Snowpro Core preparation part 4 - Data movement
I am currently preparing for the SnowPro Core certification which is the standard technical Snowflake certifications. More specialized certifications can be gained after this one is a...
In Technical, Snowflake, Sep 19, 2022
Snowpro Core preparation part 3 - Account and security
I am currently preparing for the SnowPro Core certification which is the standard technical Snowflake certifications. More specialized certifications can be gained after this one is a...
In Technical, Snowflake, Sep 12, 2022
Snowpro Core preparation part 2 - storage and protection
I am currently preparing for the SnowPro Core certification which is the standard technical Snowflake certifications. More specialized certifications can be gained after this one is a...
In Technical, Snowflake, Sep 05, 2022
Snowpro Core preparation part 1 - virtual warehouses
I am currently preparing for the SnowPro Core certification which is the standard technical Snowflake certifications. More specialized certifications can be gained after this one is a...
In Technical, Snowflake, Aug 27, 2022
Nondeterministic behaviour of Snowflake based on warehouses
In the past week I stumbled upon a weird behaviour in Snowflake when a colleague asked me to help with a problem he did not understand. Basically, a data load process behaved differen...
In Technical, Snowflake, Aug 14, 2022
Snowflake
Snowpro Data Engineer part 3 - Storage & Data protections
Time travel: Time travel up to 90 days, then Fail-Safe 7 days for permanent tables Standard retention: 24 hours Changing retention on schema changes it for all objects in that sche...
In Technical, Snowflake, Oct 18, 2022
Snowpro Data Engineer part 2 - Performance optimization
Local and remote spilling When query does not fit into memory, spilling first goes to local disc of warehouse node, then to remote storage
In Technical, Snowflake, Oct 18, 2022
Snowpro Data Engineer part 1 - Data Movement
After recently having completed my SnowPro Core exam, I am now preparing to take the Snowpro Data Engineer Exam. There is less preparation material, mainly no video series but mainly ...
In Technical, Snowflake, Sep 27, 2022
Snowpro Core preparation part 7 - semi-structured data
I am currently preparing for the SnowPro Core certification which is the standard technical Snowflake certifications. More specialized certifications can be gained after this one is a...
In Technical, Snowflake, Sep 25, 2022
Snowpro Core preparation part 6 - performance tuning
I am currently preparing for the SnowPro Core certification which is the standard technical Snowflake certifications. More specialized certifications can be gained after this one is a...
In Technical, Snowflake, Sep 25, 2022
Snowpro Core preparation part 5 - Overview and architecture
I am currently preparing for the SnowPro Core certification which is the standard technical Snowflake certifications. More specialized certifications can be gained after this one is a...
In Technical, Snowflake, Sep 20, 2022
Snowpro Core preparation part 4 - Data movement
I am currently preparing for the SnowPro Core certification which is the standard technical Snowflake certifications. More specialized certifications can be gained after this one is a...
In Technical, Snowflake, Sep 19, 2022
Snowpro Core preparation part 3 - Account and security
I am currently preparing for the SnowPro Core certification which is the standard technical Snowflake certifications. More specialized certifications can be gained after this one is a...
In Technical, Snowflake, Sep 12, 2022
Snowpro Core preparation part 2 - storage and protection
I am currently preparing for the SnowPro Core certification which is the standard technical Snowflake certifications. More specialized certifications can be gained after this one is a...
In Technical, Snowflake, Sep 05, 2022
Snowpro Core preparation part 1 - virtual warehouses
I am currently preparing for the SnowPro Core certification which is the standard technical Snowflake certifications. More specialized certifications can be gained after this one is a...
In Technical, Snowflake, Aug 27, 2022
Nondeterministic behaviour of Snowflake based on warehouses
In the past week I stumbled upon a weird behaviour in Snowflake when a colleague asked me to help with a problem he did not understand. Basically, a data load process behaved differen...
In Technical, Snowflake, Aug 14, 2022
Movies
My Dune 3 ending theory
Spoiler warningSpoilers for both Dune movies and the Dune books
In Movies, Mar 10, 2024