Archive for the ‘On the web’ Category

Fluent NHibernate project

Some folks on the nh-users list (led by James Gregory) have moved Jeremy Miller's Fluent NHibernate project to Google Code.
There's a lot of work to do, but we have a list going.  Should be an interesting project to watch (and to contribute)!

Delicious Stats

del.icio.us/mhinze
posts per month
select
dateadd(month, datediff(month, 0, [Time]),0)
, count(*)
from posts
group by dateadd(month, datediff(month, 0, [Time]),0)
order by dateadd(month, datediff(month, 0, [Time]),0) asc

domains all time
select top 10
count(*) as [Count],
dbo.RegexGroup([Href], N'http(|s)?://(?<domain>([\w-]+\.)*[\w-]+)', N'domain') as [Domain]
from [posts]
group by dbo.RegexGroup( [Href], N'http(|s)?://(?<domain>([\w-]+\.)*[\w-]+)', N'domain')
order by count(*) desc

206    blogs.msdn.com138    [...]