It seems to be the only .NET-related NoSQL DB that I ever hear very much about.

This post is by the creator, Ayende Rahien. Great guy, really smart.