Embrace Stored Procedures

Question

Embrace Stored Procedures

Viewing 3 posts - 76 through 77 (of 77 total)

You must be logged in to reply to this topic. Login to reply

Gary Varga SSC Guru Points: 82166 More actions · Answer 1

rmechaber (4/24/2015)
bdenning (4/22/2015)
I in no way stated "don't read this article" but instead it was a soft plea to SQL Server Central to not reference such articles. Doing so increases the "hits" on the site, and indicates acceptance of the language. By posting my comment (my first on this site), I've been notified of updates and have enjoyed the discussion. It is obvious that there are very intelligent people out there from whom I can learn, even new words and phrases ("ad hominem" -- thanks Jeff, I had to look that one up! :-)). I was mostly interested in how Steve as editor might respond (or not respond). This is my 2nd post (at the risk of being flamed further) -- others have expressed their opinions and others have been "off subject". I apologize to those who've thought I've been "passive aggressive" and "more offensive" as I never wanted to offend anyone, but wanted to express my personal opinion to SQL Server Central. If there is a better venue for doing so, please let me know (Steve?) -- otherwise, end of discussion.
Welcome to SQL Server Central! This is a fantastic community of ridiculously helpful, intelligent, spirited, and experienced people. I've found this to be a very welcoming place, though you occasionally need to put on your asbestos suit and shrug off a comment or two...

Agreed. Welcome!!!

...or at least this is a fantastic community of helpful, intelligent, spirited, experienced and ridiculous people.

Gaz

-- Stop your grinnin' and drop your linen...they're everywhere!!!

Gary Varga SSC Guru Points: 82166 More actions · Answer 2

Most have focussed on the business logic being in the database but the reverse is an equally troubling phenomena i.e. UI logic in the database. This ties the database to a particular UI and often a single viewpoint.

PS Even as a developer I sit in the "stored procedures are the default to use" camp.

Gaz

-- Stop your grinnin' and drop your linen...they're everywhere!!!

andrew gothard SSChampion Points: 12314 More actions · Answer 3

Steve Jones - SSC Editor - Monday, April 20, 2015 9:27 AM
Jeff Moden (4/20/2015)
bdenning (4/20/2015)
I started to read this article and didn't get past the first paragraph. Why technical people resort to street language to express themselves is beyond me. I expect that an intelligent person should be able to intelligently articulate their thoughts without the use of such language. I am an avid subscriber to SQL Server Central and have learned a lot from the posts, and would prefer that SQL Server Central NOT reference articles with such language. We are data professionals, and the use of such language is NOT professional. That's my personal opinion, and I suspect that there are others out there that agree with me. I will continue to bypass articles with such language.
I'm right there with you on thinking that's just wrong but I tolerate them because, when someone resorts to such language, it's usually because they're really angry about something and a lot can be learned from an angry person. The only thing (IMHO) that's worse than that is when someone resorts to passive aggressive ad hominem attacks instead of sticking to the point.
I debated about this. I did add the NSFW tag because I wanted people to be aware.There are (perhaps) better ways to express your feelings, but some people struggle. I certainly have gotten upset about the issue in the past, and I thought the language helped express the emotion of frustration with people that become dogmatic about not using the feature.

One of the more interesting aspects of the discussion from my perspective, so far, is the fact that the piece is illustrated with someone aiming a gun.
However, culturally, the view of some USians appears to be, that its some bad words that's the issue there. From a UK perspective, an apparent viewpoint that threatening to shoot someone (albeit clearly in jest - one would hope) because you disagree is not worth comment, as long as you don't use relatively mild profanity while doing so, seems rather odd - to say the least.
In the UK the general perspective would be diametrically different.
Not a personal attack on anyone, by the way, simply an observation. We're all, to a degree, the product of our society.

I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.