Category Archives: 2010

Free SharePoint 2010 Foundation add-ons everyone should have

a-motor-cycle-with-a-side-car-machine-gun

We have several customers who use SharePoint 2010 Foundation and are constantly trying to get the most out of the product, envious of what SharePoint standard and enterprise can do, frustrated by Foundations limitations but liking its price tag.

I’ve compiled a list of useful add-on’s here but I’ll come back and keep adding to it as we find more that are note worthy.

Continue reading Free SharePoint 2010 Foundation add-ons everyone should have

Hide SharePoint calculated columns from display form with PowerShell

HidingWhile creating a column which hyperlinked through to another list I’d created a few calculated columns which were showing up in the display form of items.

You can’t hide calculated columns in the same way as with regular columns, some of these pains are mentioned in the reference sites.

Below is the PowerShell I used in the SharePoint 2010 Management Shell to hide them.

I’ve commented out two options since they are quite useful to retain in most circumstances.

Continue reading Hide SharePoint calculated columns from display form with PowerShell

Mount-SPContentDatabase and Test-SPContentDatabase fail with either Invalid object name ‘Sites’ or ‘Webs’

homer-doh

While trying to restore some SharePoint 2010 “content” databases I kept on getting errors about invalid objects… Found some links talking about incorrect SharePoint versions but as it turned out that all it was because the databases were service application database backups with slightly ambiguous names, not content databases.

Continue reading Mount-SPContentDatabase and Test-SPContentDatabase fail with either Invalid object name ‘Sites’ or ‘Webs’

Create Search Server Express 2010 slipstream installation media

lK975

While reinstalling Search Server Express 2010 for a customer I found there wasn’t a hughe amount of help out there for how to slipstream Search Server Express 2010. The process isn’t really different to SharePoint Server 2010 Standard or Enterprise but does vary a little to Foundation.

Here is a little guidance on how to create slipstreamed installation media for Search Server Express 2010.

Continue reading Create Search Server Express 2010 slipstream installation media

QR Codes in a SharePoint List

Bridge-to-the-futureConnecting the physical and digital world with SharePoint 2010 and QR codes.

 

I’m on-site in Vietnam with a customer who is starting their SharePoint journey as well the wider journey to becoming a data driven business.  We’ve been running through business and technical discovery sessions for over a week now and something came out of one of the meetings which was begging to have SharePoint step in and save the day.

The business problem

In this furniture design and manufacturing company, the product development team produce CAD drawing of parts and assembled components which then get issued to the production team.  These hardcopy drawings are used to build the components to specification.

What happens from time to time is a breakdown in communication where a drawing gets revised, but the production team don’t get informed quickly enough and items continue to get made from out of date drawings wasting time, money and therefore profit.

Continue reading QR Codes in a SharePoint List

Edition downgrade for SharePoint Search Server Express 2010 from SQL 2008 R2 Enterprise to SQL 2012 Express

DowngradeThis is just a quick post to highlight issues with two SharePoint Search Server Express 2010 databases when downgrading from SQL 2008 R2 Enterprise to SQL 2012 Express (although applies to any Express version, 2008 R2 or higher).

The customer needed to swap out an Enterprise trial version of SQL and replace it with Express since the investment for Enterprise wasn’t forthcoming and neither was the investment for further immediate work in SharePoint.

They were however getting great value from Search within Search Server Express 2010 so didn’t want that to go anywhere, it was the entire companies home page!

Continue reading Edition downgrade for SharePoint Search Server Express 2010 from SQL 2008 R2 Enterprise to SQL 2012 Express