Tag Archives: software development

Avoiding Stored Procedures

This editorial was originally published on Aug 13, 2012. It is bein re-published as Steve is on vacation. I ran across this piece from a developer on why he avoids stored procedures and thought it made some good arguments. The … Continue reading

Posted in Editorial | Tagged , | 2 Comments

Is Rollback Feasible for Database Changes?

One of the things I used to show people in SQL Compare was the ability to generate a quick rollback script by switching the source and target. We can generate a deployment script going from Dev to Production, switch the … Continue reading

Posted in Editorial | Tagged , | Comments Off on Is Rollback Feasible for Database Changes?

Designing for the Public

I’m a bit believer that better data, and better software can help our governments around the world operate more efficiently, and better work for our citizens. I appreciate what Tim O’Reilly has said where he notes that we want governments … Continue reading

Posted in Editorial | Tagged | Comments Off on Designing for the Public

What’s a Database Pipeline?

One of the things I ran into a few years ago was the idea of a software pipeline. A set journey across machines and stages that your software takes. In modern, DevOps style development shops, this usually means: A development … Continue reading

Posted in Blog | Tagged , , | 2 Comments