Just as an FYI - you can pass a datatable to a stored proc. Not sure if this is what you are looking for or not.

I pay more attention to capacity planning for cloud than I do to items which will be deployed internally. I know internally I have a surplus of resources so in...

Remember also you may (depending on how you are licensed currently) need to purchase new licensing as both hosts will need licensed.

Yes 100% put it into Source control. 
Just don't expect to be able to have 2 people work on the same package and then merge changes. Due to the xml...

For me, I generate a template excel file which contains all the formatting, layout etc. As part of the process I take a copy of this template and then export...

It doesn't split it creates a string from a list which each item separated by a comma. To do it in SQL check out the for xml options for concatenating...

If you want to use shared storage in Azure between VMs then you will need to use a third party tool or use storage spaces direct (S2D) which is available...

We use VSTS (Visual Studio Team Services) which allows use of GIT or TFS.

As Phil says - two developers working on the same package and trying to merge...