Here's a list I compiled once of sites I've found to be helpful. I hope they are for the most part still up and running.
Absolute Write
This site has a lot to offer. I've signed up for the Premium Edition of Absolute Markets and have found it to be very helpful
http://absolutewrite.com/
Apollo's Lyre is a great site for writing advice and hanging out.
http://apolloslyre.com/
Association of Authors Representatives
Looking for an agent? This is the best place to begin.
http://www.aar-online.org/mc/directory/viewallmembers.do?masthead=true
Character Building Workshop
Some interesting worksheets to help flesh out your characters
http://writersvillage.com/character/index.htm
Character Creation
A great article on how to create memorable characters
http://sfwa.org/writing/character.htm
Common English Mistakes
A great site for learning about common mistakes we make in writing.
http://www.wsu.edu/~brians/errors/errors.html
Eclectic Writer
A variety of helpful articles
http://www.eclectics.com/articles.html
FindCliches.com
Wondering if your plot, phrase, or character is a cliche? Check here to find out.
http://www.findcliches.com/
Finding a Book Publisher
A great article for those wanting to find a publisher and wanting to avoid the scam world of the vanity press. Also check out the home page of Absolute Write, there are many more good things for writers at the site.
http://www.absolutewrite.com/novels/find_a_book_publisher.htm
Goals and Writing
A good article on how to set realistic goals
http://www.absolutemarkets.com/articles/khullar01-19-05.htm
Green Tentacles
Website for writers and the business side of speculative fiction
http://www.greententacles.com/articles/2
Hatrack Writer's Group
This site, owned by Orson Scott Card, is a great forum, and fun place to get your stories read and commented on. Try it.
http://hatrack.com/writers/index.shtml
How To Critique Fiction
A detailed look at how to judge other's work
http://www.crayne.com/howcrit.html
Hunting for an Agent - With Sample Synopsis
Just what it says--how to approach an agent with your query and synopsis
http://www.sfwa.org/writing/OP71.htm
Inkpot Poetry Links
A great collection of markets for poets
http://inkpot.com/poetrylinks/
Internet Writing Journal
Great interviews, great links for writers.
http://www.internetwritingjournal.com/
Joe's Writing Tips
A great interview with a writer who kept plugging away and finally got success!
http://www.jakonrath.com/tips5.html
Learning from Criticism
This is number 49 in a great series on writing from the Poynter Institute. The rest are all good as well.
http://www.poynter.org/content/content_view.asp?id=79160
Marcia Yudkin's Free Publishing Advice
A series of helpful articles on getting your work published.
http://yudkin.com/publish.htm
Market List
Online resource for genre fiction writers
http://marketlist.com/
Mastering the Dreaded Synopsis
Ever wonder how to write a synopsis for your novel? Lee Masterson tells you how.
http://www.fictionfactor.com/articles/synopsis.html
Mugging the Muse
A 207 page e-book on the publishing/writing market by writer Holly Lisle
http://writer2writer.com/FreeDownload/Mugging_the_Muse.pdf
Muse It Up Club
A great site for anyone interested in learning more about writing and critiquing--it's a legitimate site and I'm a member there.
http://museitupclub.tripod.com
Muse Marquee
One of the best writing sites on the web--if I don't say so myself! Read my column!
http://themusemarquee.tripod.com/
Mystery Writing
Some advice on how to craft a mystery
http://www.gillianroberts.com/writing.html
Newspaper Links across America
This is a searchable link of most of the daily newspapers in the U.S. and I think maybe some outside the U.S.
http://www.gebbieinc.com/dailyint.htm
Query and Cover Letters
The How-To's of Query and Cover Letter Writing
http://www.underdown.org/covlettr.htm
Science Fiction and Fantasy Writers Association
A lot of cool stuff here, but the writing articles are what I like best.
http://sfwa.org/
Scribe and Quill
A cool site with tons of information and lots of spec fiction/ poetry etc.
http://www.scribequill.com/
Speculative Fiction Markets
Lists markets for speculative fiction by how much they pay per word.
http://www-2.cs.cmu.edu/~mslee/mag.html
Spicy Green Iguana
This incredible website helps you to find markets for your writing, with an easy click and search function.
http://www.spicygreeniguana.com/search/index.asp
Story Pilot
A great market listing site. Just plug in some key words and you can find your market. Mostly for science fiction and fantasy.
http://www.storypilot.com/
Telecommuting Jobs For Writers
Requires a $15 annual fee to access job listings.
http://www.tjobs.com/new/writers.shtml
The Snowflake Method For Writing a Novel
This guy believes that like a snowflake, novel writing should begin small and be added to geometrically. An interesting concept.
http://www.rsingermanson.com/html/the_snowflake.html
The Writing Fix
This is a cool site with lots of fun stuff to get the creative juices flowing.
http://writingfix.com
Underdown
An excellent site for children's writers
http://www.underdown.org/early_rd.htm
Weird Words
A fascinating collection of obscure words
http://www.worldwidewords.org/weirdwords/index.htm
Writers At Work
Another local resource for writers
http://www.writersatwork.org
Writers Write Guidelines
Another searchable database of markets
http://writerswrite.com/guidelines/
Writing For Dollars
A searchable database of markets
http://www.writingfordollars.com/Guidelines.cfm
Writing-World.com
A great source of articles and tips on writing, publishing and agent obtaining!
http://www.writing-world.com/
latterdayauthors.com
This site is a great one for anyone interested in writing for the LDS market.
http://latterdayauthors.com