Development Procedures

Hello,

Recently my partner in crime (so to speak) and I have been asked to develop procedures and/or methods for our software development group. Currently we're running SQL Server 8 with several Access apps and Crystal Reports. In a nutshell, I'm looking for resources.

We're supposed to develop a process (we're both DBA's) where our development team can formally submit new stored procedures, views, or whatever they've come up with to solve for buisiness requirements. It'll be our job to take thier scripts and execute them on the production database after ensuring someone has tested the logic and signed-off on it.

Unfortunately, I have been charged with developing this process (ie: development, sign-off, testing, etc..). Currently we have no procedures in place; until now my partner and I have been the primary deveopers (this is about to change). Are there any resources out there that could help me develop a formal process for our soon-comming developers?

Thanks,

Jason

Jason -

You can check out InformIT.com - they have lots of information there on a "professional" nature, not just technical info. I do the SQL Server "Guide", and I've got an article or two that might be useful.

Most of the Software Development articles will point towards a particular methodology or tool. I've found that most shops develop their own methods and call it an "SDLC" or Software Development Life Cycle. Also check out a book called "Code Complete".

Buck