+1. Agree with Phil.

I'm mostly with Grant (same employeR), but I'd put the MS tool lower. PErhaps I'm wrong as I haven't used it in awhile, but it's more setup hassle, and admin...

Log

user_name()

suser_sname()

etc. (there are a few more)

into a table before the app runs the command (and the command). Check there isn't any impersonation.

If you execute as user = 'login', can...

I love @trumpdba. Follow him/her on Twitter for laughs.

Email the article(s), and feel free to focus separate pieces on a smaller part.

The problem isn't with your machine. Probably in the chair in front of it.

Always Encrypted works well, but you need a good mechanism for distributing certificates to each client. You can use a GPO or AD scripting, but be aware, if you have...

TomThomson (4/26/2016)

---

Nice question. Just one small problem.

Either the answer is wrong or the question is badly worded. The question asks how many files, but the answer tells us...

That's always cool. I've seen 3 home steals on team's I've played with as an adult, two...

That was crazy.

SQLRNNR (4/25/2016)

---

David Burrows (4/25/2016)

---

Ed Wagner (4/25/2016)

---

Another good one is to say that someone's "out to lunch". Well, I've taken that a step further and say that someone's "so out...

jeffrey yao (4/25/2016)

---

I would "shamelessly" (due to a bit of interest conflict as an SSC author before) suggest that SSC needs to greatly increase the payment for published articles. At...

jevitts (4/25/2016)

---

I second the request for more articles on indexing! As junior-ish DBA to a new company (and the only real DBA), I had to evaluate various performance bottlenecks fairly...

Add a log to a table step, and see if that runs when SQL Agent starts.

Never seen this.

Can you disable sa and see what that does?

Typically I'd script this out and drop/create the new one.