Why you should use a really old SQL Compatibility Level for your SP2016 databases

Published at December 3, 2018 ·  1 min read

You might know, that the support policy for SharePoint and SQL Server has always been N, N-1, N+1 That means that for SharePoint 2016 the supported versions of SQL Server are SQL 2016 (N), SQL 2014 (N-1) and SQL 2017 (N+1) – which means a database compatibility level of 12 or higher. But when reading this knowledgebase article and Stefan Gossner’s blog, it turns out, that selecting a database compatibility level of 11 (SQL Server 2012) is beneficial for the performance of the SharePoint farm....

SPRequestDuration is back in SharePoint Online – kind of…

Published at April 4, 2018 ·  1 min read

When troubleshooting SharePoint (Online) performance issues, the SPIISLatency and SPRequestDuration headers are a very important part of the puzzle. Unfortunately, Microsoft removed those headers from SPO - honi soit qui mal y pense. Despite a few reappearances for a short time – I missed those headers every time when dealing with MS Support in SharePoint Online Performance Cases (https://sharepointinterface.com/2017/07/07/the-five-minute-page-performance-troubleshooting-guide-for-sharepoint-online/) But now, it looks like the performance figures are back – but depending on the UI you chose, in different flavors:...

Document Libraries not listed in dropdown when creating a Flow for SharePoint

Published at March 23, 2018 ·  1 min read

Microsoft took a big step forward when integrating Flow into SharePoint-Lists by allowing us to execute a flow on an existing SharePoint ListItem or Document. However, if you try to create a flow on a document by executing the following steps, the dropdown only shows Lists and no Libraries: So this dropdown is missing all the existing libraries and shows only Lists. Does this mean, that we can create a Flow on an existing ListItem only?...