Thursday, 27 September 2007

Regular Expressions a bind - not anymore :) - Expresso

This great little tool found a while back saves a lot of hassle :)

Expresso by Ultrapico

Thursday, 13 September 2007

Long Text Fields in NHibernate

Beware if you do not include type="StringClob" on a large text field in the nhibernate mapping it will automatically chop to around 2000 characters - this is because it defaults the size when creating the parameter. You can avoid this by using the above :)

Tuesday, 4 September 2007

Useful system views on sql server - there are loads but here are the useful ones

all abbreviated sys.*

sys.sql_logins Lists all users who can access the database.
sys.columns Lists all columns on database
sys.tables Lists all tables on database
sys.assemblies Lists all assemblies on database
sys.foreign_keys Lists all foreign keys on database
sys.triggers Lists all triggers on database
sys.procedures Lists all procedures on database