Use PowerShell to Create a Windows Azure VM With SQL Server BI and SharePoint 2013

A lot of acronyms in the title there, but if you are the type of person that might want to use PowerShell to create a Windows Azure VM with SQL Server BI and SharePoint 2013… you know what VM and SQL and BI mean ;)

Over on MSDN, there are some great resources to enable you to quickly set up the BI stack, hosted on a Windows Azure Virtual Machine:

https://msdn.microsoft.com/en-us/library/windowsazure/dn385843.aspx

This topic and the supporting Windows PowerShell Scripts step you through creating a Windows Azure Virtual Machine (VM) that runs Microsoft SQL Server Business Intelligence (BI) features and Microsoft SharePoint 2013. The procedures and scripts assume that you have a Windows Azure subscription, installation files for SQL Server 2012 Service Pack 1 (SP1), and installation files for SharePoint 2013. The document includes a procedure to create virtual hard disks (.vhd) to contain your installation files. For more information on requirements, see the Prerequisites section of this topic.

For similar content on a single VM that utilizes SharePoint 2010 and SQL Server 2012, see Use Windows PowerShell to Create a Windows Azure VM with SQL Server BI and SharePoint 2010 (https://msdn.microsoft.com/en-us/library/dn175489.aspx).

For similar content on a multi-server farm, see the white paper Deploy SQL Server Business Intelligence in Windows Azure Virtual Machines ( https://azure.microsoft.com/en-us/documentation/articles/virtual-machines-provision-sql-server/ ).

Recommended Experience: The topic and scripts assume that you have some familiarly working with Windows PowerShell scripts and Windows Azure subscriptions.

The following diagram illustrates the workflow of preparing your computer, running the Windows Azure PowerShell scripts from your computer, and then running Windows PowerShell Scripts on the VM:

worklfow of powershell scripts

Source: Use PowerShell to Create a Windows Azure VM With SQL Server BI and SharePoint 2013