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