IV CEUS

Tomorrow I will be at Madrid during the fourth SharePoint Users Spanish Conference (CEUS). I will talk about SharePoint functionalities and my colleagues Marc Bàguena and Pablo Peris will talk about web 2.0 with SharePoint and Workflows with SharePoint Designer.

During the morning there will be seven sessions presenting five case studies and two sessions about SUGES (Spanish SharePoint User Group) and FAST.

Here you can find more info about the event: http://www.microsoft.com/spain/office/ceus2008/agenda.htm

Enable usage statistics in SharePoint

Following the procedure described here you can enable the usage statistics in a MOSS site collection. Basically you need to enable logging in the farm, in the SSP and in the site collection. After the usage data is being collected you can view it from:

• Browser: Only the last month through Site Actions à Usage Summary.
  
• SharePoint Designer: Open your site with SPD and go to Site à Reports à Site Summary. More info: Use reports to measure site performance and usage
  
• Using the object model: Through the API you can collect the information and make your own statistics.
  

Remember that you can use any other system based on javascript to collect information about the site usage like Google Analytics or WebTrends

SharePoint Day at San Luis

The last week I was in San Luis talking about SharePoint. You can view all sessions in the next links:

SharePoint Overview (Spanish)

SharePoint integration (Spanish)

Excel Services & Search Server Express demo (Spanish)

 

Microsoft SharePoint Day at Madrid

The next September, 24th Raona and Microsoft organize the Microsoft SharePoint Day at Madrid. I will be in Argentina and I will not be in the sessions, but is a perfect opportunity to know us and our work.

This week I will be in Argentina talking about SharePoint

Raona will participate in the Innovation Summit at Buenos Aires, in the San Luis Digital and in the Microsoft SharePoint Day at Córdoba during the next week. We will see a complete SharePoint overview (by me) and 2 demos about PerformancePoint (by Laureano Remedi) and Search Server (by me againJ).

If someone comes to any of these events, feel free to contact me.

Agenda:

• 23/09/2008: Innovation Summit (Buenos Aires)
  
• 26/09/08: San Luis Digital (San Luis)
  
• 29/08/08: Microsoft SharePoint Day (Córdoba)
  

Related links:

Microsoft Innovation Summit

SharePoint Day (San Luis)

SharePoint Day (Córdoba)

Have you ever altered a SharePoint Database?

Well, if your answer is affirmative I recommend you this article: http://support.microsoft.com/kb/841057/en-us

Audit data in SharePoint and its impact in DB size

If you are using the SharePoint audit features you need to know which impact have in the size of your DB. A bad audit configuration may cause that the content and SSP database grow permanently.

In the case of a site collection with the audit enabled (http://office.microsoft.com/en-us/sharepointserver/HA100997261033.aspx) you will see the space used by auditing in the table AuditData in the content database. On the other hand, if you are using a BDC application definition and you have defined an entity make sure that in your entity definition sets the audit property properly (http://forums.msdn.microsoft.com/en-US/sharepointbdc/thread/ea208a3b-fd3b-4508-882e-466371c1a53c/).

But if you have enabled auditing for several months is possible that you need to free up space in your disk. In this case the only supported way is through API (very slow solution). For that reason I recommend that review the requirements of your SharePoint solutions and only enable the Sharepoint audit options that are required.

Update: In the Infrastructure Update there is a new stsadm command that allows to trim the logs: stsadm -o trimauditlog –enddate 20080704 –databasename WSSContent123456 (Thanks kezoe)