Wednesday 1 June 2011

service create example

sc create "DataVisionOracle" binPath= "F:\Applications\EnterpriseVision\DataVisionOracle\WindowsServices.DataVisionOracle.exe" DisplayName= "DataVisionOracle" obj= cmaprod\releaseuser password= rel34$u$er start= auto

Monday 16 May 2011

Using SQL/CLR integration

Here is a good example of how you can use .Net language and integrate it into SQL.

e.g. run a piece of c sharp code in a stored procedure


SQL CLR Stored Procedure using Visual Studio 2010

Planning Poker

Being Aglie (SCRUM) for a few months now.

Here is a good article showing how a team can decide the effort of a sprint item. I think it's cool!



Planning Poker in Detail

Index on uuid when using NHibernate

Guid is a simple and easy solution for generate random ids.
However, when a table is using uuid as the key, it's not so simple to index base on ids.

Here is a good blog showing how you can create your own id generator that taking advantage of the uuid and give you a result id that can be indexed.



Using guid id in nhibernate, index fragmentation

Friday 18 February 2011

Static fields...

It took me almost 1 day to fix a very stupid problem:

My program is working on my machine while it doesn't work on my friend's machine and other remote desktops.
I added try n catch, extra logging, nothing works.


The system always dies straight away and ask me to report to MS. I even tried to comment out everything in my main method....

after nearly 1 day of investigation, it turns out that one of my reference is not "copy to local" !!! and this thing is a static variable which is initilized before the main!!!