Look up Oracle sometime, and how entire enterprise applications get developed primarily in the database. Common with SQL Server and DB/2 as well.
Citing archaic and dead trends to someone who grew up profiting by their unnecessary complexity does you no favors.
The original question: Do you still use stored procedures. Yes, lots of people do, more common in big enterprise shops using Oracle et al. Not archaic, dead, or wrong, just another way to develop large software systems.