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 dev.to 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....
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....
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....
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....
This is my first post, testing syntax highlighting here: write-output "Hello World" SELECT * FROM TABLE WHERE A = B print("Hello World!")