SQL Azure Databases

When I do sessions on Windows Azure, then SQL Azure is always part of that. Most of the time remarks about the maximum sizes of SQL Azure database come from the audience. Quick summary. There are 2 SQL Azure editions available: Web and Business. I have not found any differences between the two, but perhaps this will come in the future. The Web edition comes in sizes of 1 Gb and 5 Gb. The Business edition starts at 10 Gb and ends with 50 Gb, in steps of 10 Gb. In December the maximum will be 150 Gb (here). The … Continue reading SQL Azure Databases

Windows Azure Storage vs Local Storage

If I do sessions on Windows Azure, I always point out that we as software engineers/architects should think about costs again. Because Windows Azure may look more expensive in comparison of an on premise situation, but we as developers have influence on it. Ok, the different VM’s of course have standard costs. And as I told in my previous blogpost, when you combine roles this could help you. Hereby a list of the standard costs of a VM per month. Please notice the table goes for 1 instance of a VM. Look here for the calculation with more instances.   … Continue reading Windows Azure Storage vs Local Storage

SQL Azure Custom Logging to Windows Azure Table storage

At a Windows Azure customer of ours they keep track of changes on the tables in the SQL Azure database. This is done by a trigger, the trigger inserts the change in a table. I can not think of another solution without losing data or changes. But the downside of this, the logging space in SQL Azure costs a lot of money. This logging is only used for an analyses of a problem and the read frequency is rather low. And btw the data is not relational. So the space for this logging data in the SQL Azure database is … Continue reading SQL Azure Custom Logging to Windows Azure Table storage

Update Record in Windows Azure Table storage

As told in my previous Blogpost I kept a list of the Blob name and the LastModifiedUtc. To make this solution usable for more then one instances I stored this list in a Windows Azure storage table. So if I copied a Blob with a changed LastModifiedUtc, I had to update my list too. Adding a new record to the Table storage was rather simple. this.context.AddObject( BlobCheckListContext.BlobCheckListTable, newItem ); this.context.SaveChanges(); But for updating you need to do something little extra. Btw this also goes for a deletion. this.context.AttachTo( BlobCheckListContext.BlobCheckListTable, updatedItem, “*” ); this.context.UpdateObject(updatedItem); this.context.SaveChangesWithRetries( SaveChangesOptions.ReplaceOnUpdate ); So before updating of … Continue reading Update Record in Windows Azure Table storage

Windows Azure Blob storage Modified date

I made a solution for a customer where I copied blobs from Windows Azure Blobstorage to an different location on Windows Azure Blobstorage. But to be a bit efficient I was keeping a list of blobs I have copied already. This list contains a Last modified date. So I the Last modified date was not changed I did not copy etc. Smart and at first it looked rater simple. Take a Blob look at the property LastModifiedUtc and voila. blockBlob.Properties.LastModifiedUtc So with a blob I look in the list compare the LastModifiedUtc of the Blob with the one in the … Continue reading Windows Azure Blob storage Modified date

Windows Azure Configurations

There are different ways on the Windows Azure platform to make and set configurations. For the WebRole we have the web.config and for the WorkerRole we have the app.config. These config files are not new and we are used to use these. The advantage of this is, porting our current applications to the Windows Azure platform do not need many adjustments. Disadvantage these settings are only changeable with a new deploy of the application. In principal with RDP to the Role, you are able to change the settings in the web of app.config . But these changes will disappear during … Continue reading Windows Azure Configurations