I have been a full stack dev for a while as well. Some time ago, I lead a project based on C#/ASP.net/SQL server. The SQL server instance would lock up/use 100% CPU for days every other week, even after restarting and with no load. That, along with many other problems with the tech stack made me say "never again".

So yeah, there are web applications based on SQL server out there, despite my efforts to prevent it.