Month: June 2014

SharePoint 2013 Minimal Fault Tolerant Configuration!!!!!!!

Posted on

Microsoft offers some advice and guidance on different farm configurations, however, starting with SharePoint 2013 there seems to be a preoccupation with the number of VM hosts that are involved and how the virtual servers are deployed across these servers.

Certainly managing the distribution of virtual servers across your physical virtual infrastructure is important, however, this adds a layer of complexity in trying to understand the number of virtual servers which need to be created which can be safely deferred until you’ve determined the virtual servers and the resources they need.

The more difficult challenge I find with my clients is how many virtual servers are needed for a fully functional fault tolerant environment. The Microsoft answers are incomplete because they fail to take into account the Office Web Applications and Azure Workflow Service infrastructures which are required to fully utilize SharePoint. The diagrams provided on the posters from Microsoft simply don’t make it clear how these pieces fit together and the number of virtual servers that you’ll need. My goal in this post is to clarify ambiguity about the number of virtual servers, to provide a model for a minimally fault tolerant environment, and to create a plan that can be expanded for scalability.

To read more about this, click here:


Creating/Editing XLSX or DOCX documents directly in JavaScript!!!!!!!!!!

Posted on

There are numerous things you need and it involves a number of different script libraries, all with varying documentation. Hopefully this post will put you in the right direction, mostly because it includes the source code to a working example of creating an Excel Spread Sheet in JavaScript and uploading it to a document library in SharePoint.

First the bits you need

In order to get this working you need to add a few scripts to your project. Fortunately Eric White over atOpenXmlDeveloper has done a lot of the hard work for us. I am basically adding a bit of SharePoint stuff to his work and it’s always nice to have a working sample.

Firstly you will want to have a look at the Open XML SDK for JavaScript, which provides some wrapping for the Open Xml specification in JavaScript. The Open XML for JavaScript provides some useful examples, but if I am honest they do take a lot of reading and viewing of webcasts to get anything working; And once you add SharePoint into the mix it obviously gets a bit harder.

To read more about this, click here:

Advanced SharePoint Extranet Management: (ExCM) 2013 Advanced Features – User Automation!!!!

Posted on

The ExCM User Automation (UA) feature can be used to apply recurring policies to accounts residing in the ExCM user database. These policies are applied by a SharePoint Timer Job, which periodically inspects each account.

UA can be used to expire user accounts based on attributes such as periods of inactivity or failure to update their password within a specified period, solving the problem of user “housekeeping.”


You first need to enable the SharePoint Service object, which is used to provide farm-wide services and configuration data. To activate the service, open the SharePoint Management Shell and typed the following command:

To read more about this, click here:


Creating Sample Data for SharePoint 2013 Lists and Libraries!!!!

Posted on

Creating semi-realistic sample data can be time consuming and generally a bit of a pain. Well now you have a free SharePoint App which can help you out.

The Sample Data SharePoint App

The app adds a custom action to several lists and libraries. Specifically it can generate sample data for the following…

Custom Lists, Document Libraries, Asset Libraries, Wiki Libraries, Calendars, Discussions, Tasks and contacts

To read more about this, click here:


JOPX on SharePoint, Big Data and the future of business!!!!!

Posted on

SharePoint 2013 allows you to view the result of the ranking model by retrieving the rankdetail managed property. The rankdetail property will only be returned when there are less than 100 results in the returned search result set.

There is however an interesting tool hidden inside SharePoint which outlines the rankdetails calculation which I found in Explain rank in SharePoint 2013 search. SharePoint 2013 contains a built-in  application page called /_layouts/15/explainrank.aspx which accepts two mandatory parameters:

  • q – which contains the query
  • d – which specifies the path of the item for which you want to see the rankdetail

You can download a specific Explainrank search display template which will incorporate a link to the explainrank.aspx page with the required parameters. An alternative for this which will also work on Office 365/SharePoint Online is the Mavention Search Ranking app. My current favorite for the moment is theSharePoint 2013 Search Query Tool which also allows you to show rankdetails and rank calculation.

To read more about this, click here:

What to Expect at Microsoft TechEd 2014!!!!!!!!!!

Posted on

With the Microsoft TechEd 2014 conference closely approaching, we’ve been covering top SharePoint vendors to watch at the Tech Expo.

We’ve also parsed through the massive TechEd content agenda, pulling out what we believe to be the most relevant sessions that are worthy of your time from a SharePoint and Office 365 perspective.

And now, I’d like to spend some time analyzing potential directions that Microsoft might take at the show. This commentary piece is based on the company’s recent announcements and messaging that has been very focused on providing a clear picture of where the company headed.

To read more about this, click here:


TechEd 2014: Protect Your Data in SharePoint Online and OneDrive for Business!!!!!!

Posted on

Microsoft announced two different enhancements will help organizations move their businesses to the cloud without having to compromise security for their on-premises and cloud environments.

Beginning in June, existing Data Loss Prevention capabilities in Exchange will now be expanded to include documents stored in SharePoint Online and OneDrive for Business for Office 365 E3 enterprise customers. The expansion well help to ensure prevent sensitive sharing inside and outside the organization.

Starting in July, Microsoft will start deploying new encryption technology for Office 365 business customers to ensure that every file stored in SharePoint Online and OneDrive for Business is encrypted with its own key for highly secure content storage.

To read more about this, click here: