Thursday, 20 November 2008

Why "ItemUpdated" fires 2 times ?

Problem:
I have a document library with an "ItemUpdated" item eventreceiver. Each time I upload a document, the eventreceiver fired 2 times in two different threads, with update conflicts as a concequens.

Cause:
When you use check-in/check-out on your document libraries the check-in action also fires an ItemUpdated event. If found this information here (good article!):

Solution:
We need to check which "ItemUpdated" we deal with ... the one from the check-in or the 'real' one. If found this code on the MS site to check the source of the event:

if (properties.AfterProperties["vti_sourcecontrolcheckedoutby"] == null && properties.BeforeProperties["vti_sourcecontrolcheckedoutby"] != null)
{
//This is when the update event is triggered by
check-in.
}
else
{
//This is triggered by events other than check-in
action.
}

Source: http://support.microsoft.com/kb/939307/en-us

Wednesday, 12 November 2008

Moss 2007 Database Migration - Diskspace Usage and Upgrade time

I'm currently working on a database migration SharePoint 2003 to Moss 2007.  One of my concerns was the diskspace usage during the migration.

In a previous post i wrote that a gradual upgrade can take up to  6,19 times the original diskspace.  So i had reasons to worry ...

I can tell you, a database migration takes less space, here are my test results:

DISKSPACE USAGE

Content Database 1 (+/- 12 GB)

  Before Migration After DB Migration
DATA File 11.706.624 kb 11.706.624 kb
LOG File 20.096 kb 1.219.712 kb

Logfile growth / data file = 10,42 %

Content Database 2 (+/- 58 GB)

  Before Migration After DB Migration
DATA File 58.035.584 kb 58.035.584 kb
LOG File 20.096 kb 9.930.624 kb

Logfile growth / data file = 17,11 %

Content Database 3 (+/- 18 GB)

  Before Migration After DB Migration
DATA File 17.139.776 kb 17.139.776 kb
LOG File 26.816 kb 1.321.088 kb

Logfile growth / data file = 7,71 %

UPGRADE TIME

The upgrade time of the DB migration depends on the hardware AND the features you want to activate during the migration.  I did a test activating the publishing features during the upgrade.

Database 1 - without publishing features : 15 minutes
Database 1 - with publishing features : 1 hour 40 minutes

Database 2 - without publishing features : not tested
Database 2 - with publishing features : 1 hour 53 minutes

Database 3 - without publishing features : 12 minutes
Database 3 - with publishing features : 51 minutes

CONCLUSIONS

  • The DATA file does not grow
  • The LOG file grows between 7% and 20% of the datafile
  • The upgrade time of the migration is short but depends on the features you want to activate during the upgrade.

Visual Studio 2010 Tools for SharePoint

A summary of what we can expect:

  • Server Explorer for SharePoint viewing Lists and other artifacts in SharePoint directly inside of Visual Studio

  • Windows SharePoint Services Project (WSP file) Import to create a new solution

  • Added a new web part project item and showed the Visual web part designer which loads a user control as a web part for SharePoint

  • Showed adding an event receiver for SharePoint and using the wizard to choose the event receiver and to just create a source file with that event receiver.

  • Added an ASPX workflow initiation form to a workflow project and showed how this workflow initiation form has designer capability

  • Showed the packaging explorer and the packaging editor which lets you structure the SharePoint features and WSP file that is created

Source:
http://blogs.msdn.com/pandrew/archive/2008/11/10/visual-studio-2010-tools-for-sharepoint-announced-at-teched-emea-developers-2008.aspx

Sunday, 5 October 2008

Looking for some samples on Moss 2007 WCM ?

Here you can find about 100 websites build on SharePoint 2007 WCM: 

http://www.wssdemo.com/Pages/topwebsites.aspx

Sunday, 28 September 2008

Can you run Moss 2007 on .Net Framework 3.5 ?

Microsoft says YES !  So you can use the latest features in your SharePoint Applications.image

Source: http://technet.microsoft.com/en-us/library/cc288751.aspx

Resources for installing Moss 2007 on Windows Server 2008

I'm currently setting up some virtual development machines based on Windows Server 2008.  Before I started I collected some resources on the net.

One importing thing, use always the installation files with Service Pack 1 included otherwise your installation will fail.

Installing Moss 2007 on Windows Server 2008:

SQL Server 2008 deployment on Windows Server 2008 by Dell
http://www.dell.com/downloads/global/solutions/public/white_papers/sql2008_ws2008.pdf

Deploy a simple farm on the Windows Server 2008 operating system (Windows SharePoint Services)
http://technet.microsoft.com/en-us/library/cc287748.aspx

Install a stand-alone server on Windows Server 2008 (Windows SharePoint Services)
http://technet.microsoft.com/en-us/library/cc287813.aspx

Upgrading to Windows Server 2008 for Windows SharePoint Services 3.0 with SP1
http://technet.microsoft.com/en-us/library/cc288690.aspx

Perform a stand-alone installation of Office SharePoint Server 2007 on Windows Server 2008
http://technet.microsoft.com/nl-be/library/cc262177(en-us).aspx

Deploy a simple farm on the Windows Server 2008 operating system (Office SharePoint Server)
http://technet.microsoft.com/nl-be/library/cc263408(en-us).aspx

If you are using SQL Server 2005 for your installation:

FIX: SQL Server 2005 is not installed on a Windows Web Server 2008-based system
http://support.microsoft.com/kb/950636

How to install and how to configure SQL Server 2005 Reporting Services on a computer that is running Windows Server 2008
http://support.microsoft.com/kb/938245/

SharePoint Infrastructure Update

Some months ago I blogged about MS Search Server 2008 and the Federated Search.  Some weeks ago (finally) Microsoft released the update that adds the federated search functionality for the Moss 2007 users.  I made a summary of the links for easy downloading:

Key updates for SharePoint Server 2007 include:

  • New Search features such as federated search and a unified search administration dashboard.
  • Several core fixes to Search to improve performance and scale.
  • Platform performance improvements and fixes.
  • Several core fixes to the publishing Content Deployment features to improve reliability.

Key updates for Windows SharePoint Services 3.0 include:

  • Platform performance improvements and fixes.
  • Several backup and restore fixes.
  • Several core Workflow fixes.