SQL Planet Article Writing Guide

So, you’ve got a great idea for an article and as you get excited the great ideas start to flow. This is the time to write them all down. Do not focus on the specifics of your article right away because if you get bogged down in the details, you’ll cut off the flow of ideas. Once time has passed and you’ve thought of all the points you want to make, it’s time to organize these points in the best order to illustrate your point. This can be done by creating an outline.

Internet articles break the mold of traditional writing. The name of the game is to grab and keep the readers interest. Try to create an exciting writing style that conveys your opinion and your voice and get to the point quickly. Show the reader what they are looking for early in the article, then give the supporting facts afterwards. Now-a-days, if you don’t get to the point quickly, people will move on. It’s also important not to make your article too long. If it is, that is a good indicator that you should just write a separate article.

Article Titles

Probably the most important relationship within your article is the title and the content. Visitors click on your article based upon the title. If the content doesn’t match, not only will they leave – they will be disappointed! Make sure your title reflects accurately the content of the article, and grab their attention with the title! Don’t be scared to be a little daring!

Flow

After you have the outline of the article, writing each section is best done using flow of thought. In other words, do not over think each sentence or even a paragraph. When you write whatever is on your mind, your own voice shines through. Even if you are using the wrong word in a sentence and you know there’s a better word you can use, do not break your flow. Go back an change it later. This is a little trick that I have learned through a lot of experience. The difference can be an article that is easy to follow versus an article that doesn’t make much rhyme or reason. I’ve put together plenty of those in my time too 🙂

Make good use of the times when your thoughts are flowing freely. Do not worry so much about typo’s and word choice until you are done writing your article

Proof Reading

If you’re like me, you’ll see some very obvious blunders hours after you’ve walked away from your desk and came back to re-read your article. Since this is usually the case, try to avoid the excitement of submitting your article right away. Let it sit for a bit, then come back in a few hours and double check it. You’ll be amazed at some of the obvious things you’ve overlooked. Taking time away from your article turns you into your own editor.

Visual Appeal

When writing articles it’s important to know some basics about formatting. If an article looks visually nice, it’s much more likely to be appealing. No one likes reading articles that contain run on sentences, huge paragraphs and no images. It’s refreshing to the eyes when logical sections are separated by appropriate headings, images, and code examples. These visual breaks give life to your article and they also help to visually support the point you are making.

Paragraphs look best when they are no more than half the size of your palm

Here are some of the tools we use here to make an article visually appealing:

• headings
• lists
  • ordered
  • unordered
• images
• blocks
• code examples
• graphs

Charts

[easychart type=”horizbar” height=”100″ title=”Temp Table vs Table Variable” groupnames=”Temp table, Table variable” groupcolors=”005599,229944″ valuenames=”1000 rows,10K rows,100K rows, 1M rows, 100M rows” group1values=”157,132,208,150,148″ group2values=”229,202,259,226,232″]

Here’s all the code needed to create the entire chart above:

[cc lang=”sql”]
[easychart type=”horizbar” height=”100″ title=”Temp Table vs Table Variable” groupnames=”Temp table, Table variable” groupcolors=”005599,229944″ valuenames=”1000 rows,10K rows,100K rows, 1M rows, 100M rows” group1values=”157,132,208,150,148″ group2values=”229,202,259,226,232″]
[/cc]

The full chart documentation can be found: here

Short Codes

The following codes will product the following results.

[block type="information"]Information Block[/block]
[block type="attention"]Attention Block[/block]
[block type="success"]Success Block[/block]
[block type="error"]Error Block[/block]

Information Block

Attention Block

Success Block

Error Block

To create a code block, use the following:

[cc lang=”sql” escaped=”true” inline=”true”][cc lang=”sql”]SELECT * FROM mytable WHERE entry = ‘you'[/cc][/cc]

produces:

[cc lang=”sql”]SELECT * FROM mytable WHERE entry = ‘you'[/cc]