I didn't press for more details when I...

Craig-315134 (8/23/2013)

---

@eric M Russell wrote:

Basically SSIS, BULK COPY, INSERT/UPDATE, etc. that violate foreign key constraints or duplicate keys. Not only do these bypass the application and middle tier, they tend...

Craig-315134 (8/23/2013)

---

@jeff Moden wrote:

Too many people get to most databases without using the application.

???

Please explain, Jeff. You've thrown me. If people aren't using an application UI, what are they...

below86 (8/22/2013)

---

I get it now, it was throwing me off when you said 'line', I was thinking the actual line number.

Maybe this is just me not understanding stored procedures but...

below86 (8/22/2013)

---

Eric M Russell (8/22/2013)

---

Chrissy321 (8/22/2013)

---

And as I stated earlied how do you look at a log for a stored procedure? If I have a 1000 line SQL with...

Chrissy321 (8/22/2013)

---

And as I stated earlied how do you look at a log for a stored procedure? If I have a 1000 line SQL with 50 different SQL statements...

Craig-315134 (8/22/2013)

---

Eric M Russel wrote:

Implementing business logic using a middle tier compenent, web service, or even a stored procedure solves the problem of data validation for applications, but not for...

pdanes (8/22/2013)

---

Doctor Who 2 (8/22/2013)

---

I like what you wrote here, Steve, but I wonder how practical it is. However, it might just be my work environment. Having worked in a...

below86 (8/21/2013)

---

As a developer I have to disagree. 🙁 ...

Andy Warren (8/22/2013)

---

I love abstraction, but I only use it when I get to the place where it's needed to solve the problem. I've seen the view for everything approach...

eccentricDBA (8/21/2013)

---

I find this editorial interesting because over a decade ago I the development team I was working on had this exact discussion.

I was a developer at that time and...

In addition to implementing views as a means of rrestricting user access to columns and rows, I've also used them as a wrapper for tables that contain symmetric key encrypted...

Gary Varga (8/20/2013)

---

Eric M Russell (8/20/2013)

---

Gary Varga (8/20/2013)

---

Of course, some users don't help themselves or the rest of us. There are always a small minority who will claim that the...

Gary Varga (8/20/2013)

---

Of course, some users don't help themselves or the rest of us. There are always a small minority who will claim that the issue they are raising is...

There is perhaps one advantage that you as an employer have when you're paying an employee more than he's worth... you have leverage. The employee can't easily bail and get...