Computer Learning, My Free Writing on Computer and Information technology

Here’s the steps:

1. Make a backup of your database on SQL 2000
2. Then move the backup to the new SQL Server 2005 server
3. Perform a restore in the SQL Server 2005.
4. The database will be up instantly.
5. Set the compatibility level of the new database that is created in SQL 2005 so that it match SQL 2000 before performing the restore process.

PS:

1. But remember that You can’t backup database on 2005 and restore it to 2000 since there is no backward compatibility works.
2. Do not forget to map the user to the database too.

Tags: sql server 2000, sql server 2005, microsoft, sql server

I was doing some programming on PHP, then i found a problem. It’s a text that shows Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at…. After browsing for a while, i found this. It’s because a whitespace before the opening tag of PHP.

It’s clear right now….

Tags: php programming

Almost everybody know blogdesk from blogdesk.org. It’s a full featured blog client for windows operating system. It has many features, such as:

• Multi blog engine, WP, drupal, serendipity, etc.
• Easy Technorati tag creator.
• Edit article already published.
• Multi broadcast on more than one weblog.

I used to write a tutorial on this, but i found another good tutorials. From efisitek.dagdigdug.com. It consists of 2 tutorials:

1. How to setup blogdesk for Wordpress Blogs - part 1
2. How to setup blogdesk for Wordpress Blogs - Part 2

PS: Full with pictures as illustration…

Tag: Blogdesk, another interesting links

Have your website indexed by search engine? if haven’t then you could do manual submit using Creating online. You might also use free submitter, such as http://www.submitexpress.com.

But being indexed hasn’t yet enough. you still have to optimize it so that your pages on website can be indexed as much as possible and gaining best positions on search engine results page (SERP). There are many techniques (the free ones) that can be used to optimize your website.

Some Files You have to prepare:

If the search engine haven’t indexed your website, it means the search engine are lazy, so you have to invite them to your site by giving them some files that describes your site. Some of the files are:

• sitemap.xml (or it’s compressed version sitemap.xml.gz) : This file contain list of URL that describes your website and introduce it to google.
• urllist.txt (or it’s compressed version urllist.txt.gz) : the same as sitemap, but for Yahoo!.
• ror.xml : URL lists that can be broadcasted/syndicated via RSS Feed.
• sitemap.html : URL lists on HTML format.

Making URL Lists

IF you haven’t understand how to program using xml, then dont you worry. You still can make uRL lists without having to code it by yourself. There are many providers on the Net can be utilized. Some of them online, such as ttp://www.xml-sitemaps.com, or you could install some softwares on your computer, such as GSiteCrawler (http://gsitecrawler.com).

Upload URL Lists to Web Hosting

Now upload the files to your web server. on it’s root directory (for example on public_html). This files will be automatically detected by BOTs sent by search engines.

For sitemaps, you could use Google Webmaster tools, and submit your sitemap. Google Webmaster tools also offers many superb facilities for webmasters so that the webmasters know the positions of their websites on google’s eye hence can optimize it.

Do you want to build your own costumized wordpress theme but you feel you don’t have enough skills to code it by yourself, eg: you can’t codes on HTML, JS, PHP or CSS.

Don’t worry dude, you can still make your own wordpress theme by using www.yvoschaap.com. On that site, you can make WordPross theme online , you can manage how it looks, setting the colors, layout, and see the live preview. To download it, you could click Save and the theme will be downloaded right to your desktop on .zip. So you can implement it on your own blog.
Want to try, just visit Yvoschaap’s site to make wordpress theme without coding, here

Drupal is 2nd most famous CMS after Joomla. It has many features such as multi user, blogs, themes and can be extended using plugins. It’s already used by many big portals, such as what the drupal.org claims:

