Yellow DataWeekender van, the cool logo of DataWeekender

I am speaking at DataWeekender

Yes, it looks a bit funny: on this blog, the last post was about my supporting as a Moderator of DataWeekender in last October. Ever since, I’ve set up this blog and got much more active on my Twitter account. And this does not mean that I’m leaving my account, but just that I now have additionally a blog that I have more control about. This May 15, I will be debuting for speaking at conferences....

Apr 28 2021 00:00 Zurich, Switzerland · 1 min · Kay
Picture of some of the code introduced here with syntax highlighting

Deploy Azure Sql Server Vm With PoSh

This post was first published on my past employers blog here. I thank OneDigit AG for the permission to publish my article also here. Especially in this time of COVID-19 caused lockdowns, working from home is widespread. Therefore, working together on a developing VM in the cloud may be an attractive solution. In the past few months, I developed a solution to use VMs for such business cases. We also had in our minds that this VM could be a showcase for customers that prefer having their solution on their premises without Azure....

Jan 18 2021 15:24 Zurich, Switzerland · 13 min · Kay

I'm moderating at DataWeekender conference

The Dataweekender conference is coming up again this Saturday Oct 17! After the very successful first Dataweekender conference on May 2nd 2020 with more than 1000 sign-ups and with an excellent speaker lineup, the 6 founders of Dataweekender decided to setup another one this year. Just like the first time, I will be moderating again this October 17. The conference will be held from 9:00 - 19:00 Central European Summer Time....

Oct 20 2020 00:00 Zurich, Switzerland · 1 min · Kay
colored church-like windows in a fibonnaci spiral

Introduction Into Window Functions on SQL Server

Why window functions may come in handy Let us dive directly into a real world example. You’ve got a table with salaries of different job functions and you are asked to find out what the n-tiles (quantiles, mean etc.) are of each function within a company. So this means you’ve got many people that hold a position which you want to compare with others. You want to compare salaries of marketing professionals to their peers, but you don’t want to compare said salaries to marketing directors because they have their own salary bands....

Mar 07 2020 20:17 Zurich, Switzerland · 4 min · Kay

Hello World

This is my first post, testing syntax highlighting here: write-output "Hello World" SELECT * FROM TABLE WHERE A = B print("Hello World!")

Mar 06 2020 19:25 Zurich, Switzerland · 1 min · Kay