Deploying outlook 2007 VBA code using group policy with digital signature

1, write the code;
2, generate code signing certificate using enterprise CA;
3, Sign the macro code with certificate;
4, copy VBAProject.otm and the certificate to netlogin folder;
5, create GPO, link a logon script to copy vbaproject.otm to user profile and create a certificate rule to publish the certificate

Customizing MySite in MOSS and adding report viewer web part

The following two articles are definitely quite valuable information if you want to customize my site under moss/sharepoint 3.0:
https://blogs.msdn.com/sridhara/archive/2007/05/19/customizing-mysite-in-moss-2007.aspx
http://blogs.msdn.com/sharepoint/archive/2007/03/22/customizing-moss-2007-my-sites-within-the-enterprise.aspx

Qhile following these instructions and added sql server 2000 report viewer web part, extra problems arose: while we can assign reportmanagerurl and reportpath to the report view web part, assigning string values to toolbarsize property and height/width property won't work. After examining rswebpart.dll file by using 'Reflector', it is clear that the web part won't accept string as input for toolbarsize property, instead it will only accept a typed variable.
Here is the solution(use the second link above as example):
under 'mysitecreatepart' project, add a reference to rswebpart.dll,
and add the following line on the top of partcheck.cs file:
using Microsoft.ReportingServices.SharePoint.UI.WebParts;
inside partcheck.cs's SetWebPartProperties method, add the following code into appropriate position:

// NOTE: Hack to get around the 'ambiguous match' error
// for the Height property.
if (String.Compare("Height",
wpa.Properties.Property[p].Key, true) == 0)
{
xWp.Height = wpa.Properties.Property[p].Value;
continue;
} //end height hack

//hack to setup toolbarsize property
if (String.Compare("ViewerToolbarSize",
wpa.Properties.Property[p].Key, true) == 0)
{
//I only need to get rid of toolbar thus use a static value here... xWp.GetType().GetProperty(wpa.Properties.Property[p].Key).SetValue(xWp,
SPViewer.ToolbarSize.None, null);
continue;
} //end toolbarsize hack

ASP.NET MVC, ORM etc

I learned JAVA EE programming a while ago and did some minor projects, unfortunately there is no real world chance to practise it and those little knowledge I learned at that time has been nearly thrown alway totally!
Anyway, at these days I occassionally write some code using asp.net/c#, although it is quite easy to write a 'dirty' program using asp.net, It is definitely not a good practise. I have been trying to figure out the way to write a true multi-tier program using asp.net and came to a few discovery. Interesting, Hibernate got an asp.net version which is called NHibernate...However, I guess I might go for LINQ for ORM, however for MVC structure I only found a 'MVC framework CTP' stuff which is apparently not quite mature yet...

Also the following article has some discussion and comparison which could be useful:
ASP.NET MVC: Choosing Your Data Access Method

E4SE date shown in US format in regardless of locale setting

This is one of the strange things encountered while maintaining the E4SE application, sometimes when you change iis settings, it might overwrite the .js mapping created by ICE tools, after recreating the .js to aspnet mapping, it is back to normal.

Fixing up Intra-site replication error

I wasn't able to connect to one of the server and after looking into it, it turned out to be DNS issue which is in turn caused by AD replication failure...
coz our whole environment was built upon VMWARE, I noticed that VCB backup can freeze DC and make it fail.
the way to fix this up is to manually restart KDC service. re-enable inbound and outbound replication on the failed DC.
the following command might be helpful:

dcdiag
netdiag
replmon
repadmin

repadmin /options DC1 -DISA.....
repadmin /synall
repadmin /showreps
...

MCSE 2003 done!

Finally finished my MCSE 2003 certification.
will take MCDBA exams in the following months.

Upload a File to a SharePoint Document Library

I developed a document management system a while ago, however it can only handle the records of documents and those records are not directly linked to electronic documents which makes it far from optimistic.
By combining the system with sharepoint document library, the system can be used more regularly and reduce work load. i.e. create the document records and save a copy of documents under sharepoint document library, it can also be used to send transmittal electronically.
Thanks for the author of the following article:
http://geek.hubkey.com/2007/10/upload-file-to-sharepoint-document.html
I have been testing the solution and it seems to be working pretty well...