Microsoft SharePoint, Microsoft 365: studying, certification

Submitted by Vladilen on Sun, 09/17/2017 - 22:11

Here are some resources to study, learn, improve your skills on Microsoft SharePoint, SQL, Office 365, Azure:

Officially free:

Parse IIS logs for SharePoint with powershell

Submitted by Vladilen on Wed, 03/01/2017 - 01:50

I found pretty useless IIS Log Parser (with Studio) for SharePoint. 
The reasons are - blank spaces and "%20" symbols in Url in SharePoint IIS logs which confuses IIS Log Parser and  prevents you from search through logs using IIS Log Parser 

i.e., if your SharePoint users want to investigate their file "/sites/Very%20Important%20site/much%20more%20important%20unique%20file.docx" - you will stuck.

finally, I found plain Powershell commands the most useful to parse IIS logs, like this:

OneNote properties in SharePoint

Submitted by Vladilen on Fri, 12/16/2016 - 16:15

OneNote document is not a one file, but a number of files in a folder. You can save OneNote document in SharePoint and it would looks like a file, but internal implementation of OneNote in SharePoint is actually a folder content type.

And if you try to assign properties to OneNote document - you just can't.

I haven't seen any clear instructions from Microsoft on the subject. And here we have an “unsupported” workarounds. Actually, there are two: “Change Content Type” way and “Quick Edit View” way.

Project Server 2016

Submitted by Vladilen on Tue, 11/15/2016 - 06:50

As you know, Project Server 2016 is actually a service application on SharePoint Server 2016.
Which means if you want Project Server 2016, you must have SharePoint 2016 first.
But if you have SharePoint 2016 farm, it's much easier to get Project 2016. Moreover, once you build robust, scalable and high-available SharePoint, you get the same to you Project "for free".
NB: Project is licensed separately.