we’re indeed heavily invested in stored procs - not to mention a few enterprise edition features of MSSQL - in particular table partitions for swapping out entire blocks of data for deletes.
Dev Teams are and have been using other database tech for their features for some years now however, so we’re far from ONLY using MS SQL.
There’s at least CosmosDB/PostGres and a few other cloud based managed DB services being used.
Horses for courses and such