|
The more and more I work with SQL and databases, and the more developers I talk to (and the more I visit http://thedailywtf.com[^] :P), the more I notice a general lack of RDBMS fundamentals.
I have seen some pretty gnarly SQL code and database design come from some otherwise talented and experienced developers. To that end, I would like to recommend a article section specifically for non-code database articles. For example, introductions to basic SQL syntax, how to code SQL queries, stored procedures, when to and not to index, basic table design, how joins work, subqueries, views, triggers, etc. There are some SQL-specific articles that already exist on the site that can be moved there.
I think that this would be a benefit for any developer that ever needs to write raw/ad-hoc SQL queries, stored procedures, or has to design a small schema, to make sure they have a better understanding of what is going on behind the scenes and are aware of any best practices that may apply.
It would also raise the possibility of discussion (a new Database/RDBMS/SQL message board, perhaps?) regarding alternate/better approaches to certain problems. For example, given a certain scenario, it is better to build a dynamic query using multiple values in an IN , or populate a temporary table and query against it?
While having a DB message board might increase the risk of a non-developer audience, I think we could manage it.
Thoughts?
Peace!
-=- James If you think it costs a lot to do it right, just wait until you find out how much it costs to do it wrong! Avoid driving a vehicle taller than you and remember that Professional Driver on Closed Course does not mean your Dumb Ass on a Public Road! DeleteFXPFiles & CheckFavorites (Please rate this post!)
|
|
|
|
|
James R. Twine wrote: Thoughts?
We already have a SQL Forum on this site and I think it is pretty sufficient
You will see a delete button on each of your posts. Press it. - Colin Angus Mackay
|
|
|
|
|
Again, this would be for non-code/coding related issues. There are people out there that might know how to do logical DB design but not ADO/ADO.Net. Having a separate area allows easier searching for "create index" and not getting results that involve questions like Can I create an index through ADO?
And the SQL Message Board only covers the message board part of my suggestion, not the article section part.
Peace!
-=- James If you think it costs a lot to do it right, just wait until you find out how much it costs to do it wrong! Avoid driving a vehicle taller than you and remember that Professional Driver on Closed Course does not mean your Dumb Ass on a Public Road! DeleteFXPFiles & CheckFavorites (Please rate this post!)
|
|
|
|
|
James R. Twine wrote: this would be for non-code/coding related issues
I see your point, and I have fiddled with the idea of writing a basic article on database normalization. Something pretty basic, but not overly advanced to overwhelm someone trying to figure out the normalization process. Hmmm, maybe I ought to get writing it
If you try to write that in English, I might be able to understand more than a fraction of it. - Guffa
|
|
|
|
|
James R. Twine wrote: While having a DB message board might increase the risk of a non-developer audience
So developers don't code in SQL?
Arthur Dent - "That would explain it. All my life I've had this strange feeling that there's something big and sinister going on in the world."
Slartibartfast - "No. That's perfectly normal paranoia. Everybody in the universe gets that."
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Meaning, DBAs as opposed to software developers.
Peace!
-=- James If you think it costs a lot to do it right, just wait until you find out how much it costs to do it wrong! Avoid driving a vehicle taller than you and remember that Professional Driver on Closed Course does not mean your Dumb Ass on a Public Road! DeleteFXPFiles & CheckFavorites (Please rate this post!)
|
|
|
|
|
James R. Twine wrote: If you think it costs a lot to do it right, just wait until you find out how much it costs to do it wrong!
I wish I could tell some clients that!
|
|
|
|
|
J. Dunlap wrote: I wish I could tell some clients that!
Well, when my clients do something wrong, I charge to fix it
If you try to write that in English, I might be able to understand more than a fraction of it. - Guffa
|
|
|
|
|
When I try viewing articles in the Purgatory section I get a "You are not authorized to view this page" http://www.codeproject.com/Purgatory/Active_Directory_Searcher.asp[^]
Btw, the rating of this article is around 4.3 but why is it in the purgatory?
Tarakeshwar Reddy
MCP, CCIE Q(R&S)
Experience is like a comb that life gives you when you are bald - Navjot Singh Sidhu
|
|
|
|
|
It seems to be working fine for me.
|
|
|
|
|
Not sure why I am not able to see them. None of the articles in the Purgatory I am able to view.
Tarakeshwar Reddy
MCP, CCIE Q(R&S)
Experience is like a comb that life gives you when you are bald - Navjot Singh Sidhu
|
|
|
|
|
Tarakeshwar Reddy wrote: Btw, the rating of this article is around 4.3 but why is it in the purgatory?
Because it is not an article, but a source code dump.
|
|
|
|
|
Colin Angus Mackay wrote: Because it is not an article, but a source code dump.
Ah ok. I wasnt able to see it, just went by the ranking of 4.3
Tarakeshwar Reddy
MCP, CCIE Q(R&S)
Experience is like a comb that life gives you when you are bald - Navjot Singh Sidhu
|
|
|
|
|
This is what is the description of purgatory:
This section is for articles that readers have voted down but which we feel could be useful if given some attention. Enter at your own risk - but you may just find a gem.
|
|
|
|
|
When a new user subscribes show a window.alert("Please, NO PROGRAMMING QUESTIONS IN THE LOUNGE !");
|
|
|
|
|
Alerts would be very disgusting. Rather, it can auto-detect any technical keywords and then give a friendly DIV that shows a warning confirmation message. You can use AJAX to parse the text and come back with a response.
|
|
|
|
|
it would be better if we can mark them as programming question or inappropriate forum so that the admins can move it to relative forum
(this will make their work easy)
It is Good to be Important but!
it is more Important to be Good
|
|
|
|
|
- Two of my articles have been moved, and when I reply to comments, I get a message about the article not being able to be found.
- Every time I post a message, I get the "Hear that crunching sound?": error, but when I try to re-submit, the site tells me that the message has already been posted.
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997 ----- "...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001
|
|
|
|
|
1. Fixing. Give it an hour or so.
2. We ordered more hardware to handle increased load and it should be here soon. I was actually prodding the guys today about it.
cheers,
Chris Maunder
CodeProject.com : C++ MVP
|
|
|
|
|
Is it just me, or is there now no way to *modify* and article from the article's page?
http://www.codeproject.com/tips/FloatingPointEquality.asp[^]
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997 ----- "...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001
|
|
|
|
|
John Simmons / outlaw programmer wrote: Is it just me, or is there now no way to *modify* and article from the article's page?
Since it got edited, you cannot directly modify it. Get the HTML, update it, and send it to submit@codeproject.com - and an editor will update the article. You may get the outlaw programmer expedited processing - so your update may come up quicker than for other people
|
|
|
|
|
Nishant Sivakumar wrote: Since it got edited, you cannot directly modify it.
Does anyone other than me have a problem with this?
Nishant Sivakumar wrote: Get the HTML, update it, and send it to submit@codeproject.com - and an editor will update the article. You may get the outlaw programmer expedited processing - so your update may come up quicker than for other people
That seems to be a bit of a long way around, and directly consumes someone else's time. Kinda clunky if you ask me...
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997 ----- "...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001
|
|
|
|
|
You can request that an article be left in the unedited section - that allows you to edit it yourself.
|
|
|
|
|
John Simmons / outlaw programmer wrote: Does anyone other than me have a problem with this?
Well, 'edited' means that an editor has gone over it for spelling errors and formatting. If the site allows you to go back and change your article, doesn't that devalue what 'edited' means ?
Perhaps a change suggestion for the site would be, you can edit an article, it then becomes 'unedited', in the sense that an editor needs to look at it again ? I'm not sure how our other business rules would work with that, but it seems like another way to do it, perhaps.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
It makes perfect sense to me that it would be changed back to unedited, but at the same time, maybe there should be a switch for people that have a proven track record of decent grammar/spelling so that it wouldn't necessarily have to become "unedited" again. That would possibly reduce the load on the editors...
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997 ----- "...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001
|
|
|
|