O'Reilly logo

Defensive Database Programming with SQL Server by Alex Kuznetsov

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 4. When Upgrading Breaks Code

In previous chapters, we have discussed the sort of weaknesses that might exist in your code that, if left unchecked, will undermine its consistency and reliability, and make it vulnerable to breaking when, for example, environmental settings are changed, or objects in the underlying schema are modified. The goal of the defensive programmer is to root out as many of these weaknesses as possible and remove them, before the potential problems even arise.

However, there are times when potential changes cannot be foreseen and so we cannot "weatherproof" our code against them; we cannot know in advance, for example, how use of a new feature might affect our existing code when we do not know what these new features ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required