I was so glad to hear today that Azure is expanding to Australia. This helps with two remaining areas of concern that I've heard from a variety of customers:Compliance and data sovereignty (not wanting to store data outside Australia)Latency (previously high latency even to our nearest external data centres)With both these concerns now ...

Hi Tony, That would work. An alternative would be to use XML for the parameters, and then split them out of there. Regards, Greg

Fellow MVP Alessandro Cardoso sent me information today about a private cloud and virtualisation event that's running later this month. It's being offered in Brisbane, Sydney, and Melbourne. If that's of interest, you'll find more details here: ...

Hi Folks, On Thursday night, I got to record a podcast with Reza Rad. I was interested to speak to Reza after reading his SQL Server 2012 Integration Services Cookbook. In the show, we discuss SQL Server Integration Services (SSIS) extensibility and some aspects of performance tuning for SSIS. You'll find the show here: ...

Otherwise, I'm looking at recording updated versions.

Hi Dipanjan, They got lost at the hosting company. No idea what happened. If anyone has a copy of them, I'm happy to repost them.

Subscriptions can write out to file shares. No difference with this type of subscription.

Hi Ashwini, That creates a new table with the same contents of the old one, not a backup of the table. (Backups can be taken elsewhere).

Hi Gatej, When you say that it's not the same, I'm not following what you're referring to exactly.

No, the point of the example was the difference in the case of the column ProductID vs productid. The editor "fixed" it for me.