A basic approach is to write this into a batch file along these line,  (PS untested as I just threw this together)

SET LOCAL ENABLEEXTENSIONS
ECHO OFF
REM...

For current waits you can query those from sysprocesses for example, alert on current writelog waits:

DECLARE @EmailRecipient VARCHAR(1000), @SubjectText VARCHAR(1000), @ProfileName VARCHAR(1000), @Body VARCHAR(4000), @waits INT

Never mind,  I found the issue,  turns out with option 2 I was on the right track, although I had a typo in the connection string

My understanding is that if you choose an AMI that does not have SQL server installed then you subsequently install it you must use the BYOL licensing model.

Also...

An interesting solution and one I'll look into further,  here I have built something similar but in SSIS and its controlled by a masking database that stores the lists of...

Thanks Gail,...

Here is another option in powershell as I had been asked over IM to share my PS code. Whilst I can't share what we use due to sensitivity issues...

It sounds like you want to consume data from an existing web service is that correct? Or are you talking about publishing data natively in SQL server via a...

Also I forgot BCP:

https://msdn.microsoft.com/en-us/library/ms162802.aspx

The bulk insert statement can be used within regular t-sql

https://msdn.microsoft.com/en-us/library/ms188365.aspx

And the import \ export wizard can be used without a licensed install of SSIS, at least I am pretty...

I 100% agree with Jeff, having worked with many people that have been MS certified some people can take that knowledge and use it properly, some just learned enough to...

A product I evaluated recently can do this pretty easily if your looking for something outside of the native SQL server tools.

http://www.jumpmind.com/products/symmetricds/download

It can move data between numerous types of...

We have done so on 300 + servers managed in our estate over the last 5 years and not once have we had an issue, future service packs \ CU's...

I believe you have to backup to local storage on the EC2 instance and then upload the file to S3 using this method, if the file is going to be...