Monday 26 January 2009
SharePoint Certification Resources
Posted by Unknown at 10:56
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
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.
Posted by Unknown at 09:53
Wednesday 14 January 2009
Some Quick AdHoc Reporting on SharePoint
The following site lists a number of queries for quick performance / growth / usage reports
Posted by Unknown at 12:19
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.
http://blogs.msdn.com/sharepoint/archive/2007/05/20/may-2007-content-on-msdn-for-wss-3-0-and-moss-2007.aspx
Posted by Unknown at 12:15