Many SharePoint 2007 articles discussing the customization of the Content Query Web Part assume access to the centralized style library. Users without this access can still customize the CQWP's XSL file by modifying the Web Part Definition file's ItemXslLink node.
I sat down to write a defense of stored procedures with specific regard to DAL/ORM solutions, but found myself painted into a corner. When it comes to generated code, many of the benefits of stored procedures start to crumble - or, at least, deny the luxury of automated approaches.