Microsoft Collaboration, CTO viewpoint, and New York

The blog for Office 365, Power Apps, Flow, SharePoint, cloud, ….. plus a little NYC

Sharepoint Saturday NYC coming up

Written by Peter Ward on July 7, 2017 – 2:20 am -

Add a comment

Yoga Day in NYC 2017

Written by Peter Ward on July 2, 2017 – 1:18 am -

Add a comment

Increasing the speed of Office 365 search crawl

Written by Peter Ward on July 1, 2017 – 11:48 pm -

With SharePoint on premise there’s plenty of search options to increase the frequency of the search crawl, to the search results show up quicker.

– Increase the incremental search periods

– Add on an app server to take on the additional search horse power

– Target sites or site collections that require quicker search crawls

The list can go on….


But with Office 365, this ability isn’t there..

Chris O’Brien has a good explanation on this: waiting-for-search-crawl-in-office-365 with some work arounds, but queries can break.


One approach I discovered was to set the server resource quota to 10,000. By default it’s 300. This setting can be found in the SharePoint Admin Center.



When I did this I was getting search results in 5-10 mins after a document was uploaded.











Add a comment

The Life-Changing Magic of Tidying Up: The Japanese Art of Decluttering and Organizing” by Marie Kondo

Written by Peter Ward on June 10, 2017 – 11:36 pm -

Just finished reading this book….

The Life-Changing Magic of Tidying Up

The Life-Changing Magic of Tidying Up

Marie Kondo is a Japanese organizing consultant who developed the KonMari Method, which consists of gathering everything one owns by category and keeping only those things that “spark joy.” Kondo’s method transcends the typical “tidying how-to,” as it aims to cultivate a lifestyle that encourages one to cherish the things that bring true joy—a refreshing alternative to today’s mass consumer society.


A very organized person





Add a comment

SharePoint 2016 load balancing

Written by Peter Ward on April 13, 2017 – 1:29 am -

So you are doing an on premise migration from 2010 to 2016, so of course in true Microsoft style, more boxes are required, so that means more web front end servers.

Changes are that on 2010, you had 1 WFE server, and in 2016 you’ll need at least 2, or you should, so that means load balancing is required.

If IT has load balancing software like KEMP then I would suggest use that, if it doesn’t then use Network Load Balancer (feature of Windows Server OS), which will involve playing around with IP addresses and hyper v settings. More skills for the SharePoint Admin to learn.

Good luck

Useful Links

Add a comment

What is it like becoming a Microsoft Value Added Reseller

Written by Peter Ward on April 13, 2017 – 1:00 am -

Today there are over 300,000+ Microsoft partners reselling the Microsoft shiny stuff like CRM, ERP and document management tools and as any MS partner will tell you, there has been good, great, and wobbly years, but as any sales person will tell you, the growth curve is not always a straight line.

I would not say becoming a Microsoft Partner was the best career move I ever made, but it was certainly up there in the top 3 decisions I have made in my 25-year career.

Recently I was featured on the podcast series Life Skills That Matter, hosted
by Stephen Warley, where I explained the value-added reseller concept and the Microsoft partner model. He was a bit surprised that this existed with Microsoft and that partners where required to install and deploy its software. Microsoft does exist beyond Word and Excel.

The podcast: Creating a Value Added Reseller (VAR) Business With Peter Ward

Are you familiar with a business model called Value Added Reseller or VAR? If you aren’t, it’s another interesting self-employment option I’m excited to introduce you to!

Peter Ward is the co-owner of SohoDragon, a Microsoft partner or VAR based in New York City.

Useful Links

To become a Microsoft VAR

Add a comment

Feel the Bern 

Written by Peter Ward on April 2, 2017 – 7:25 am -

Add a comment

Ever had a problem of Office document not opening in the client app..

Written by Peter Ward on February 4, 2017 – 7:25 pm -

Ic: Word, Excel

This is the fix.

Here are the revised steps.


  1. Open the Run Window, this can be done by pressing the “Windows” and “R” Keys simultaneously on your keyboard.

  2. Type regedit in the window and click OK. This would open the Registry Editor.
  3. On the Registry Editor, expand HKEY_CURRENT_USER.

  4. Then scroll down and expand Software.

  1. Then similarly expand Microsoft->Office->16.0->Common->Identity
  2. Right Click on Identity and select New-> DWORD (32-bit) Value.



  1. Name the value as EnableADAL. Make sure you type this exactly as how it is listed, it is case sensitive.

  2. Restart your computer.

Should all work

Add a comment


Written by Peter Ward on January 11, 2017 – 7:10 pm -

Add a comment

So your Office Web Apps isn’t working….Suddenly stopped working

Written by Peter Ward on October 8, 2016 – 12:28 pm -

This happened to me the other day.

So how to troubleshoot… Look in the ULS logs.

To configure office web apps you’ll need:

-Office Web Apps Farm Internal URL:
-Office Web Apps Farm External URL

For me it turned out to be the certificate.

I found errors in Office Web Apps ULS logs, so I had also run Get-OfficeWebAppsFarm command which showed me the same error that the computer is not part of an Office Web Apps Server Farm. So I tried creating new farm using New-OfficeWebAppsFarm comment yesterday where I used “*” as certificate name in this command, but I got error that certificate was not found. Then today I used the friendly name of certificate and it worked.

New-OfficeWebAppsFarm -InternalUrl “” -ExternalUrl “” -CertificateName ” domainnameDigiCert Wildcard” -EditingEnabled

This problem usually happens due to windows updates getting installed on Office web apps server.

Add a comment