Author: Andre Sasongko

Bio Bio
Biz, Google Analytics

The Minimum Website Metrics You Should Track

I have been always fascinated by online marketing and the metrics used to measure the performance of a website. Unfortunately, I don’t have much experience in this yet and handled a project in online marketing data only once (a 6-months project in 2016) for a marketing agency whose clients were the likes of Audi, Volkswagen, and P&G. Because of this, now I just decided to create my own project by measuring this website’s metrics and reporting what I do to improve those.

Headlines, Interlude, Story

10 Years ago: Startup Weekend Hamburg 2011

This weekend 10 years ago I made a last-minute decision to participate in an event called Startup Weekend. Little did I know, that this event impacted my career choice big time. Since then, from a simple database administrator I went on to become a project manager, a freelancer and consultant, created a startup (and failed), application manager and head of IT. Not only that, I managed to get to meet great people, whom I still follow or connect with in social media up until now.

BI, Database

6 Steps to Database Migration in the Cloud

I have been asked a few times on how to migrate databases in the cloud. Sometimes I’m confused and have to pause before answering this question. Not because I don’t know how, but it’s more that I’m trying to figure out what is the motivation behind the question. In short: it should not be different than migrating databases on the on-premises servers. In other words, the only difference is that, the servers on the cloud are managed by a third-party provider.

Microsoft Azure
Azure, BI

What I Learned From Taking Azure Fundamentals Exam

Just recently, I took the exam AZ-900 to receive Azure Fundamentals certification. For most people working in IT, especially in the cloud computing, this means nothing special. In fact, this certification only has a meaning (just a little) when you just start out a career and apply for an entry-level in the IT industry (which gave me more pressure not to fail this one, so I might over-prepare it a bit). To my defense, I took this exam because I had received a free voucher from an event I attended a year ago. I’m the kind of person who constantly looks for ways in either saving money to the max or taking full advantages of anything (or both).

But I also have other reasons why I took this exam and took some lessons along the way, both from a personal and technical point of view.

Headlines, Interlude, Retrospective

When I realized I Was Not a Software Developer

A few years ago at the beginning of my 3-year freelancing journey, I just joined a project at a big, international marketing agency in Düsseldorf as a Business Intelligence Developer. This required me to stay in Düsseldorf Monday through Friday (at the time, WFH was not yet a thing) for 6 months. Back in Hamburg at almost the same time, someone I know asked me if I could help her optimizing and adding a few features on her website. No big deal, I thought.

BI, Database

SQL Tip: String Splitting Into Column With Delimiter

I’m not sure if the title above is understandable. What I mean by that is, you have a string and you want to split it and put each string element into specific columns. The split element is separated by a delimiter.

When you see the example below, I hope you understand what I’m trying to do (spoiler alert: it has something to do with CROSS APPLY).