Optimising SQL Server for SharePoint

A great article to improve your SharePoint environment by using your SQL Server. Click here to view the full article.


Tagged , , , ,

SharePoint 2013 CU changes

Hi all,

Microsoft have changed the way that Cumulative Updates are distrubuted and applied to your SharePoint environment. To read in detail click the link below:

SharePoint 2013 CU Changes


Tagged , , , ,

SharePoint Admin URLs

A great reference to SharePoint Admin URLs which can come in handy when you don’t always have access due to customisation on a SharePoint farm.

Tagged , , , ,

My Role as Data Migration Lead – SharePoint 2013


As part of any large ITO deal within a large IT organisation you are sucked into accounts on a particular role to fulfil a particular contractual obligation. I spend the best part of a year on such an account. My role was the Data Migration Lead for one of the largest implementations of a SharePoint 2013 farm in the UK. The SharePoint farm is to be used by 140,000 people across the UK and has over 40 servers! My role was to facilitate the migration of existing solutions to SharePoint 2013 (On-premise).

Problem Scenario

A large public sector organisation within the UK government currently have a number of internal online solutions which provide various facilities such as team collaboration, blogs, wikis, document storage and a managed publishing intranet site. Each solution uses a different tool to provide said service. For example team collaboration uses Documentum eRooms. The managed publishing site uses Oracle Stellent & Publishing Server. The majority (all except the intranet solution) have been implemented as pilots which have turned into production systems without any proper testing or capacity planning. This has been due to the lack of business focus on a particular solution and new tools being introduced over a span of 10 years. To remedy this, a project to combine these existing web based services to a new platform – SharePoint 2013 (On premise) is being undertaken. As part of the new solution there is a great desire for one platform for all ‘web based’ services and to migrate any data from the existing tools.

My Initial Thoughts

I have never been involved in a migration of this scale. I thought I have a solid understanding of SharePoint, I have the capacity to analyse existing solutions and I understood what the end result needs to be. So how difficult could it be? Very it turns out!

To summarise I had to:

  • Migrate all existing web services to SharePoint 2013
    • Provide a Collaboration service (Team Sites, My Sites, Blogs & Wikis, Self-service creation etc…) with existing data
    • Provide a Publishing Intranet site with current content
    • Influence the design of the SharePoint 2013 based on current solutions

My Approach

My first task was to develop a migration strategy. This was a plan of attack. How would we migrate each solution in its current form to SharePoint 2013. First things first, I googled ‘data migration strategy’. The results came up with a number of slides and articles with useful pieces of information which got me thinking. From all this information I came up with three very high level steps. The first step is to understand the ‘as is’. The second the ‘to be’. The third to map the two.

  1. The ‘as is’ is the current solutions. It was to understand and gather system information, usage stats, any customisations, understanding if the current solution maps to SharePoint OOTB functionality, any bespoke features are required.
  2. The ‘to be’ would be a little more difficult in this scenario as it was yet to be decided at this point. But this gave me the opportunity to work with the development teams and SharePoint leads to help shape the solution to match the requirements of the data migration based on the clients’ needs.
  3. So matching the ‘as is’ and ‘to be’ would require some magic or a third party tool? Magic wasn’t really my thing so I opted for a third party tool. So I looked at some of the market leaders such as AvePoint & MetaLogix. Both provided very similar functionality for a similar sort of price. They enabled the existing solutions to be migrated to SharePoint 2013.

So with these three key steps identified, I decided to delve a little deeper into what is required. I formalised my approach into three phases:

  • Analysis – This phase was designed to understand the ‘as is’ and help define the ‘to be’. It was set out provide guidance policies and understanding the current Information Architecture and how that would be translated on the SharePoint 2013 platform.
  • Approach – This phase was to plan and understand pre and post activities in detail. This included the selection of a third party tool, a success matrix, mapping documents and implementation plans (delivery, roll back communications)
  • Delivery – This phase was to implement the plan outlined and measure the success.


Great! We are nearly there, or so it would seem….

