All the developers are on both SQL and .Net, so we will not have those kind of problems.

Most of my concerns are regarding keeping everything in one place, and as clean as possible.

So, at the moment, I can say I'm confused 🙂 I am aware of the speed gained by keeping everything in optimized stored procedures, but in the same time, I would like to maintain flexibility to make changes in BL faster, and with less modifications.