Blog do EzequielSQL Server Insights
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 here)) 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 here). 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 here.
Afterwards came the phase where I had to BEAM UP 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 here.
The process of “beaming up” is itself very well documented here. It consists of 5 main steps:
Afterwards you can start playing with SQL Server 2K14 and do cool stuff such as making your SSAS cubes available via HTTP(S) (tip here) or configuring remote access to the relational engine (tip here), 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 Azure Commander in your Windows Phone and control and monitor your Azure VM from there!
Disclaimer: 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.
crossposted from http://sqlargonauts.com/2014/05/29/beam-me-up-azure/