Send to Kindle

May 6, 2014

SharePoint Timer Job Development

Summary Best practice for SharePoint Timer Job development

Downloads Keywords: SharePoint Timer Job

Mar 4, 2014

SharePoint Explorer View Not Working

I had this strange issue at a client site today. They have SharePoint 2010 and it was working with Explorer View perfectly fine until they installed the WebDav role with Keberos.

Suddenly Explorer stopped working for their users using IE 9+. I was able to reproduce the issue and tried the following:

- Restarting the WebClient Service

- Used 32 bit version of IE

Funnily enough, the client found an old XP box and was able to launch explorer view from there. I think it was somehow related to Keberos and possibly a double hop issue.

I uninstalled WebDev and sure enough, Explorer View started working again!

I will investigate further and update this post.

Nov 17, 2013

SharePoint 2013 for Education

I have recently started work with an client in the education sector, managing schools via the Scholaris software built on top of SharePoint, which also integrates with Maze

I have also worked with the Blackbaud system in the past which is a great tool for fund-raising.

From their websites:

Maze is a complete, fully customisable School Management System ideal for schools of all sizes. Schools choose Maze because it assists them in efficiently managing all back office processes in one integrated system.

iScholaris is an easy to use App for Teachers, Parents and Students that is accessible as an App or via a browser.Integrated with your school management system, information is always kept up to date meaning no import / export and data duplication.


Since the education sector presents such a huge opportunity for SharePoint/Office 365, I have often wondered if there are other offerings from Microsoft which integrate more cleanly into Office 365 …… and then I read this tweet: https://twitter.com/bevanstratton/status/401050557906825216

Which piqued my interest and I started to research on “SharePoint 2013 for Education”. This led me to the following links:

So for the moment (Nov/2013), it appears that SharePoint 2013 for Education was pulled out of the GA of SharePoint 2013 after the RTM release had it.

From the internet chatter, there is hope that Microsoft may rebrand this at some point in the future (but I would not hold my breadth). I will reach out to my contacts to see if I can glean any more information. Stay posted!

Sep 12, 2013

Installing a Full SharePoint 2013 Load Balanced Lab



As an MCT and SharePoint Architect, I find myself creating a lot of SharePoint labs over the years and then prepping the labs

with exercises for my students or clients. In addition to that, I have to do the same for my continual studies on the

SharePoint platform and found that I waste a lot of time performing repetitive tasks.


Anyone familiar with SharePoint will know that once something goes wrong in an install, it is often a time consuming task to

find the cause of the issue to fix it. Something I do not want to do only days before I have to deliver a presentation or a class.


So I decided to document the creation of a small N-tier environment of an N-tier SharePoint farm. The rest of the article

illustrates how I went about doing this.


Getting Started

Installing and Configuring Hyper-V

Sep 9, 2013

Restoring Database


  • Create a database maintenance plan
  • Click on Manage connections and enter connection information for the source and target databases
  • From the toolbox, add a “Execute T-SQL Statement Task” and name it “Backup PROD”
  • Double click on it, set its connection to the source database and enter the following SQL:

BACKUP DATABASE <Database Name> TO DISK='\\server\Backup\<Database Name>.bak' WITH NOFORMAT, INIT

  • From the toolbox, add another “Execute T-SQL Statement Task” and name it “Kill Active Connections on Staging”
  • Double click on it, set its connection to the destination database and enter the following SQL:

alter database <Destination Database>
set offline with rollback immediate
alter database <Destination Database>
set online

  • From the toolbox, add another “Execute T-SQL Statement Task” and name it “Restore Staging”
  • Double click on it, set its connection to the destination database and enter the following SQL:

RESTORE DATABASE <Destination Database> FROM DISK=’\\server\Backup\<Database Name>.bak' WITH REPLACE

  • Connect the success arrows of the tasks in the order added
  • Optionally, connect the error arrows to a “Notify Operator Task”
  • Go to the SQL Server Agent, expand the Jobs folder and set a schedule for your maintenance plan


Aug 19, 2013

Adding TypeScript Support to MVC4 Project

  1. Unload your project
  2. Edit your project
  3. Add the following markup:

    <!-- To support TypeScript -->
    <Target Name="TypeScriptCompile" BeforeTargets="Build">
      <Message Text="Compiling TypeScript files" />
      <Exec Command="&quot;$(PROGRAMFILES)\Microsoft SDKs\TypeScript\tsc&quot; -target ES5 @(TypeScriptCompile ->'&quot;%(fullpath)&quot;', ' ')" />
    <!-- End TypeScript support -->

  4. Reload and compile project
  5. If you show hidden files, you should see a JS file for your TS file

Jun 25, 2013

Enabling SharePoint Hosted Apps


Adding this little post to save me wasted hours in the future.

In order to publish a SharePoint hosted app to a site collection the site must be based on the developer site template or have the “Developer” Feature enabled on it.  The “Developer” Feature is marked as hidden in its definition so you must use PowerShell to enable the Feature. 

Enable-SPFeature e374875e-06b6-11e0-b0fa-57f5dfd72085 –url http://sp.contoso.com

Jun 24, 2013

Debugging Memory Leaks in ASP.Net

I followed the diagnosis steps for identifying the memory leak from here and modified it a little bit to come up with the following steps:

Jun 6, 2013

Starting With SharePoint 2013

Here is a list of resources to look at when starting to look into SharePoint 2013 design and development. Also listing certification goals and resoruces to help achieving it.