Is SQL dead? Would you choose it over NoSQL, today?

with so many anti-sql blogs over the internet, am wondering if people are still using it as popularly as it was or has the dynamic shifted to noSQL