SQL AlwaysOn: Failed to join the database to the Availability Group (Error 35250)

[Updated on 5/16/2017] Alternate solution for fix# 2 You might get this particular error “Failed to join the database to the Availability Group (Error 35250)” when you are creating a new Availability Group (AG) and initiated a Full sync which basically copies the backup and attaches the DBs on the replica servers. You will see tin…


Change Host Named Site Collection Url

Previously (i.e. until SP2010) zones was applicable only at the Web App level. You can have up to 5 zones and thus five different urls. With SharePoint 2013 this concept has been extended to the Site Collection level – but only to the Host Named Site Collections (HNSC). You can have up to 5 different URLs each…


Deploy Remote Event Receiver without using add-in or app (without using AppInstalled event to be precise)

UPDATED (3/31/2017): Added links to GitHub projects/source code. See at the end of this article. You still need to create a dummy app(cliend id/secret creating an app principal) or install a provider hosted add-in/app that acts as a placeholder (dummy). More details below. Below article is based on my work on SPonline (not on-premises). How does remote…


SharePoint Online incoming email alternatives

  Incoming email is one of the features that’s not available in SharePoint Online. Customer with on-premises SharePoint deployments have been using incoming email since a long time and hits this feature gap when migrating to SharePoint Online. A quick search online shows that there are a number of third party solutions filling this gap….


Office 365 CDN – Preview vs General Availability

Office 365 CDN which provides a way to configure a SharePoint Document Library as a CDN is now Generally Available. The preview was released few months back and if customers already using it while in Preview must know that the PowerShell commands and the way this works has changed a lot in General Availability. With…


Issue with peoplepicker-searchadforests stsadm

Some might be thinking that STSADM is no more valid especially with SP 2013. Well, its not. STSADM can still be used in SP2013 and some settings like PeoplePicker settings can be easily configured using the STSADM commands. One of the commands (PeoplePicker-SearchADForersts) is used to add/remove AD domains in SharePoint servers so that the users…


Site Collection Administrators – SharePoint Online vs On-Premises

SharePoint Online                 Primary Site collection Admin                                 SPSite.Owner returns the Primary Site Collection Administrator. This is a single user property. Below is sample CSOM code: $owner = $site.Owner $Context.Load($owner) $Context.ExecuteQuery() Write-Host $owner.LoginName                 Site collection Admins In SPO, we are allowed to add multiple users as Site Collection Administrators. This can be done…


SharePoint: Best practices for uploading more than 5000 items to a library/list (aka large lists)

Requirement: Store thousands of documents in SharePoint Online (or on-premises) document library without facing any threshold (5000 item limit) issues. This post is assuming that you either have a bulk of documents to be uploaded along with the metadata (in a CSV file) or expect the library to grow in thousands. So prepare for that….


SharePoint Online Page Layout Pages with Summary Links – Error while executing the web part

You have a page that is based on page layouts that contains summary link web parts or the field control. And when you edit the page properties, you will see an error for the summary links web part or the field control section something like below: “Error while executing the web part” along with a correlation…


Office Dev PnP PowerShell and the clash with Get-SPOSite cmdlet

Office Dev PnP PowerShell library provide a number of useful commandlets that comes handy when administering SharePoint Online. As per the instructions on GitHub, you could easily install Office Dev PnP PowerShell cmdlets by running below PowerShell command: Install-Module SharePointPnPPowerShellOnline If this works without any issue then you are good and you can start using the…