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)

Data Analysis with Microsoft Excel: Tables

Auf ambassadorbase.at ist mein Artikel auf Deutsch verfügbar. In my job and my studies I recently finished I work with lots of different data sources and you will also meet all of them throughout your career as a data scientist. Data can be given to you as an SQL dump, XML files and many other … Continue reading Data Analysis with Microsoft Excel: Tables

Microsoft Product Launch @ K.47 in Wien

Vor wenigen Wochen haben Patrick und ich eine Einladung zum Microsoft Product Launch in Wien bekommen (danke Ambassador Base!). Deshalb haben wir uns am Dienstag, den 17.11. früh morgens Richtung Wien aufgemacht. Dort haben wir uns mit einer Freundin und Patrick’s Cousine getroffen und das Katzencafé Neko besucht (das hat sich allerdings einen eigenen Post … Continue reading Microsoft Product Launch @ K.47 in Wien

How the Surface 3 replaced my MacBook Pro as my main device

As some of you might already know some weeks ago I won the Surface 3 and already wrote that I loved it. Since then the Surface 3 has more and more replaced my MacBook Pro and in this post I’ll tell you the reasons why. Status Quo To give you a short insight in my … Continue reading How the Surface 3 replaced my MacBook Pro as my main device

[Review] One week with the Surface 3 … I love it!

Almost exactly one month ago on the 26th of August I became aware of an online tombola to win a Surface 3 by the weblog AmbassadorBase. Here you can find the original post of the tombola (German). In a second post they showed the creative posts of the contestants so far. The idea was to … Continue reading [Review] One week with the Surface 3 … I love it!