It was that time of the year again to visit Belgium for their SharePoint Saturday. An excellent day organized by BIWUG.
This year was a tribute to an amazing SharePoint teacher who passed away too soon, Patrick Tisseghem. I did not know him but heard and read about him, I only was working 1 year with SharePoint when he passed away. During the day there were videos and photos about the things he did for the community.
Last two weekends I went to SharePoint Saturday in Paris and Belgium. It is always great to meet other SharePoint and Office 365 consultants, customers and suppliers.
The first weekend I went to Paris where I did not read my emails to carefully, so I was at the wrong venue. I was not the only one. It took some extra time to get to the new location. Arrived there I was just in time for the first session; this was a session about the secure score site from Microsoft. The URL of the Secure Score is http://securescore.office.com. Here you can log in with an administrator account and see what security settings you can do to make your tenant more secure. You need to be a Global Administrator, SharePoint Administrator, Exchange Administrator or Compliance Administrator to access it.
Last weekend I visited SharePoint Saturday in Brussel Belgium. This was my fourth time here in Belgium and again a great one. The day was setup up 6 sessions of 50 minutes and a lunch break of 1.5 hours with a 30 minute.
We started at 9 with a welcome from the BIWUG team and the first session started short after that. I started with some developer sessions.
I started the day with a session from David Opdendries (@sharepointdavid)
Last week I had the privilege to attent Microsoft Ignite in Atlanta. This week was full of news, sessions and a lot of walking. Besides the sessions, this year the expo hall was large, I have spend a lot of time at the expo talking to venders, partners and Microsoft.
I have created a PDF from all my notes. On a few notes I have references to slides, the slides should be come available on https://myignite.microsoft.com/videos. On this site are also all the videos.
I’m part of the Microsoft Heroes at Sogeti and this week we had an evening event about DevOps where I did a talk about the operations part of DevOps for Office 365.
At my current customer we are preparing Office 365 for deployment to every employee in the Netherlands. So far we had moved 1000 employees of one operating company and we are now working to get the rest of the Dutch working companies to Office 365. To make this happen we used PowerShell automation to make our operations work a lot easier and more fun by automating the boring and repeatable stuff.
In the trend of my recent blog post I create a new addition to my automation of Office 365 tasks. This time creating a report with the license consumption per month with PowerShell automation, Azure table storage and Power BI. In this post I will take you with me thru the steps to set this up.
Before we can get started coding we need to do some plumbing first. The first thing we need is a storage account. From this storage account we need the connection string.