SharePoint Certification Resources

Sample questions:

http://qmoss.blogspot.com/

http://sharepointtests.blogspot.com/

For exam 70-630 (Configuring MOSS 2007) - http://drop.io/70630Qs

For exam 70-631 (Configuring WSS v3) - http://drop.io/70631Qs

http://www.sharepointforum.com/en-US/Blog/archive/2007/11/20/the-sharepoint-2007-exams-tips.aspx

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

DTS.Events.FireInformation
DTS.Events.FireBreakPointHit
DTS.Events.FireCustomEvent
DTS.Events.FireError
DTS.Events.FireProgress
DTS.Events.FireQueryCancel
DTS.Events.FireWarning

OR

Me.ComponentMetaData.Fire<...>

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

Some Quick AdHoc Reporting on SharePoint

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

http://blogs.technet.com/corybu/archive/2007/06/01/sharepoint-reporting-methods.aspx

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.

http://blogs.msdn.com/sharepoint/archive/2007/05/20/may-2007-content-on-msdn-for-wss-3-0-and-moss-2007.aspx