Try adding a startup sp on each node to turn off those jobs on the other nodes and turn their own job on

If you've not got an auditing tool that can scan for you, try using this guy's powershell scripts. Have a look at his blog here, they may be what you're...

When I've done it in the past, just a standard empty database creation with the tables selected for the publication created and populated when it's created option used.

You can create a new database at the target and set up replication to that.

We're just coming to the end of a project at our place to move all the SQL Server instances onto a new dedicated infrastructure. For the initial investigation of...

I quite like Apex's formatting freebie, it's configurable enough to get at least close to most rational formatting preferences. I've not used it with 2016, but it works fine...

Sergiy (6/15/2016)

---

Jeff Moden (6/15/2016)

---

An interview is the one place where volunteering information can do nothing but good... if you know what you're talking about. When someone asks a simple...

Rod at work (6/13/2016)

---

I never really thought about who pays for a data breach. I assumed the company did, but your article Steve shows me its likely the insurance company...

Interesting. For me,...

And yet, so often, that is exactly what it is - that and nothing more.

GSquared (5/31/2016)

---

David.Poole (5/27/2016)

---

If you turn up to an interview as Britain's worst presented compost heap then more fool you. You don't know who you are going to meet, whether...

Kyrilluk (5/23/2016)

---

Jeff Moden (5/23/2016)

---

I simply ask if he'll enjoy reading about himself in the morning news after the company has suffered a breach. I also explain that customers can...

Markus (5/13/2016)

---

I find it amazing that still today that if you take the defaults the sizing and growth percentages for TEMP DB, model, msdb and master are so low. ...

sqlnewbie17 (5/13/2016)

---

It does not run from SQLAgent.

Message

Executed as user: The error information returned by PowerShell is: 'The term 'Send-MailMessage' is not recognized as the name of a cmdlet, function, script...

It can depend on a number of factors, including the type of workload, but 64k is often regarded as your best starting point. We've just put in a new...