I'll be interested to read the rest of the process. Coincidentally, today I've been writing an Azure Automation Runbook to do something similar! 🙂

I expect there are a few ways to do this, but you can query the msdb.dbo.sysjobactivity table to monitor the progress of a job. If the stop_execution_date is absent, it's...

Have you tried using the Powershell ISE to edit and save?

Great, thanks for the replying and providing additional reading.

I have a cluster with both database engine and Analysis Services running on them with no problem, but as people have already said it depends on the scale of your...

I've done this successfully through Linked Servers and SSIS, although I'd say the former is the easier/quicker of the two to configure. Also, if you use linked servers and want...

Update: It appears that something has broken my alerts. Drop and create them and all works fine...

You can specify a display name in the Outgoing mail server (SMTP) settings of the Database Mail account. Make these unique on both instances and you should be able to...