It is a unique challenge. The best approach I've ever seen was an organisation that applied a behaviour driven development practice to their data layer. Their ETL, databases and reporting...

What I'd like to see is some sort of framework that allows us to specify the behaviors of our software, along with the data movement and handling so that end...

Thanks for sharing. And yes, we're also doing a fair bit of CI in the database space. We have a dedicated environment for that, but follow a similar process for...

Hi Kurt,

A colleague showed me a slightly different pattern that I tend to use for utility scripts. I've had to mock up the file names as I don't have xp_cmdshell...

opc.three (5/3/2013)

---

Also worth noting, once you move file parsing into the database you gave up the option for doing data cleansing, validation, multi-system data enrichment, lots of things, in the...