Super SQL Server Clusters for SharePoint – Part 2

This is part two of one of how to setup the mother of all database clustering solutions for SharePoint. In part one we setup the failover cluster, installed SQL Server and configured the failover clusters. Previously we’d setup our super-cluster & installed SQL Server, this time with two failover clusters; one for each farm. Now…


Super SQL Server Clusters for SharePoint – Part 1

When I demonstrated AlwaysOn for SharePoint Disaster Recovery setups a while ago, the SQL cluster model I setup wasn’t strictly speaking highly-available. This is because there’s no failover for SQL Servers synchronising data between both SharePoint farms. A couple of people have pointed this out now and as this is technically a potential fault, I…


Repairing OneDrive “Next-Gen” Sign-in Loop of Doom on Windows 10

So I had a long-running issue where the next-generation OneDrive sync client just wouldn’t sign-in to my corp account, and nothing was syncing. I had tried the nice steps laid out on the support site, plus some more, but to no avail – the icon would stubbornly sit on “OneDrive for Business – Signing in”…


SharePoint Disaster Recovery vs. Active Passive Farms

Just a quick clarification on terminology & methodologies for SharePoint “disaster recovery” (DR). In case you didn’t know already, multiple SharePoint farms can be run sharing the same content data, which is very handy if you need near 100% uptime for your SharePoint sites & apps. If for any reason your primary farm dies, you…


SharePoint Upgrade/Configuration Wizard Never Finishes

Some people may have had issues where the SharePoint Configuration Wizard never seems to finish an upgrade. This is a quick & dirty post to explain how finish it, as cleanly as possible. First; terminate the process via task-manager as closing the form will try and abort the dead upgrade process, so will never actually…


Patching SharePoint DR Farms with Replicated Service-Applications with SQL Server AlwaysOn

So now we’ve got an active/passive SharePoint farm solution setup, the next question that is how to patch both farms with as little drama as possible. We need to patch one farm while the other’s in use so that our beloved users don’t notice anything’s even happened to SharePoint – one of the key reasons…


Running SharePoint Service Applications in Read Only Mode for Disaster Recovery Farms

As mentioned before, there’s good reason to have a disaster recovery (DR) farm setup for SharePoint if you need near 100% uptime. As also mentioned, you may need to synchronise some service-applications between farms too for data consistency; taxonomies, user-profiles etc often go hand-in-hand so having unique service-applications on each farm just isn’t an option….


Why Does SharePoint Start-up So Slowly?

A question that comes up often is why SharePoint takes so long to do anything the first time something’s accessed after an IIS restart, or machine reboot. Typically for a non-technical person this is what triggers this question: A page is opened in the browser by the user. SharePoint takes its’ sweet time getting said…


Getting SharePoint Event IDs “90hv” and “nask” Despite Disposing Just Fine

Most SharePoint developers will have probably have seen these SharePoint event IDs at some point or other, especially if you’ve ever worked with server-side code before. How to properly manage server-side SharePoint objects is pretty well documented already, but I’ve found it’s still easy to reproduce these “errors” even with good clean-up logic in code. I’ve seen…


User Profile Application Unavailable with UserProfileApplicationNotAvailableException

If you’ve ever had a problem with the user profile application (UPA) not working, this post is your checklist. It’s not the clearest problem to troubleshoot. The error usual manifests as a “UserProfileApplicationNotAvailableException” exception, or in detail: Failure retrieving application ID for User Profile Application Proxy ‘{name}’: Microsoft.Office.Server.UserProfiles.UserProfileApplicationNotAvailableException: UserProfileApplicationNotAvailableException_Logging :: UserProfileApplicationProxy.ApplicationProperties ProfilePropertyCache does not have…