I bump into 3 interesting articles on Digg today. After reading these 3 articles, I can conclude that to get your blog fully exposed to the world you need to follow 3 steps:

1. Get your blog quickly indexed by the search engines
2. Optimize your blog to be crawled by the search engines
3. Make sure you have the right plugin to support point 1 and 2

Get Your Blog Quickly Indexed by the Search Engines

Adam McFarland taught us how to get this on his article. So according to him, there a few steps that fasten indexing of your site. They are:

• Register your domain name. For cheap domain name, Netfirms always have this cheap $5 .com/.net/.org domain. But Godaddy also offer even cheaper for .info domain which is at $ 0.99 (yes .. 99 cents !!!)
• Put up a home page. Once you got your domain and hosting, you need to install the Blog software. Since I only have experience with WordPress, I can’t recommed you any other blog software. Personally to me, WordPress is good enough. So many people support it by creating plugins/themes. Because of that, I never look at the other way.
• Setup a blog and sign up for FeedBurner. The registration is quick and fast. They even let you select the buttons to connect your feed to many RSS Readers.
• Write a few articles and submit to directories. Adam recommends iSnare and EzineArticles.I think I will submit one of my previous post.
• Get a link from an indexed site. To do this I participate actively on Google Groups and Digg. Any better idea?

Optimizing WordPress Blogs for Search Engines

Christian Van Den Berge taught us how to get this on his article. So according to him, these steps need to be done to optimise your WordPress blog for search engines indexing process:

1. Using Permalinks. Permalinks can be setup on your WordPress Admin module. (Option – Permalink).
2. Put titles up front in your URLs. I use “/%category%/%postname%/” which should have the same effect
3. Tags. You need to install Ultimate Tag Warrior plugin to enable tags in your blog.
4. Page Titles. By default, WordPress already set your blog title into “Blog Title – Post Title”. Unless you want to include the tags into the title as mentioned on point 3, you do not need to do anything.
5. Choose your Post Titles carefully. I believe that in order to be a good post title, the title should be the general idea of the post. I think capitalizing the first letter of every word in the title should make it more attractive.
6. Autolinks. I don’t use Autolinks. I believer Autolinks might increase the chance of killing my webserver.
7. Related Post. Use this plugin to add Related Post. Originally, the plugin will use the other posts’ Title as the factor to determine whether they are related. Currently, it has the ability to use keywords for each post. You are very likely need to edit all your previous posts that don’t have keywords.
8. Ping Services. WordPress 2.1 (the one used here) has an automatic ping service to be signaled whenever you publish a new page. You might want to add the number of ping services through feedburner.
9. Google Sitemaps. First, submit your site to Google here. Then you submit the site to be reviewed here. You will be required to send an original page or add a meta tag on your header. In my opinion, the latter is the easier one. Then you need to create the xml site map file, you can automatically do that using this plugin. Finally, submit your xml sitemap to Google here.
10. Categories. Christian‘s idea is that the Categories must be structured such as : “Programming – C# – Threading”.

Legend: : Done : Not (Yet) Done

Hopefully now we have a good understanding on how to get our WordPress blog exposed to the World. The final treat is the list of best plugins for WordPress. Please carefully pick one that really benefits you/suit your needs, without introducing significant increase in the server load.

Currently I am reading a book about MS SQL Stored Procedure. I need to read the book as an anticipation that i will be accepted to an Insurance Company. Just to make sure my brain is not rusty :-P. I believe in-order to understand this guide, you need to know the basic Data Creation and Data Modification commands in T-SQL. I will use this posting to share with you what i *roughly* get from the book 🙂

1. What is Stored Procedure?

Stored procedure is a collection of queries/commands encapsulated in a function stored in the database server. The function may receive parameters which later can be used as the paremeters of the queries/commands. More definition.

2. Why Stored Procedure (SP) is useful?

Because SP will encapsulated your queries/commands into a parameterized queries/data definitions/data modifications. Thus you can standardize the exchange of information between the database server and its users. At the same time you will reduce the debugging-time on Application development since all the business logic are stored in the database. SP also able to help you maintaining security by classifying which users are permitted and which users prohibited to call the Stored Procedures.

3. Why we need Stored Procedure (SP) ?

Because we want to achieve result mentioned on number 2. We can achieve this by replacing the Stored Procedure as a library of functions stored outside the database server. But it will hinder the flexibility of type of Application that using the same business logic. For example, the current business application is using Web-based interface; If we want to create a Desktop-based/Smart Client Application we will be using more time to translate the business logic into different programming language/framework. We also will have major headache if we need to upgrade the Application but not the Business Logic.

4. Why we DON’T need Stored Procedure (SP) ?

This was an improvement from my previous post. We will slowly scroll the snippets using “Window.setTimeout()” functionality.

The modified code (modification is shown in bold) is as follows:

header.php

var myObject;
var myrules = {
	'.codeclicker' : {
		onclick : function() {
			//alert(this.parentNode.tagName);
			var o = this.parentNode;
			if (o.style.overflow == 'hidden') {
				myObject = this.parentNode;
				o.style.overflow = 'scroll';
				var i = 0;
				var increment = 10;
				var loopNum = 48;
				for (i=1; i<=loopNum; i++){
					window.setTimeout('myObject.style.height=''+increment*i+'px';',increment*i);
				}
				window.setTimeout('myObject.style.height='100%';',i*increment);
			}
			else {
				myObject = this.parentNode;
				o.style.height = '21px';
				//window.setInterval('Collapse()',50);
				o.style.overflow = 'hidden';
			}
		}
	}
};
Behavior.register(myrules);

Smaller value of increment and bigger value of loopNum will increase the smoothness. If you have better/cooler idea please share with us 🙂