Tom wrote:

Most DBAs can be educated too, but some of them are very difficult to educate because they've been taught so many "facts" on introductory DBA courses or read them...

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

@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 using?

@jeff Moden wrote:

Perhaps I think differently than most but, to me, there's almost no such thing as separate presentation, business, and data layers. For me, it's all about safety of...

@L'EI wrote:

As a general rule though, I advise people to avoid triggers if they can - because they tend to be used for things they aren't really appropriate for, and...

@RonKyle wrote:

There is a role for triggers, but an anti-trigger bias isn't a bad thing.

I often encounter an 'anti-trigger' bias amongst DBAs, but that's usually because they've had to deal...

Chrissy321 wrote:

I guess if you were into triggers you could generate a notification when an alert is inserted.

What would be the advantages/disadvantages of using a trigger for the notifications, please?

Triggers...

Doctor Who 2 wrote:

I have worked with people that don't see the world in shades of gray. You're either on board with whatever it is they're espousing, or you're an...

Steve Jones wrote:

If you use "absolute" in much of anything, I find maturity to be lacking. Shades of gray dominate the world.

Absolutely!

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

@RonKyle wrote:

The database is a chokepoint ...

I can't imagine it being a chokepoint any more so than anything else. Network bandwidth can become a chokepoint. So can application servers. So...

Steve,

Agreed!

@below86 wrote:

Where or how do you determine what database to put your store procedure in?

Different shops may have different practises; some shops designate a specific database for siting sprocs/UDFs.

The...

Tom, I agree strongly with you. I favour moving as much application business logic into stored procedures as is possible, thereby abstracting out the UI layer from the business logic....

The author wrote:

... I sometimes think that an investment in developer education would quickly erase any productivity losses ...

Education is always a good thing, but it applies all around, too....