Eric M Russell (10/3/2016)

---

robert.sterbal 56890 (10/3/2016)

---

Its a balance of risks. Private VPNs were very expensive and I would bet more likely to fail than the public network.

Additionally the risks on...

Eric M Russell (10/3/2016)

---

Also, put this...

You have to be clear about what the terms mean.

An instance is an installation of SQL Server, running on a host (Windows, or at some point, Linux). This instance can...

chrisn-585491 (10/3/2016)

---

99.99 percent of the internet is fragile. Why?

Nobody wants to spend the money and pass the laws make security seriously. We have millions of unpatched computers, consumer gear...

Well, after quite the tail kicking of the Steelers this weekend, I wonder if I can hold on tonight.

Good luck, Dan.

TomThomson (10/3/2016)

---

Nice one.

Horrible explanation though, unless you provide a definition of "near". Ask yourself whether a thing is near itself - a lot of people would argue that it...

To answer your questions:

q1 - It doesn't matter. Note, the user isn't "at" a database. They have a database context for their connection. Either from login or from the USE...

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...