Consider this query:


SELECT id, name, email
FROM Customers


Now, we all know that we should use aliases and two-part names, so version two might...

+1

Super tutorial!

John Bigler (12/1/2016)

---

Although I like PowerShell too, as a BI developer, I prefer to keep as much of my code contained within SSIS as possible. So, in similar situations,...

arco.scheepen (10/25/2016)

---

I could have done it like that, but this code is part of the monitoring & registration toolkit my collegues and I have written. I found it more convenient...

Not quite sure why you didn't do the whole thing in PS. Couldn't you have just used a PS array (you could . source it)? Or even...

Trying not to reinvent the wheel:

Building Test Environments with Azure DevTest Labs[/url]

I just build what I want in Azure, fire it up when I need it and shut it down when I don't. Keeps costs way down. Much cheaper...