Tag Archives: software development

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 , | Leave a comment

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 | Leave a comment

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

Defensive Programming

At SQLServerCentral, we have a book on Defensive Programming in T-SQL. However not a lot of people have read it, or at least they haven’t downloaded it. That’s disappointing, as I think this is an area many of could improve … Continue reading

Posted in Editorial | Tagged | Leave a comment

Moving Fast at Redgate

One of the pushes at Redgate Software over the last year or so is to move faster. We aim to develop software quicker and get the changes and improvements into the hands of our customers quicker. A new feature doesn’t … Continue reading

Posted in Editorial | Tagged , | Leave a comment

A Buggy Release

I definitely believe in a DevOps process, though a thoughtful, incremental one. I think this is the best way to develop software, whether you release every day or every year. Yes, you can implement DevOps and release once a year. … Continue reading

Posted in Editorial | Tagged , , | 3 Comments

Where’s the Unit Testing?

I’ve been a proponent of Unit Testing, especially for databases. I’ve given presentations on the topic and advocate the use of techniques to verify your code works, especially over time when the complexity grows, new developers change code, and potentially … Continue reading

Posted in Editorial | Tagged , , | Leave a comment

Scary Deployments

I was listening to a web developer talk about some fundamental changes in a web platform. In this case, an older system was being replaced completely with a new one, and as one of the reasons, the developer showed some … Continue reading

Posted in Editorial | Tagged , | 3 Comments

Building locally from VSTS

One of the things that you need with a Continuous Integration server is that ability to build your software on some computer system and verify things work. With Visual Studio Team Services, using Visual Studio online, this seems to be … Continue reading

Posted in Blog | Tagged , , , | Leave a comment

The Bad Data Shutdown

I’m a car guy. I like cars, I like driving, and I’ve spent a lot of time and money over the years on vehicles. I’ve swapped and enjoyed a few dozen automobiles as part of my life. If you are … Continue reading

Posted in Editorial | Tagged , , | Leave a comment