Hi,

Answering my own question here but our Infra team turned on some Azure logging and it turned out my personal work account was being used but didnt have permissions on...

Pleasure, anything else then feel free to post on the forum, someone will be able to answer.

Hi,

This should do it

1. Backup the SSIS DB and Key (you can see how to do a key backup on the previous link) - This is just in case something...

Hi,

I did this the other day.

I used this as a guide, worked a treat for me.

https://blog.pythian.com/how-to-restore-ssisdb-to-another-server-and-migrate-the-ssis-catalog/

I did create the catalog on my new server before and then just restored...

Hi,

So as fate would have it I can answer my own question, the syntax is indeed correct and has now run successfully.

It seems it took a bit of time for...

Exactly what I thought but its the Azure service which set up the backup encryption, the only files it lets me access in the BLOB storage are the backup file...

Thanks Grant, thats what threw me, looking round I saw about 10 different ways of doing it.

As you say I'll pick one and get it done.

Thanks again.

Nic

Thanks for the replies on this, makes total sense, follow up question, how would you go about calling the code to do these, I'm personally thinking some stat maintenance, perhaps...

Hi,

Thanks for this, all work nicely.

Nic

Hi,

If memory servers me in the case of EXISTS vs IN, then EXISTS works slightly better as the first occurrence of table_1 record in table_2 and it will move onto...

Hi,

Problem solved, it turns out the server had been renamed but sys.servers still had the old name, odd that it let me connect to the new name but then it...

Thanks for pointing out, file type was xml so it got blocked, I've uploaded as txt now.

Blogs!!!!!! for me Brent Ozar's is top

PodCasts - Data Exposed is good but is more for Azure than T-SQL

Most importantly - Practice - Get a free copy of SQL 2019...

Thanks very much, I'm going to just leave it to do its stuff, going to be much safer that way.

Thanks,

Nic

Thank you very much.

This is perfect, it not only gives me the desired result but also explains the process behind it, saving me asking more questions later on.

Thank you for...