I use this list a lot (and usually Microsoft hovers around #3 or #4, occasionally #2). It's a great tool for discussing why...

We use Azure Automation. You can schedule it pretty much like Agent. Currently we don't have any specific maintenance for Data Warehouse because we do a daily reload. There's nothing...

All respect to the GUI, it's so much easier to backup and restore databases using T-SQL. Here's a good intro on the topic [/url]that ought to give you everything you...

I agree with Chris. If you can verify that all your databases are being backed up, then the issue is somehow within the job itself. It's not exiting cleanly. You'll...

Which the optimizer then turned into what I was writing:

SELECT Expr1002 = CASE

...

AZCopy is how I would do it if you aren't going to use the Redgate utility.

As to cost, the Redgate utility as currently configured, is free.

Sorry, I was away from email. However, the other answers are what you need to do. Get a list of successful backups (which was a part of Thomas' article) and...

Thomas' stuff looks excellent. I'd follow that method. If not, just querying the backupset system database can at least tell you what has been successfully backed up. You can then...

Through Microsoft's own testing, SSIS is the worst mechanism for migrating data into Azure SQL Data Warehouse. I would recommend any other method.

DISCLAIMER: I also work for Redgate.

My son purchased his first car ever and it was an ancient & abused Jeep Wrangler. I drove it and it was a blast. When my pickup truck died (ugly),...

Joy. That's going to run great... For certain values of great.

Still, curious about how the UNION resolves vs. the individual queries.

I'd love to see the execution plan for this.

Guessing. If he's doing UNION and not UNION ALL, the UNION acts as an aggregator and it might work to filter differently...

I agree with Jeff (which is pretty standard). It's almost impossible to provide assistance here without details. Sorry.

If you want to continue to poke at it, then I'd suggest capturing...

sknox (12/20/2016)

I don't know -- "Multiple Partitioned Statistics" was a pretty funny (and...

The best way to improve performance for a linked server is to push as much of the query processing as possible on to the remote server. This is best accomplished...