Unless we're talking about...

Yeah, but what percentage of that data consists of porn, spam, and fragmented indexes?

Henk Schreij (3/5/2012)

---

What I learned from this discussion is: there is no easy 'set based' solution to the problem of unwrapping a csv with sql.

(a solution, like the other...

Steve Jones - SSC Editor (3/5/2012)

---

Eric M Russell (3/5/2012)

---

So you're saying that the project requirements should include a document or Excel sheet that explicitly list what accounts / roles should...

kilkenny (3/5/2012)

---

I think you nailed it on the head. And in that case, the only protection is in the collaboration processes and making sure that people are handling data...

kilkenny (3/5/2012)

---

Thanks everyone for the great insight. It seems in our situation that TDE is the best solution, aside from the performance hit to the server. The reason being...

Steve Jones - SSC Editor (3/5/2012)

---

@eric, not knocking your process in terms of what it does. I'm more concerned with the issue of actually understanding what permissions are granted and...

Steve Jones - SSC Editor (3/5/2012)

---

Eric M Russell (3/5/2012)

---

Databases have a much smaller surface area for security breaches than do Web applications. For a database, you're basically concerned with how...

GilaMonster (3/5/2012)

---

Though since this is the SQL 2000 forum, it needs mentioning that...

If you're in some...

mikemartineac (3/4/2012)

---

Hello,

In a stored procedure, I have a view as my data source. Unfortunately, views restrict the use of parameters. In my case, I need to get a value into...

Perry Whittle (3/4/2012)

---

kilkenny (2/27/2012)

---

My company has been getting a lot of requests from our clients to put into place more stringent security practices. I just received the word from...

agustingarzon (2/29/2012)

---

We are going to develop a project where clients will be able to Create their own SQL tables and fields.

The idea is to give the client the possibility...

Databases have a much smaller surface area for security breaches than do Web applications. For a database, you're basically concerned with how accounts, role membership, or object permissions have changed,...

I ran across a piece that surveyed some salaries and it shows that people working with cloud platforms are commanding higher salaries, even when the underlying technologies are the same....