I’ve decided that my next VM (hosting SQL Server 2014) was going to be built in Azure, taking advantage of my MSDN subscription and using “my” SQL Server bits as well. If you have a MSDN subscription you should really take advantage of this and perhaps host those in-house projects and give them another life, which is the case of my home financials project, but I digress…
If you have a subscription where you have Azure and SQL Server included (which starts at the second lowest option for an MSDN subscription (details
)) you will see that you can setup a VM for home projects and some prototyping without any additional costs, and in some cases leave it always on. I leave you the pricing reference so that you can choose what works for you (details
). With a “Visual Studio Ultimate with MSDN” subscription it is possible, in theory, to have an A2 VM 24/7.
So, I started off by creating the VM itself (running the OS only) and following the method which is very well documented
Afterwards came the phase where I had to
the setup iso to my VM so that I could install SQL Server. First doubt in my mind: Do I have to pay for uploading data to my VM? No, you only pay for outbound traffic (after first 5GB/month), not inbound as can be confirmed
The process of “beaming up” is itself very well documented
. It consists of 5 main steps:
Create a VHD (not VHDx) on-premises with sufficient size to host the SQL Server image and attach it to the server;
Copy the iso into the VHD and detach it from the on-premises server;
Create and upload a management certificate (you can download MakeCert from Windows SDK
– mind the OS version – and you will find it here ‘C:\Program Files (x86)\Windows Kits\<OS Version>’);
You upload the VHD to your storage account using Azure PowerShell (instructions on how to configure Azure PowerShell,
). In this step also mind the VHD extension in the “
Add-AzureVhd -Destination <BlobStorageURL>/<YourVHDFolder>/<VHDName> -LocalFilePath <PathToVHDFile>
” command where <VHDName> really needs to have .vhd in the end, or you will not be able to attach the VHD to the virtual machine after uploading and you won’t be able to rename the VHD either;
Finally, via Azure management portal, you attach the disk to the VM and it is ready to use.
Afterwards you can start playing with SQL Server 2K14 and do cool stuff such as making your SSAS cubes available via HTTP(S) (tip
) or configuring remote access to the relational engine (tip
), or even use the relational instance as a source for some neat Power BI reports (perhaps future blog post).
One other cool thing you can do, is install
in your Windows Phone and control and monitor your Azure VM from there!
I hope that the information on these pages is valuable to you. Your use of the information contained in these pages, however, is at your sole risk. All information on these pages is provided "as -is", without any warranty, whether express or implied, of its accuracy, completeness, fitness for a particular purpose, title or non-infringement, and none of the third-party products or information mentioned in the work are authored, recommended, supported or guaranteed by Ezequiel. Further, Ezequiel shall not be liable for any damages you may sustain by using this information, whether direct, indirect, special, incidental or consequential, even if it has been advised of the possibility of such damages.