Monday, 26 January 2009

SharePoint Certification Resources

Sample questions:

For exam 70-630 (Configuring MOSS 2007) -

For exam 70-631 (Configuring WSS v3) -

Monday, 19 January 2009

Debugging SQL Server Integration Services Scripts

Debugging SSIS scripts is not the easiest of all things. Below we propose a number of ways to debug which we've seen in a presentation by Alan Mitchell - SQL Server MVP.

1. MsgBox messages - good during development, but not any good for production environments since once the MsgBox pops up it WILL wait for user input before the task proceeds.
2. Fire Events - the Progress / Output windows can also be used to ouput your debugging information.

Imports Microsoft.SQLServer.DTS.RunTime




3. Using Windows tracing events - System.Diagnostics.Trace.WriteLine, and then use a program such as Sysinternals DebugView to watch for this information.

Wednesday, 14 January 2009

Some Quick AdHoc Reporting on SharePoint

The following site lists a number of queries for quick performance / growth / usage reports

Tuesday, 13 January 2009

Several Interesting articles on MSDN re SharePoint customizations

Hadn't come across them yet, however found this wealth of information when trying to enable audting on WSS.