SharePoint 2013 in Las Vegas – What’s new for IT pro’s, SPC12

Me and two colleagues from The Triple A Company are visiting the SharePoint Conference in Las Vegas this week.

Besides a lot of community people and party’s the sessions are off course the main reason for us to be here. On the first day the key note kicked off the conference which was a great keynote.

On day one I decided to have a look at the “What’s new for IT pro’s” session to begin with. It turned out to be a great headsup on future changes and new stuff that is in SP2013.

My notes:

  • SP2013 cannot be installed on client systems.
  • 14 hive will exist within the (new)15 hive.
  • There will be a corporate catalog and general a market place.
  • New translation service, content as well!
    • Also on the client model.
  • Word documents can get translated live and real time…
  • There is a work management service for creating a task rollup. Exchange/SharePoint/Lync/project.
  • PowerPoint automation service, convert to pdf. Was allready available in SP2010.
  • Office web apps, seperate server, no service apps.
  • Improved urls, wac url. Web=1 parameter, to open in browser.
  • Web analytic is no service application any longer.
  • New analytics based on search.
  • Only delta’s are saved, not de complete version of a document. This is off course trivial for planning storage. Another topic that is related to this one is called “shredded storage” for SQL. This means that for instance powerpoint no longer will be saved as one big blob, but lets say that i have 10 slides, in 10 smaller blob parts.
  • Minimal download strategy.
  • No chrome refresh in pages. No page flicker.
  • License management on AD level, for WebParts and SharePoint farms. This will cut a lot of costs on SharePoint implementations..
  • PowerShell for SharePoint command builder, a new html page at Microsoft.
    That are my first notes of a session on monday, I will post some more this or next week. Cheers!

Filter The Content Query Web Part by file type and display file size.

Today I had to configure a Content Query WebPart to display the most recent modified documents and their file size. An easy task which I had quickly completed by reading two blogposts:

Filter CQWP by File Type:

  1. Insert a CQWP to a page and configure it as you would like.
  2. Export the web part and save it as “.webpart” file on your local computer.
  3. Open the “.webpart” file in a text editor. (I use SharePoint Designer)
  4. Look for the following line:
    <property name="CommonViewFields" type="string" />
  5. Replace it with the following line:
    <property name="CommonViewFields" type="string">DocIcon,Lookup</property>
    This will make the CQWP retrieve also the DocIcon field that basically include the file extention.
  6. Look for the following line:
    <property name="AdditionalFilterFields" type="Lookup" null="true" />
  7. Replace it with the following line:
    <property name="AdditionalFilterFields" type="Lookup" >DocIcon</property>
    This will make our CQWP to allow you to filter by our newly added DocIcon field through the filtering UI in the web part’s toolpane.
  8. Save the file.
  9. Go to a sharepoint page and import the modified “.webpart” file into your page.

CQWP Filter Before and After

Display File Size:

  1. Export the .webpart file for the content query you want to have the file size.
  2. Change the CommonViewFields property in the .webpart file to look like the following:
    <property name=”CommonViewFields” type=”string”>FileSizeDisplay,Computed;File_x0020_Size,Lookup;</property>
  3. Save the .webpart file
  4. Import the .webpart file and put it on a page
  5. Add the following to the end of the itemstyle.xsl:
    <!– The size attribute for each item is prepared here –>
    <xsl:template name=”DisplaySize”>
    <xsl:param name=”size” />
    <xsl:if test=’string-length(@FileSizeDisplay) &gt; 0′>
    <xsl:if test=”number(@FileSizeDisplay) &gt; 0″>
    <xsl:when test=”round(@FileSizeDisplay div 1024) &lt; 1″><xsl:value-of select=”@FileSizeDisplay” /> Bytes</xsl:when>
    <xsl:when test=”round(@FileSizeDisplay div (1024 *1024)) &lt; 1″><xsl:value-of select=”round(@FileSizeDisplay div 1024)” />KB</xsl:when>
    <xsl:otherwise><xsl:value-of select=”round(@FileSizeDisplay div (1024 * 1024))”/>MB</xsl:otherwise>
  6. Create a new style in the itemstyle.xsl and include the following where you want the file size to appear:
    <xsl:call-template name=”DisplaySize”>
    <xsl:with-param name=”size” select=”size” />
  7. Select the style you added the file size to in the properties of the CQWP.


All you need to know about SharePoint 2010, for end users and information workers

A good blog post about all the ins and outs of SharePoint 2010 for end users.

It will give you information about:

– Capabilities
– Clear explanation on terminology
– How to videos
– Resources
– Communities

You can find it here:

SharePoint in Plain English

Often we (SharePoint people) are asked to explain what SharePoint is, what people can do with it and perhaps most important, what SharePoint can do for people.

Well, there is a YouTube video that explains in plain English what SharePoint is and I don’t want to keep it from you.

The video:

SharePoint Server 2010 performance and capacity test results and recommendations

Microsoft has recently published some new whitepapers about the capacity impact of specific feature sets that are available in SharePoint Server 2010.

