Let’s go thru the step by step guide to setup the Windows Azure WebSites (WAWS) for a node.js project. You have likely seen the WebSites documentation and know it is very, very easy. Yes, it is, but you won’t get node.js 0.10.13 by default, you won’t get newest npm etc. Also I would like to use SQL Database which is also not very easy.
Before you start I assume you have created the WAWS in 32-bit mode (64-bit setup is similar but not available in free tier) and you have SQL Database set up (20 MB free one is fine)....
Have you ever wondered that in Windows Azure Management Portal you can run scheduled scripts on demand, but there is no documentation on how to do it yourself (at least )? I think I’ve checked every possible place and nothing. I’ve checked azure command line help and nothing. In general you have a message like this: You can also use the Management Portal to run jobs on demand. and nothing more....
Several days ago Microsoft announced new pricing model (and new prices) for Mobile Services. When adding a Standard tier is something appreciated (as previously there was no low cost non-free option for example for more extensive testing), the Premium tier is now much more pricey in many cases. Why?
Old pricing was similar to the pricing of the Web Sites offering and you were able to run 2 Reserved instances and on them for example 5 Mobile Services paying for 2 VMs....
In the last part we will add a separate data disk to our VM. It is not required. There are cases where this is necessary, but there are many more where this is not needed, especially if you want to have stateless VMs so you can easily spin up more of them. In those cases you will use the persistence layer of Windows Azure (SQL Database, Azure Storage) or separate Linux VMs for your own persistence layer (MongoDB)....
Today we will really create Debian Linux Wheezy VM on Windows Azure, as previous part was unfortunately spend on setting up everything except VM.
Create Virtual Machine with Debian System Disc We will use the VM from VMDepot. If you use it from command line, you have to properly set the source image and also the final location of the blob in storage.
A word of caution! When I’m writing this blog post there is still open issue in Azure Command Line Tools that will not allow you to use affinity group without getting an error....
Autocompletion is not always a good thing if you use something for the fist time and after seeing similar name you think it will behave as in all other languages, but in T-SQL it is not always true.
I was creating a dynamic SQL in stored procedure in SQL Azure and assumed that LEN() and SUBSTRING() will work in the way I think they should. I was wrong.
My goal was to remove the ", " part after creating optional elements in query....