What are the differences between Mongodb versus Sql Server? It seems Mongodb is in between a nosql database and a relational database. Reference: [url=http://www.mongodb.org/]http://www.mongodb.org/[/url]

There seems to be allot of buzz around these nosql databases. Other than the fact that they don't support regular SQL like syntax, what is the real underlying difference? Can you model "most" databases into a nosql type data m ...