Yeah, you're on the right track. I've used AZCopy for exactly this type of operation with Azure SQL Data Warehouse. I used Azure Automation instead of Elastic Jobs. I'm not...

All these functions on your join criteria like this one are going to prevent index use and slow down performance:

November 25, 2017 at 6:43 am

#1969433

I agree with the previous answer. Group by functionality and purpose, not by technology. You might have a Testing resource group, for example, on which you run validations prior to...

Unless you've set up and are using Azure Active directory, you're going to have a hard time automating this process from Azure. This is because it won't be able to...

I'd probably move this stuff:

November 22, 2017 at 6:40 am

#1969161

Capture the query runtime metrics. Do those vary wildly on the server? Also, measure the runtime from the client. Do they vary between that shown on the server? What are...

As a long...

Not really. Getting just a sub-set of data is quite difficult. There's not really a simple short cut. I'm assuming you want this for test & development. People usually take...