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:...

Indexing .rtf files in SharePoint 2016

Published at July 20, 2017 ·  1 min read

Although Windows Server 2012 R2/2016 comes with an IFilter for .rtf-Files, SharePoint does not crawl/index .rtf files out of the box. The following article lists .rtf as a crawled filename, but it also states, that .rtf is not in the Managed File Types page by default: https://technet.microsoft.com/en-us/library/jj219530.aspx What happens when you add .rtf to the Managed File Type in the SharePoint Enterprise Search Service Application and Restart OSearch16? The file gets crawled, but with an error saying the file is “in a wrong format”....

SharePoint Virtual Summit – a summary

Published at May 16, 2017 ·  1 min read

Here’s a short summary of today’s SharePoint Virtual Summit: Extend Lists and Libraries with SPFx Modern Pages did not allow any customizations with JavaScript (eg. things we could do with jslink). With the new SharePoint Framework it will be possible SPFx – included in FP2 (fall) The SharePoint Framework will we included in Feature Pack 2 for SharePoint 2016, which is scheduled for fall 2017. Webhooks across sites and lists Until now, Webhooks in SharePoint Online are only available in Document libraries, now they will be extended to sites and lists....

Yes, there will be a new major version of SharePoint

Published at September 27, 2016 ·  1 min read

Today at Microsoft Ignite in Atlanta there were some interesting announcements during Bill Baer’s and Troy Starr’s session: There will be a new major version of SharePoint on-premises, MS is already working on it No more Service Packs: Updates are only delivered through Public Updates (PU, formerly called Uber-Cumulative-Updates), there will be no Service Pack for SharePoint 2016 Feature Packs will bring new functionality, the first one is scheduled for November, the second one for Q2 2017....

PSConfig error: The upgraded database schema doesn't match the TargetSchema

Published at June 16, 2016 ·  1 min read

When applying a Cumulative Update to your SharePoint 2016 Farm, you might run into troubles when executing PSConfig/PSConfigUI after installing the Binaries. The error that is logged in the Windows Event Log looks as follows: The Execute method of job definition Microsoft.SharePoint.Administration.SPUpgradeJobDefinition (ID ..) threw an exception. More information is included below. The upgraded database schema doesn’t match the TargetSchema. (Correlation=..) You can avoid this issue if you either dismount all the Content Databases before executing PSConfig/PSConfigUI (which is a good idea in larger environments anyway) and upgrade them later in a second step or upgrade all the Content Databases before executing PSConfig/PSConfigUI with something like Get-SPContentDatabase | Upgrade-SPContentDatabase....

SharePoint Saturday Stockholm - Slides

Published at May 22, 2016 ·  1 min read

After a great SharePoint Saturday in Stockholm, you can find the slides for my session “What’s new in SharePoint 2016” at docs.com: https://doc.co/EuAWoA Markus...

Speaking at European SharePoint Conference 2016 in Vienna

Published at April 21, 2016 ·  1 min read

​All kinds of cool SharePoint-contents, a lot of fellow MCM-colleagues - happy to be a speaker at the European SharePoint Conference 2016, taking place in Vienna from November 14-17. My Session will be about User Profile Synchronisation with SharePoint 2016 and Microsoft Identity Manager 2016. I hope to see many of you there.  Markus...

Speaking at Microsoft Techconference 2016 Austria

Published at January 11, 2016 ·  1 min read

I’m excited to talk at the largest Microsoft Technology Conference in Austria about “SharePoint 2016 Infrastructure/Upgrade” and “SharePoint 2016 Hybrid Solutions”. If you want to get inside knowledge about the latest Microsoft Technologies (Windows Server 2016, SQL 2016, Exchange 2016, SharePoint 2016, PowerBI, Office365 etc.), get your ticket at www.techconference.at and come to Vienna from 20.-21.1.2016. See you there. Markus...

Speaking at SharePoint Saturday Munich

Published at August 18, 2015 ·  1 min read

I’m proud to be a part of the first SharePoint Saturday in Munich on October 10th, 2015. Come and join an awesome lineup of speakers (and me) for a lot of in depth Information on SharePoint 2013 and 2016. My Session will be about the changes in the User Profile Sync Service in SP 2016. http://www.spsevents.org/city/Munich/Munich2015/_layouts/15/SPSEvents/Speakers/Session.aspx?SpeakerId=1168&ID=109 Session details will be revealed soon… Don’t miss this free, all English event, registration starts on September 1st....

What’s new in SharePoint 2016

Published at May 7, 2015 ·  1 min read

Today, at Ignite Conference in Chicago, Microsoft released some interesting facts about the new Version of SharePoint called “SharePoint 2016”. Hardware requirements stay the same as for SP 2013 Software requirements change quite a bit (Windows Server 2012 R2 or higher, SQL 2012 or higher) Standalone Setup (with SQL Express included) is no longer an option You need to use the “Single Server” option and can install SQL Server on the local machine....

Extract .wsp files from SharePoint Config Database

Published at January 14, 2013 ·  2 min read

I recently had a customer with the need to extract a .wsp (SharePoint Solution) File from the SharePoint Farm Solutions because the source file disappeared mysteriously… As SharePoint loads the .wsp file into the config database (SharePoint_Config in most SharePoint environments – although it should be a name that you can recognize easily – you don’t name you files dok1, dok2, etc.) and stores it as binary content, it is not too hard to extract....