“Design By Document”

I’ve only used this once but it worked perfectly. I was developing a function based on a regulatory document specifying how to build a calendar for regulatory reporting. Normally you take a requirement and translate it in your mind to a convenient “shape” for coding. This is fine for most purposes. I started developing my […]

Mastering Cloud Vocabulary

Vocabulary is a problem when you start working with Microsoft Azure, or any cloud service offering. There are so many new terms to wrestle with. I was considering blogging my own glossary but Microsoft now have several web pages giving very useful information. Here are the links:

Googling for Fun and Profit

Do you feel embarrassed about Googling answers to problems instead of working them out for yourself? Well don’t: if you’re a working programmer who has to answer for time spent, you’ve got to make use of other people’s work. As long as you don’t believe everything you read, it’s simple efficiency.

Enforcing Upper/Lower Case in a Sql Server Column

Case sensitivity in Sql Server depends on the collation applicable to the column, which of course is often the same as the database default collation. Unlike Oracle, Sql Server out of the box is case-insensitive (at least in English-speaking Western countries). This means that you don’t need to consider whether data is upper- or lower-case […]

Cloud Choice: Disaster Recovery

A recent Run As Radio podcast covered “Disaster Recovery in the Cloud”. Many suggestions weren’t brand new of course, but it was great to have them validated by two of the best people in the field. Anecdotes from personal experience livened up the conversation. I’ve made some notes here, but do listen to the podcast […]