This is a horrible tutorial.  You go from creating a free trial subscription to having a full dashboard and issuing Powershell commands.  What about the steps in between?  I expected...

Thanks for the replies everybody, here are my follow up questions.

so I would try to split the updates into multiple parallel updates based on some column you could use...

So there...

Thanks for the reply but unfortunately this format is coming from an inbound file that I have no control over. Furthermore the client insists this is the "right format"...

I'm not feeling PowerShell. I'm running SQL Server 2014 so I have to run Import-Module "sqlps" in order to get all the features and methods available with the Snap-Ins...

Why wasn't the mistake corrected in the code once pointed out?

No it's happening on a Monday after work. It's a monthly meeting for the PASS members in that part of Germany. It's actually happening at the Microsoft office/campus...

Curious where do you live? Some areas are red hot for BI/SQL Server professionals: the Chicago area is booming. Also Germany, UK and Switzerland have plenty of...

No diversity in technology? Are you kidding me? Go to Toronto and in the IT department of any major bank, you will see a lot more "visible minorities"...

Thanks for your response Alan. I actually suggested a third alternative: Create an OLE DB Source and write a T-SQL stored procedure to shred the XML into a...

Thanks for the suggestions guys; they look like interesting reads as I have already downloaded them.

I'm pretty excited about SQL Server 2016 since the client just updated to 2014 6 months ago. Nonetheless I've heard a rumour that after 2016, you won't have any...

Unfortunately setting the SQL Server service dependent on Cryptographic Services didn't work.

Connections are always made using the login's current security context, which is Windows Authentication. It sounds like an...

Thanks for the suggestion, I will try it out and let you know.