Yes this can be added as a script for post snapshot which will be applied at the subscriber.

This can be found in SSMS under the properties of the publication in...

The only email a job can send without custom coding transact sql in the job steps is on completion, sucess or failure of the job.

When an alert fires it can...

I think I see the issue, your alert sounds like it is setup to start a job, rather than contact an operator when the condition is met.

Personnly I...

A few things I would check first:

1. Is mail setup on the server (SSMS > Managment > Database Mail)

2. Can you send and recieve a test email from...

I cant see a declaration for the variable using either the declare \ set method or the declare and assign method. This is most likely where your syntax error...

I assume you have the max server memory option set in SQL server to 5GB. So as mentioned above providing your server supports adding RAM without rebooting the server...

Yes, there are more complex ways of doing this when you factor in Roles \ Schemas \ Users \ Logins but you can simply do this.

1. GRANT the execute permission...

As said above creating a Powershell script or Batch file is a fairly simple way of doing it.

It all depends on what you are comfortable programming in....

For example to run a Windows Server with SQL Standard edition for 10 hours per month it can be as little as $7.

Take a look at Amazon Web Services.

You could use EC2 instances which can be Windows Server virtual machines where you can install SQL Server and do any tests...

Your configuration means you are getting an alert sent to the operator configured for the job.

From your description what you really want is an email that summarises the...

A few things worth noting, posting this question in either of the SQL 2012 or 2014 parts of the forum is more likely to see responses than in SQL...

Hadoop is essentially an infinetly scaleable data processing engine. You can query data from multiple sources be that files, binaries, databases using utilities such as sqoop and hive...

As is mentioned above its a security issue. And you have many options:

1. Add the Service Account used by the SQL Agent as a login on each of...

I assume you are wanting to add data from SQL Server that can then be map reduced?

Hadoop is essentially a framework of applications of which work together to allow you...