Monthly Archives: August 2010

Adding leading zeroes to integer columns in the database

An interesting requirement came in today. There was this integer column which was to store 4-digit codes, like 7872, 4331, etc. The trouble was that a value like 67 had to be interpreted as 0067 too. Now SQL Server does … Continue reading

Posted in Uncategorized | 4 Comments

SQL Azure

There are two ways you can run SQL Server in the Amazon cloud. The first choice is to run it in Amazon’s Elastic Compute Cloud (EC2 for short). Each EC2 instance is basically a blank VM without SQL Server. Now … Continue reading

Posted in SQL 2008 | Leave a comment