Today, Drupal powers sites including the homepages of Warner Brothers Records, The New York Observer, Fast Company, Popular Science, and Amnesty International and project sites by SonyBMG, Forbes, Harvard University, and more. Drupal can be used to create personal weblogs (Tim Berners-Lee), deliver podcasts (TWIT.tv), connect online communities (SpreadFireFox.com), form artist collectives (Terminus 1525) or inform the masses (The Onion).

This is steps you can do to install Drupal on your webserver:

Read the rest of this entry »

RSS feed is a method for broadcasting your site. It’s a xml file that describes your site condition so that everyone can access it. Usually the description on rss feed only contain teaser of the article.
RSS feed consists of items. Each item represents article on your website. An item usually consists of TITLE , DESCRIPTION (this is where the teaser located), URL (url which the viewer should click to open the article’s full version). Each item should be opened with <item> tag and closed with </item> tag.

<item>
<title>My New Article</title>
<description>Hey guys, i guess it’s already a long time not writing on this blog… bla…bla…bla…</description>
<link>http://yourblog_URL.com/2008/10/10/new-article</link>
</item>

One rss file can contain many items that represents the amount of articles you’d like to broadcast. A RSS file should also contain Title, Description and Link that describes the root address of your blog, for example:

<title>Your blog's Title</title>
<description>Everything about Computer</description>
<link>yourblog_URL.com</link>

The information of your blog should be contained inside the <channel> and </channel> tag, but outside the <item> and </item> tag.

Insert the version of your RSS feed by using:

<?xml version="1.0" ?>

So the complete code should be:

<?xml version="1.0" ?>
<rss version=”2.0″>

<title>Your blog's Title</title>
<description>Everything about Computer</description>
<link>yourblog_URL.com</link>

<item>
<title>My New Article</title>
<description>Hey guys, i guess it’s already a long time not writing on this blog… bla…bla…bla…</description>
<link>http://yourblog_URL.com/2008/10/10/new-article</link>
</item>

<item>
<title>Old article Article</title>
<description>Old article’s contain…</description>
<link>http://yourblog_URL.com/2008/10/10/old-article</link>
</item>
</channel>

</rss>

There are many content management system (CMS) web wares on the net. What i/we love most is the Free and Open Source? why? tons of answers are available. How to choose from that abundant resources of CMSes? here’s the guide:

• If you want to use CMS that is suitable for big enterprise that has to deal with large amount of contents, than i think you have to choose Joomla or Mambo. Although it’s a little bit heavy but for i guess it’s very suitable for big enterprise. I consider Joomla or Mambo is a heavy duty CMS.
• For medium class, i think you should use Drupal. It’s also full featured CMS, many plugins are available.
• For light weight CMSes, you could use Wordpress/serendipity or b2cafelog. It’s easy to operate although the customization is not as flexible as two previous classes. 

Do you have any opinions, you might share it here?

I am currently on a task installing and configuring a network on a small company, Since this company utilize Windows and has no intention of using Linux, then i am searching for compatible server softwares, the open source and free software to be utilized on the network.
From this project, i learned that BIND has a WIndows version (previously, i thought bind was solely for Linux/Unix), but it lacks of documentation on how to install it. To see how to install bind on Windows, check this tutorial from Alex. It’s quite superb tutorial, step by step, very easy to understand.

What many people complaining about Firefox was it’s slow speed. Due to it’s architecture, Firefox is very slow indeed, especially when loaded for the first time.

To answer this grievance, Mozilla launched project with code name = WebRunner which now changes to Mozill Prism. What is Prism?

According to Wikipedia, it’s main feature was integrating web applications with the desktop, so Prism will allow web applications to be launched from the desktop and can be configured independently of the web browser.

From it’s components, it was a stripped down of Firefox, there’s no Tabs, no toolbar, no status bar, no plugins and extensions. Hence Prism can loads web page faster than Firefox.

Try it by yourself, it’s multiplatform just like Firefox does. There are many installers provided for many operating systems.

Tags: Mozilla Prism, Mozilla, Web Runner