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…

8

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

7

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…

6

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…

5

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…

3

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…

3

Create SharePoint Large Lists using Microsoft Flow (no-code solution)

This is the part 1 of the 3 part series related to handling large lists with Microsoft Flow – a no-code solution. This post will demonstrate how you can create large lists with test data. There could be many reasons to create a large list. In my case, I had to demonstrate how PowerApps can…

2

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…

1

Using Microsoft Flow with Large Lists (3 part series)

Microsoft Flow and Large Lists – Part 1 Create Large Lists/Libraries using Microsoft Flow (no-code solution) Microsoft Flow and Large Lists – Part 2 Iterate and get all items from a Large List/Library using Microsoft Flow (no-code solution) Microsoft Flow and Large Lists – Part 3 Update all items in a large list/library using Microsoft…

0