SQL, NoSQL, SomeSQL - A look at non-relational databases

Some people are attempting to unseat the dominance of teh SQL RDBMS.  What are the NoSql databases?  Are they a threat?  Do they actually work?  What do they look like?  This session contains some answers and offers a context for where non relational databases fit into the picture.