SQL Server feature install from template (Azure VM)
When deplying an Azure VM with SQL Server, there is no functionality to decide what SQL Server Services/feature to install (SSIS, SSRS, SSAS) The template is configured to install everything, which is not always ideal, as sometimes a service might not be needed and having it running (or even turned off) it a security risk and each SQL Server service increases the surface attack area and requires an account to run so again further security risk. In the template have a simple checklist so you can decide what SQL Services you want to install. It could make the deploment quicker to run, handy if you had many deployments to make where you only require (for example) the SQL Server Engine and SQL Agent.
Scott Crosby (SQL Data Cloud Ltd) commented
Only 2 votes?