I would like to learn if agile software development methods/principles/patterns are valid to SQL programming as well. If yes, where would be a good place to start learning about that? Are there any articles or books targeting agile development in SQL context?
locked by Paul White♦ Oct 29 '18 at 9:36
This question exists because it has historical significance, but it is not considered a good, on-topic question for this site so please do not use it as evidence that you can ask similar questions here. This question and its answers are frozen and cannot be changed. See the help center for guidance on writing a good question.
Read more about locked posts here.
Yes. There is a whole web site devoted to it: Agile Data
I'm using it now for a brand new project.
My answer there doesn't capture what I do now: 2 week sprints, good enough for that sprint. As per the Agile Data site.
I find it a good practice. It focuses on the here and now, not "we might need this". So you manage a well scoped delivery. Note: I still model using a whiteboard and meatsacks first, and it's in 5NF.
I've been doing Agile development for more than four years, including my SQL Server projects, and I really like it. I think it is important to understand why and when Agile is useful, from the perspective of the whole system, and general purpose Agile-related books such as the following fit the bill: " Agile Principles, Patterns, and Practices in C#", " Patterns of Enterprise Application Architecture".
The following two books are focused on database development, as you asked, but I would read the general purpose ones first: "Agile database techniques", "Refactoring databases"