Exception ‘Microsoft.ApplicationServer.Caching.DataCacheException: ErrorCode:SubStatus

As the title suggests this post is going to be about a specific issue I came across at a customer site recently in a new deployment of SharePoint 2013 that relates to the distributed cache service. Definitely one of the more challenging ones to troubleshoot from what I have seen before so I figured I should capture the result here in case it helps someone else. Continue reading “Exception ‘Microsoft.ApplicationServer.Caching.DataCacheException: ErrorCode:SubStatus

Directly querying SharePoint databases

One of the first rules of SharePoint that you learn when you start diving in to the product is that you shouldn’t ever touch the SharePoint databases – it’s fairly well known that you should leave them alone, but I’ve been asked the question a few times over the years “Well what if I’m just reading from the databases? Surely that’s ok because I’m not making any changes to the data”, so what I wanted to cover off in this post is why it’s not a great idea to read from the databases and what the impact of doing this is. Continue reading “Directly querying SharePoint databases”