These white papers describe the performance and capacity impact of specific feature sets included in SharePoint Server 2010. These white papers include information about the performance and capacity characteristics of the feature and how it was tested by Microsoft, including:

  • Test farm characteristics
  • Test results
  • Recommendations
  • Troubleshooting performance and scalability

260 KB

236 KB

728 KB

Link to the original article on

Second day at the Best Practices SharePoint Conference #BPCUK

The first day was great, we attended some interesting sessions and had a lot fun in general.

The sessions I attended today:

– This is me, is that you? Identity management in SharePoint 2010. Rick Taylor IT106
– End User Adoption – the most hijacked SharePoint Term, what does it actually mean. Steve Smith IW407
– SharePoint Search 2010 Challenges Tricks and Tips. Matthew McDermott IT/DEV308
– Creating Sites,Site Definitions,Web Templates and custom code. Mirjam Van Olst – DEV209
– SharePoint Branding – From Beginning to End. Matthew Hughes COM610
– Achieving Return of Investment with SharePoint. Brad Smith IW411

Identity management

Rick Taylor’s session was a lot of fun as usual, it’s always a great experience to attend his sessions, it was about identity management, who are you, and how do you make yourself visible. He had some interesting tips about FIM, Forefront Identity Management Server. For instance, it installs a WSS 3.0 site for management purposes. That does not mix with a SharePoint 2010 WFE so you need to install it on a dedicated server.

Next session by Steve Smith, he talked about a hyped term, user adoption. Some keywords to make his vision clear to the audience.

Define end user adoption

End user adoption is:

– Unique for each company, never the same.
– Collaboration is key
– If the SharePoint environment is visited everyday
– If forms are available, company wide
– Not about tools but people, train them to use the new business tool, SharePoint.
– When process automation is in place. Don’t make it harder, make it easier.
– Social Networking can stimulate end user adoption.
– Targeted content, make it relevant for each user.
– A portal should always be intuitive, the ease of use should be high.


To make sure that end user adoption can be handled and supported in a good way some requirements should be met up front: Start with a vision, when did a company think of its long term vision, where will they be in 10 years? Then again, a lot can happen in 10 years, it might not be what you originally planned. Don’t link vision with technology, it doesn’t work! A vision should not be a general goal.

How to achieve end user adoption

– Who will be our customers, how will we work then
– Ensure everyone is onboard, Project/ business process experts, Information Architecture experts, Power users, Technical IT Pro’s / Development, CEO’s.
– Align user needs
– Identify business processes
– Train people that are in the team
– Define measurable and achievable milestones
– Make the model flexible enough for the future
– Pilot, feedback, re-test, deploy
– Tasks should make work easier, not more complex
– Take time for a project, between half a year / 1 year
– Make sure you analyze the use of sites and pages. Measured statistics will prove adoption short and long term objectives over time
– You cannot afford to switch your users off on day 1

SharePoint Search 2010 Challenges Tricks and Tips

Third session on Tuesday by Mathew McDermott. It was a fun and good session about SharePoint search tips and tricks. Here are some keywords I wrote down during this session:

– DFS for large file storage, distribute large files to geo locations. Location matters.
– Search indexes DFS and is presented to the user as if he sees results locally.
– Dfs root indexeren. Met server name mapping de interne url van de dfs vervangen voor de dfs url zoals bekend bij de user.
– In SharePoint 2010 link lists are indexed on a smart way, if a 404 is returned it will not be in the search index.
– Server name mapping is key if you want users to directly let users to go destination from search results instead of first going to the list.
– Create scopes for different types of information returned in search center.

  • Images
    • Include rules, contenttype = image/jpeg , contenttype = image/gif etc…


  • Excel
  • Word
    SharePoint 2010 fixes the result xsl if there is an error.

Prepopulate query suggestions lists with powershell to create a high useability from start.

Tip, a lot of good result xslt examples:

So far my notes on the second day of the SharePoint Best Practices Conference, the other sessions where interesting but not very new to me therefore I do not have to much to tell about it.. At then end of day K2 organized a very fun and good party in a club downtown london, getting up today was not the easiest part of this conference. 🙂


First day at the Best Practices SharePoint Conference #BPCUK

This year we had the chance to visit London with some colleagues to attend the European Best Practices SharePoint Conference 2011. Me and 4 other colleagues got the opportunity and decided to fly early to London so we could act like real tourists

The past two days we had a great time, enjoyed the perfect weather, had some pints and we actually sat in a tour bus and visited almost every touristic spot.

Today the conference started which means, time to get serious. These sessions I have attended today:

– Executive guide to SharePoint – Brad Smith – IW401
– The discipline of Findability – Bill English – IW402
– SharePoint 2010 ECM – Extending and Maximizing SharePoint ECM for your Enterprise –  Bob Bueltmann PAR104
– Incorporating metadata into SharePoint 2010 custom solutions – Andrew Connell DEV 204
– Best Practices for achieving Enterprise content management for the masses. – Ben Robb IW405

All sessions were interesting in one way or the other, tomorrow and Wednesday I will list all sessions I attend.

Now it’s time for the SharePint event!