fixed, was MSDTC, stopping and restart it sorted the issue.

Hi Grant,

Thanks so much for the reply. Its good to know I'm on the right road.

The tricky bit is not knowing how the data will be used in more detail,...

Thanks for the reply.

Thank you both for the replies.

I best get reading your blog post Tim. I'll let you know how I get on.

Thanks again,

Nic

Hi,

Thanks for offering you view, your right, as I have 2 separate AG's on the primary I will do that, I'll patch Secondary 1 first, then failover to...

And that was caused because the PolyBase services were not running, they weren't running as TCP was not enabled for the SQL Server.

Hope this helps others.

Thanks,

Hi,
The same code works in 2017 so I think M$ must have changed the syntax a little and as its not out yet the documentation is not available.
Now...

Thanks for the replies
Which login do you mean to alter.

The one SQL server and ssrs run as on the report server?
Or the login that the reports...

Oh, I got my hopes up and thought we had an answer then.

Thanks both for the responses.

I'm going to use 25 as a start and then review slowest query/application performance over the next few weeks and then follow the process...

Hi,
Sadly I don't have a definitive answer for you. We did an upgrade from 2012 to 2016 (3 times actually, 1 for DEV, 1 for UAT and 1 in...

Thanks for the response Grant.

couldn't agree more on the unit tests, sadly this is a 3rd party owned database and they do the upgrades. I guess I'll have...

Hi,

I'm no expert but could you not do this in Azure Data Factory? That should offer the functionality you need.

Thanks,

Nic

To answer you question about overwriting existing database, it will automatically overwrite it and the database will be in restoring state until complete.

But it will not do the...