I'm curious to know what you would describe your approach to development (from a database / data perspective naturally), Do you stick to a waterfall model or a strict adherence to Agile methodologies. Do you use Test driven development / unit testing of the database? Do you have a continuous integration system for database development? Or even if you've gone the whole way to some sort of automated deployment platform?
I'm interested because the company I work for recently embarked on a company wide agile adoption scheme with Thoughtworks.
The reception was very, very mixed. We had some developers dive straight in and love things like pairing, test driven development, etc. And some that didn't and hated the idea of pairing in particular.
Post Thoughtworks we kinda don't have a policy as such. We have project cards that get moved around but without stringent acceptance critera for example.
So in short I'd say:
1) We don't do test driven development as a whole (Its quite difficult to do in the db)
2) We *do* use continuous integration of db code (which was a real pita to set up be we completely see the benefit)
3) We don't pair often (though we probably should because we saw a definite quality benefit when we did)
4) We have inceptions and generate cards -- they aren't quite agile stories but tasks. I'll admit that we fall down on acceptance criteria quite often.
5) We don't do retrospectives, ever. Which I think is a shame.
6) Project management revolves around identifying broad project goals and trying to estimate a time frame range for them. We still talk in terms of days rather than strict relative sizing for example..
7) In general it's still a lot more manual when you have to change db code compared to other engine or front end code. We do use Redgate tooling which certainly made * administrating* the database much easier (SQL Compare is excellent)
Anyway, I'm interested to know what you guys do.
Msg 3903.. The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION.http://nosqlsolution.blogspot.co.uk/