That article misses the #1 reason to use stored procedures - putting the code right by the data can be a massive performance boost. Like, orders of magnitude faster than travelling over the network.