ASP.NET Web Site Setup

Today I try to setup a ASP.NET web site which was developed by a previous colleagues. After I have finished to prepare all the things (Setup in IIS, registery modification, etc..) according to the description in the setup document, I try to access the site but it reports error message of "failure to load XXX.DLL"

I modify register to enable "Fusion!EnableLog" and make sure the DLL has been stored in both of "\bin" of the web site and subdirectory of "Temparoary ASP.NET Files" but the problem is still there.

Finally I modify "security setting" of "Temporary ASP.NET Files" and allow "Internet Access Account" to access the folder. The problem is solved after I have added the access the folder. BTW, not certain whether it will cause security loophole or not.

Knowledge Management (R&D validation)

Today the company which I am working with talks about how to validate (or capitalize) the technical capability of the company. This cause me to remember what I have learned in the courses related to Knowledge Management in the past few years.

Based on what I learned, the following can be used to measure (capitalize) asset of a company:

1) Human Asset
This is related to how experience the staffs are, whether they are knowledgeable and stable or not.

2) IT Asset
This is related to IT infra-structrue of the company, how IT is used to improve efficiency of the company
(e.g. Bugs Tracking, Source Control, email system, IT for project management, etc)

3) Work procedure
This is related to whether there is proper procedure so that the staffs can re-utilize their knowledge to develop a new project (to keep the quality, to shorten the development period), to based on existing knowledge to create new knowledge, etc.

4) Social Asset
Related to relationship with existing and potential customer.

5) Patent
Number of patent the company have and how the patent can help the company to safeguide its business/product.

SQL2005 (Data Migration)

Today I try to setup a new SQL2005 server which will be used to replace the development server of SQL2008. Orginial I think I can simply detect the SQL2008 server and then use the "attach" method to utilize those database files from SQL2008 to SQL2005. However, the process fails due to reason of compatibility.

At the end I require to do the following for each database:

1) Generate script from the orginial SQL 2008 Server (include schema of Tables, SP, Views,etc)

2) Create database in the SQL2005 Server and then execute those scripts in Query Window of SSMS for those database

3) Use SSMS export function to copy records from SQL2008 to SQL2005.

However, while I try to do step 3 I get the below error message which cause me fail to do the data migration. Have try to change "regional setting" ot the two servers and also, change collation of the two SQL servers but still fail.

[...More than one code page (1252 and 936)...]

It is because the collation used in the orginial SQL2008 server is "SQL_Latin1_General_CP1_C1_AS" but the collation of the new SQL2005 server is "Chinese_PRC_C1_A1", the problem seems can't be solved by changing collation of those database of the SQL2008 server.

Finally I find that the solution is to change the collation of the new database of SQL2005 server to "SQL_Latin1_General_CP1_C1_AS" while the database is created.

Remove SQL2005 and Reporting Service

These few days I try to remove a previous installed SQL2005 (with reporting service) and then re-install a new instance of SQL2005 (with reporting service) again in the same server. Below are several items which needed to noted for proper installation:

1. Check "Services" by using features of "Administration", need to stop all services of "SQL XXX"

2. Use "Add/Remove" function to remove SQL2005 from the Server

3. Within IIS, delete those entries related to "Reporting Service" in the application pool

4. Check sub-directories of "C:\program Files\Microsft SQL Server", either rename or delete those directores related to "Reporting Service".

Can find more information from this URL: http://support.microsoft.com/kb/909967/en-us

T-SQL (string manipulation)

Below is example of using string manipulation function of T-SQL to mask off part of content of a string

SUBSTRING(ui.userid,1,4)+'XXXX'+SUBSTRING(ui.userid,len(ui.userid)-3,4) as userid

userid will become "123XXXX456"

SQL2005 setup

Today I try to install a new instance of SQL2005 server to a Windows2003 Server which is previous part of a cluster machine. (Previouly another instance of SQL2005 was installed to the server in a cluster configuration but no longer accessible).

It always display below error message which causes me failure to install a new instance:

SQL Server Setup was unable add user XXX/administrator to local group SQLServer2005SQLBrowserUser$YYY

Finally I find that the solution is to update login name of related SQL Services found in "Administration --> Services function" of Windows2003 Server. Right click the entry and change the login name from "XXX/administrator" to "YYY/administrator" where XXX is machine name of previous cluster machine and YYY is local machine name.