Roland Oldengarm - Independent IT Contractor

Living in the coolest little capital Wellington, New Zealand!

How to install SharePoint patches on a multi-server farm in just three steps

Installing SharePoint patches have been an issue since forever. Over the years, the strategy from Microsoft has changed a couple of times. CU became PU’s, language packs were removed. Worst thing was when Microsoft decided to roll out patches via WSUS / Windows Update…

Then SharePoint 2016 came and Zero Downtime Patching was introduced. Reason is that Microsoft now has to patch O365 as well, and there should not be any downtime.

My initial thought was this would be amazing, but I’m slightly disappointed. Yes, you can install patches without any downtime, but it is still a very cumbersome and manual process. This video explains this very well in details. I really appreciate all the documentation and blog posts from Microsoft, but I don’t understand why in 2017 we still have to execute so many manual steps to install SharePoint patches.

Then I found SPPatchtify which solves this! Continue reading

How SPMeta2 became even more awesome

If you are an experienced SharePoint developer, you’ve probably created a lot of code to deploy and upgrade SharePoint solutions. Back in SharePoint 2007, there was zero guidance how to do this, so everyone created their own scripts to deploy WSP’s, create sites, etc.  This has caused a lot of headaches and frustration, probably one of the reasons why SharePoint is the most dreaded development platform according to Stackoverflow.

Farm solutions are still out there, but since I’ve learnt about SPMeta2 I’ve moved away from farm solutions where possible. And, SPMeta2 is now even more awesome, with incremental support!

Continue reading

How we have made our Angular 2 website multi-language

I’m part of the startup YouJustGo and we are currently targeting the Chinese market. Our site is built in Angular 2 and we wanted to have our site in two languages, English and Chinese. I’ve done most of the technical work in this space, to get the site working in both languages, and I would like to share my experience.

Continue reading

Microsoft Teams: My experience so far

When I heard about Microsoft Teams, I was very excited from the start. I’m using Slack a lot for GitHub projects and for some internal projects, as there is no alternative in Microsoft. Teams is positioned as a Slack competitor, and when it was available as public beta, I immediately contacted our Office 365 admin to enable it. I’ve been using it for a couple of weeks now, and I want to share my experience with you!

Continue reading

Angular 2: Automated i18n workflow using gulp

Update: New post can be found here.

i18n (internationalization) support for Angular 2 is now built-in the framework. Previously we used ng2-translate, but I found it time-consuming to add all translations manually to the .json files. Since a week or so the documentation is also available at While useful, it did not provide information, it involves a lot of manual steps. I’m going to provide a set of Gulp tasks that will automate everything!

Continue reading

Part 3: How to embed a Power BI report in SharePoint with the SharePoint Framework

In this final post of the series “How to embed Power BI in SharePoint”, I’m going to show you how to embed a PowerBI report in SharePoint, using Power BI Embedded and the SharePoint Framework! All new technologies, so exciting times 🙂

Continue reading

A new era in SharePoint development: The SharePoint Framework (spfx)

Announced at the “Future of SharePoint” event, was the SharePoint Framework. And it is in public beta since this week! I was one of the lucky persons who had access to the internal repository, so I already had a play with it before. Unfortunately I could not blog about it, as it was under NDA. I will talk about how it will fit into the existing SharePoint development infrastructure, and start with some history 🙂

Continue reading

How to deploy your SharePoint artifacts like content types, site columns, lists, and much more

This blog post is aiming at developers that are looking for a solution to deploy SharePoint artifacts from code. Sure, you can do all of this by hand via the SharePoint user interface, but that is not repeatable.

In SharePoint 2007 the recommended solution was to use the feature framework. However, that had (and still has) one big disadvantage: It is hard to upgrade existing sites. FeatureUpgradeActions were introduced in SharePoint 2010, but it is still a manual job.

In 2016, the feature framework has been deprecated in favor of using CSOM / SSOM. I’m going to look at the framework we are using for most of our SharePoint projects to make this a breeze: SPMeta2.

Continue reading

How to know the sentiment of an email BEFORE reading it

Imagine you want to know the sentiment of an email without reading it. This can be useful if you want to ignore negative emails for certain parts of the day. I have built a solution for that, by integrating Azure Machine Learning in an Office Outlook Add-In. Every time you read an email, it processes the body, sends it to Azure, and displays if it is negative or positive Continue reading

How to: Send an email if a Salesforce opportunity is won using Microsoft Flow

After my blog post yesterday about Flow, I got a request from a user to build a Flow for Salesforce that does something when an Opportunity is closed, and checks if it was won or lost.

I love feedback, so I decided to build that flow. The result? Check out below email:

Continue reading

« Older posts