title: using nosql database as a replacement for sql server
body: <p>I'm developing website that (if successful) its going to have a rapidly growing database (maybe terabytes or more). up to now I have always used sql server and didn't know anything about nosql.
  I just found out about nosql doing research about the database size, and now I'm not sure if it will fullfil my needs. will I have the same power that I had with sql-server?</p>
  
  <p>my question may seem silly as I'm a newbie in nosql but I just wanted to know if it doesn't support sql queries. how can we do something like:</p>
  
  <pre><code>select *, (select name from cities where id = cityid) from users
  </code></pre>
  
  <p>how to join tables? use something like stored procedures, views or things like these? </p>