congrats

robert.sterbal 56890 (9/30/2016)

---

What would help people record more of their technical presentations?

I'm working overnight tonight, so I can't attend the local SQL Saturday tomorrow, but I think it would be...

There is one master key per database. Poorly named, and has nothing to do with master database.

The master key protects the certificate(s) you use for the backup encryption. You need...

jasona.work (9/29/2016)

---

I would expect that would depend on the needs and requirements of your environment.

A secure type environment might require you to use a separate certificate for each database (even...

David,

No idea if SSD MTBF is linked to age or batch. That's interesting. I have seen the same thing with HDDs in servers, and in fact, in large enterprises, we've...

Wow, no idea. Maybe drop and re-define the linked server?

djackson 22568 (9/29/2016)

---

Interesting comment about how SSDs might not be susceptible to this.

SSDs have a limited number of writes. Hard drive life is measured differently, MTBF. I would...

Column names corrected. We never aim to trick you on a column name in the answer and a set of data. In this case, hand transposing results to the question...

BLOB_EATER (9/29/2016)

---

so....I will be doing a presentation in front of 40 people soon, I was wondering if the vets here have any advice? Practice in front of a mirror? smile?...

I agree, though how do we keep up with changes? If the portal revs, or there are changes/additions to how you migrate data, connect, change firewalls, etc.?

Not an easy task.

Hmmm, DROP TABLE works for me.

Eric M Russell (9/28/2016)

---

So we're talking about self tuning database servers?

Perhaps:

Indexes that are auto-created based on data access pattterns like statistics.

Deployments that will auto-rollback in the event of an...

Iwas Bornready (9/28/2016)

---

It's mind boggling to imagine the software repairing and improving on the code all on its own. The next step is to write nothing, just state what you...

Rich Mechaber (9/28/2016)

---

Steve, in your explanation, did you mean to say "This is offset by -1" instead of "by 1"? Or maybe by "offset" you meant the successive values...

TomThomson (9/27/2016)

---

Steve Jones - SSC Editor (9/26/2016)

---

Tom, I wish I were sloppy. My X5 had a bad actuator in the passenger side. My daughter was in the car, we had...