Jean Paul's Blog

There are 2 types of People in the World, One who Likes SharePoint and..

  • Microsoft MVP

  • MindCracker MVP

  • CodeProject MVP

  • eBook on SharePoint 2010

  • eBook on Design Patterns

  • eBook on Windows Azure

  • NLayers Framework @ CodePlex

  • MSDN Forums

  • .Net vs. Java

    Due to Public Demand

Posts Tagged ‘online’

Sandboxed Solution & SharePoint Online Compatibility

Posted by Jean Paul on February 12, 2017

In this article we can explore Compatibility of Sandboxed Solution with SharePoint Online.


I am seeing that many developers are recommending Sandboxed Solutions for On-Premise and Online deployments.

But, the Twist is that SharePoint Online does not support all sandboxed solutions. So if your solution has a Strategy Architecture comprising of SharePoint Online, you need to be really careful recommending Sandboxed Solutions.


Sandboxed Solution is of two types:

1. No-Code Sandboxed Solution (NCSS)

2. Code Sandboxed Solution


NCSS contains only HTML & CSS markups. No code will be there.


NCSS is the recommended & only allowed one in SharePoint Online.


Create a new Sandboxed Solution.


Add a Visual Web Part. Do not add any code. Build the project.

Now Upload the NCSS and we get the Activate button enabled. This proves No-Code Sandboxed Solutions can be activated in SharePoint Online. (as of today)


Now come back to Visual Studio & Add place a button on the Visual Web Part.

Add code to the click event handler.


Build the project.

Now upload the Coded Sandboxed Solution to SharePoint Online. You can see the Activate button is disabled.

So this demonstrates that SharePoint Online does not support Coded Sandboxed Solutions.


Sandboxed Solutions were the Solutions of the past and now being deprecated. In the modern SharePoint development world REST, CSOM, Apps are the recommended approaches. Plus, there is a risk that Sandboxed Solution can get disabled in future versions of SharePoint/Online.



In this article we have explored Compatibility of Sandboxed Solution with SharePoint Online.

Posted in SharePoint, SharePoint 2013 | Tagged: , , , | Leave a Comment »

When not to go for SharePoint Online?

Posted by Jean Paul on November 22, 2014

When not to go for SharePoint Online?

In this article I would like to share the scenarios where choose not to go for SharePoint Online.

Legal documents

If the client do not wanted to expose their documents over Internet, then obviously SharePoint Online won’t be a right fit for them.

Bandwidth Limits

If your client has bandwidth limits & policies coupled with big-sized document management, then going Online is not a good option.

(Workspace/Shredded Storage are alternative options though)

Offline Accessibility

If your client prefers more offline availability of the documents with easier Sync, then On-Premise would provide better flexibility.

(Groove is an alternative option though)

Connection Speed

On-Premise works better than Online if connection speed is a bottleneck.

Farm Solutions

SharePoint Online does not allow Full Trust/Farm Solutions.  If your project requires that old solutions to be migrated, then going Online would be restrictive.

(Microsoft Support provides a separate path for deploying Farm Solutions but will be process-oriented and you might get delayed with deployment & instrumentation)

Heavy Customization

If heavy customization & flexibility on master pages required then going Online can be restrictive.

The above scenarios restrict us to prescribe SharePoint On-Premise with/without a public-hosting.



In this article we have explored the cases for not going with SharePoint Online.

Posted in SharePoint, SharePoint 2013 | Tagged: , , | Leave a Comment »

SharePoint 2013 – Online vs. On-Premise Comparison

Posted by Jean Paul on June 3, 2014

What all things we should keep in mind while choosing between SharePoint Online or On-Premise?


Global Reach

Online provides global access. Thus we can easily share site resources between customers, vendors, contractors.

On-Premise requires public hosting to achieve this.

Internet Connectivity

Online requires Internet connectivity to actively work.  Slow Internet Connections & Offline situations can really affect your work, unless you have a proper offline work plan.

On-Premise does not raise this problem.

Site Administrator

On-Premise comes with a necessity to hire an Administrator to make the On-Premise infrastructure smooth & running.

Online have dedicated Microsoft Support Staffs & the costs are inclusive in the subscriptions.


Online enables more availability compared with On-Premise.  Plus, we have the luxury to call Microsoft Support for emergency situations.


If you have good internet speed, the Online version should not impose any delays in site access, document uploads / edits.


On-Premise comes with limited capacity & the company needs to hire resources & infrastructure to scale up.

Online supports easy scalability by increasing subscription cost.  Cost as well as Time should be an advantage here.


Site Collection count, maximum size, user count etc. varies for Online & On-Premise systems.

On-Premise allows flexibility of increasing upload sizes through configuration changes.  Online does not allow so.


On-Premise imposes no-traffic restrictions.  Please confirm Online traffic-restrictions as per your need.


On-Premise provides easier Synchronization of your local user directory infrastructure like Active Directory.

Online requires separate user-creation & probably a managing or synchronizing infrastructure.

Backup & Restore

Backup & Restore flexibility differs in Online & On-Premise systems.

Please consider this factor while choosing.

Custom Solutions

Online exposes more restrictions to custom solutions including Apps, Server Object Model, Farm solutions etc.  Additional limitations on My Site master page, Feature Stapling etc.

On-Premise enjoy more freedom & flexibility here. 

Sandboxed Solutions

Sandboxed Solutions will have Quota Limits & It is hard to change these limits on Online, till date.

IIS Limitations

Like On-Premise the IIS items & configuration files are not accessible in Online. 

Custom Managed Paths

Custom Managed Paths are not allowed in Online.


Search Crawl Schedules & Programming against Content Sources are limited in SharePoint online.

External Application Hosting

On-Premise provides flexibility of hosting custom solutions & timer jobs within the host machine.

Online does not provide these & we need to add extra infrastructure for this.

External Systems Integration

Online imposes more restrictions on external system integrations through External content type, BCS, Content Sources etc.


On-Premise provides more freedom for Branding customizations.


On-Premise provides extensive PowerShell support.

Online imposes restrictions on the available PowerShell cmdlets.


On-Premise provides flexibility in turning the end storage as RBS or custom.

Online does not allow so.

Document Management

Records Center not available in Online.

Business Intelligence

PowerView, PowerPivot, Dashboards, KPI features vary on On-Premise & Online editions based on subscriptions.

Please ensure your use case mappings are met.

One Drive Pro

OneDrive Pro for business is supported for Online.  This handles the offline problems of SharePoint Online to an extent.

In On-Premise separate configuration & synchronization is needed.

Office Web Apps

Online supports Office Web Apps which allows viewing & editing of Office documents.

On-Premise requires separate license & configuration to allow this.  Typically, On-Premise users goes with Office desktop applications.


Online have more restrictions on Social & Collaboration features like activity feed, tagging, forums etc.


Translation services are up & running in Online.  For On-Premise we need to setup & configure.

Posted in SharePoint, SharePoint 2013 | Tagged: , , , , | Leave a Comment »

Active Directory Sync Tool

Posted by Jean Paul on March 23, 2014

While working with SharePoint On-Premise & Online editions, one need to perform the following:

  1. Synchronize On-Premise Active Directory Accounts to Online Active Directory
  2. Synchronize Online Active Directory Accounts to On-Premise Active Directory

In short, the requirement will be Two-way Synchronization

Active Directory Sync Tool

The Directory Directory Synchronization Tool enables us to securely synchronize selected data between an on-premise Active Directory and the Forefront Online Security.


You can download the tool from following location:


Download Link


Posted in SharePoint, SharePoint 2013 | Tagged: , , | Leave a Comment »