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.
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
Apollo's Lyre is a great site for writing advice and hanging out.
Association of Authors Representatives
Looking for an agent? This is the best place to begin.
Character Building Workshop
Some interesting worksheets to help flesh out your characters
A great article on how to create memorable characters
Common English Mistakes
A great site for learning about common mistakes we make in writing.
A variety of helpful articles
Wondering if your plot, phrase, or character is a cliche? Check here to find out.
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.
Goals and Writing
A good article on how to set realistic goals
Website for writers and the business side of speculative fiction
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.
How To Critique Fiction
A detailed look at how to judge other's work
Hunting for an Agent - With Sample Synopsis
Just what it says--how to approach an agent with your query and synopsis
Inkpot Poetry Links
A great collection of markets for poets
Internet Writing Journal
Great interviews, great links for writers.
Joe's Writing Tips
A great interview with a writer who kept plugging away and finally got success!
Learning from Criticism
This is number 49 in a great series on writing from the Poynter Institute. The rest are all good as well.
Marcia Yudkin's Free Publishing Advice
A series of helpful articles on getting your work published.
Online resource for genre fiction writers
Mastering the Dreaded Synopsis
Ever wonder how to write a synopsis for your novel? Lee Masterson tells you how.
Mugging the Muse
A 207 page e-book on the publishing/writing market by writer Holly Lisle
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.
One of the best writing sites on the web--if I don't say so myself! Read my column!
Some advice on how to craft a mystery
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.
Query and Cover Letters
The How-To's of Query and Cover Letter Writing
Science Fiction and Fantasy Writers Association
A lot of cool stuff here, but the writing articles are what I like best.
Scribe and Quill
A cool site with tons of information and lots of spec fiction/ poetry etc.
Speculative Fiction Markets
Lists markets for speculative fiction by how much they pay per word.
Spicy Green Iguana
This incredible website helps you to find markets for your writing, with an easy click and search function.
A great market listing site. Just plug in some key words and you can find your market. Mostly for science fiction and fantasy.
Telecommuting Jobs For Writers
Requires a $15 annual fee to access job listings.
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.
The Writing Fix
This is a cool site with lots of fun stuff to get the creative juices flowing.
An excellent site for children's writers
A fascinating collection of obscure words
Writers At Work
Another local resource for writers
Writers Write Guidelines
Another searchable database of markets
Writing For Dollars
A searchable database of markets
A great source of articles and tips on writing, publishing and agent obtaining!
This site is a great one for anyone interested in writing for the LDS market.