So I had a strategy and it was agreed by all parties. Then came the analysis and workshops to understand the finer details. This is a time consuming process as business stakeholders and end users have day jobs and need to be available to help you to understand the ‘as is’ solutions. Getting agreement from the business on which data sources are to be migrated is a must. The owners, administrators and users of the existing solutions provide an insight into:

  1. How these tools are currently used?
  2. How they can be improved?
  3. What their priorities were?

After understanding the ‘as is’ it was time to create the relevant documentation to enable the delivery of the migration. This involved the implementation plans, success matrix, communication plans, roll back plans etc. As we opted to use a third party tool to aid in the migration, a procurement process was instigated to ensure the correct tool was selected based on fair and measurable criteria. As these items progressed the business needed to agree and cleanse the data they had created over the past 10 years. This, as you can imagine was a laborious task which still being undertaken today! This approach has been a great way to structure a migration which focuses on business needs and provides solutions to existing pain points. It provided a solid foundation to adapt when required during the process and provided a road map for the team implementing the migration.

Its high level approach was intentional as it needed to provide flexibility to allow for a variety of data sources. It did take into account that the destination: SharePoint 2013.

To Summarise

Below I have highlighted some key points to consider when undertaking a data migration to any SharePoint farm:

  • If you have more than one data source in the ‘as is’ – verify if all are required by the business
  • Consider cleansing your data in the ‘as is’ before migrating
  • Understand the ‘as is’ solutions and how they currently function in detail
  • Understand your SharePoint implementation – which services are enabled, features, edition etc…
  • Look at it from all points of view – SharePoint Roles, End Users, and Business Stakeholders etc.
  • Priorities – Understand which ‘as is’ solution has the biggest impact on the business and which will provide a quick win
  • Agree a scope of work – what is to be migrated exactly, number of versions, any functionality etc.
  • If you are using a third party tool, ensure you have the right tool for the job. Test it. Make sure it can do what you need.
  • Ensure you have a roll back plan – just in case J
  • Ensure you communicate with the business when and how these changes will affect them
  • Measure the success of the migration by using a success matrix – use the end users to quantify the success.

Hopefully my experience with this process has been useful to you. If you have any questions or comments please feel free to get in touch… Happy migrating!


Tagged , , , , , , , , , ,

Some handy tips to rejuvenate a intranet

Many intranet projects start with the best of intentions. It doesn’t take much to get distracted or sidelined with other priorities. To get back on track with your intranet here are my top 5 points from a list of 27 to consider for user adoption.

1. Acronym Wiki – Ensuring that everyone understands the lingo!
2. FAQs – Providing a facility to showcase a repository of commonly asked questions.
3. New hire announcements – Great for small organisations to know who is coming into the company.
4. SharePoint solution showcase – a great opportunity to show how SharePoint can provide business solutions which can be utilised by the organisation.
5. Top Searches – Providing an insight into what people in the organisation are looking for on their intranet.

Many thanks to Richard Harbridge.

Tagged , ,

SharePoint Resources by Rackspace

Here is a link to a SharePoint resource centre created by Rackspace. It has got some great tutorials by MVPs and other useful tid bits, enjoy!

Click here.

Tagged , ,

Breaking SharePoint …

A nice little article on the cause and solution to a few common SharePoint errors. Click here for the full article.

Tagged ,

SPCAF public release 1

SPCAF – SharePoint Code Analysis Framework, is in its first public release. It provides a number of options to analyse code against best practices from a number of perspectives and roles (Admins, developers, architects and quality managers) within a SharePoint environment. Here’s some more detail on the release.

Tagged , , ,

What is the product catalog in SharePoint 2013?

The Product Catalog is essentially a site collection template which allows a search based publishing site to be find content across sites on a farm. It also provides the separation between publishing and authoring environments with in a SharePoint farm.

Benjamin Niaulin from Sharegate explains in some detail what the product catalog is and what it can be used for here.

Tagged , , , ,

SharePoint 2013 Support for Windows Server 2012 R2

Bill Baer (Senior Product Marketing Manager – SharePoint) @ Microsoft has mentioned on his Blog that SharePoint 2013 isn’t compatible with Windows Server 2012 R2 currently. Work is in progress to remedy this in the form of the first service pack for SharePoint 2013, but there is no date for this yet. For the latest information check on Bill’s Blog here.

Tagged , , , ,