I assume you mean you have a web server that talks to an application server that talks to a database server. Is that correct?

You need a license for SQL Server...

Stewart "Arturius" Campbell (9/30/2016)

---

Nice, easy question to end the week on, thanks Steve.

Just a point of confusion in the options:

a table variable, a table in the table, or a temp...

Glad it worked and nice test.

Apologies if I didn't explain well.

The cert protects a key that is actually used to encrypt the backup. This key is stored in the backup,...

robert.sterbal 56890 (9/30/2016)

---

I think the videos I find on youtube for virtual user groups are just fine:

https://www.youtube.com/channel/UCFX97evt_7Akx_R9ovfiSwQ

Is there a centralized listing of videos like this, or is that a good...

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.