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.

Open for? Query?

Sure, linked servers can do this

http://www.sqlservercentral.com/Forums/Topic1037546-392-1.aspx

You can also use OPENROWSET

https://www.simple-talk.com/sql/t-sql-programming/questions-about-using-tsql-to-import-excel-data-you-were-too-shy-to-ask/

Thanks for the note. We are on the same schedule for the most part as we hae had for years, with republished articles on Fridays and new ones the other...

It's yours, David.

Sorry, my verbiage was poorly chosen there. I meant using RAND() in a set, getting the same values returned from a call.

As opposed to NewID()