During my academic time, I learn basic on database, I still remember some of the term right now, such as “Primary Key“, “Normalization“, “Normal form“, bla bla bla, but not really remember how this term are. If talking on more practical, I not really learn on Microsoft SQL Server, I just have opportunities to learn MySql during my web design class, which also learn PHP language.

I always wish I have opportunities to learn SQL Server language, and found that the list of SQL Server command, for those beginner for SQL Server, I guess the below SQL Server Command list will help you a lot.

Aggregate - CREATE AGGREGATE
- DROP AGGREGATE
Application Role - CREATE APPLICATION ROLE
- ALTER APPLICATION ROLE
- DROP APPLICATION ROLE
Assembly - CREATE ASSEMBLY
- ALTER ASSEMBLY
- DROP ASSEMBLY
ALTER AUTHORIZATION

BACKUP
BACKUP CERTIFICATE
BEGIN [DIALOG [CONVERSATION]]

Certificate - ALTER CERTIFICATE
- CREATE CERTIFICATE
- DROP CERTIFICATE
CHECKPOINT
COMMIT
Contract - CREATE CONTRACT
- DROP CONTRACT

More SQL Server Comment Here  (more…)

Posted by calvyn | 1 Comment »

When I flash back to Year 2008, I was thinking what I have been achieve?

Photography at 2008
So far not much special, just manage to own my 1st DLSR Nikon D80 beginning of the year, buy a 50mm lens (Approx RM380) at middle of the year, and my relative give me a set of manual SLR (Nikon F-801, AF Nikkor 35mm-105mm lens, SB-24 Flash Gun) at the end of the year. Not much photo shooting for year 2008, realize that my kits lens have fungus in side, my heart have a bit pain

My Career at 2008
As an IT Engineer, I manage to learn more deep into networking such as Power Over Ethernet, taking my CCNA course at Penang, fully manage a hotel wireless system setup and get a Siemon Certified Installer, experience on termination and install at Categories 5e, Categories 6, and Categories 7 A.K.A Tera and fiber optic; Other then being a full time IT Engineer, Part time Blogger, I also manage to register a business name, as my own business, manage a web hosting business is not easy, just as part of my life experience; not really do it aggressively yet.

Blogging Life for 2008
I start make money online since middle of 2007 from my 1st online income at Adbux, earn money from my blog is part of my achievement for year 2008, I have achieve RM1000 per month before in few month, but still unable maintain monthly RM1000 per month… some time more, some time less, still consider fail for this mission. If talking on traffic, also same with my online income; my target traffic for year 2008 was 1000 hits per days, I manage to hit over 1000++ in few days time, but still average about 700 to 800 hits only at the moment.

During 2008, few text link buyer contact me directly and interested to purchase text link from me, manage to deal with them with a good price; other then this, also have advertiser offer me a $500 per review on their product before. All this consider greatest achievement for blogging life at 2008.

What should I archive at Year 2009 ?

em… Any suggestion? (more…)

Posted by calvyn | 24 Comments »

~Fire in the hole~ Lolz this word only can heard over the game, but I wonder does those army shout this when they fire the cannon in the pass.

Few week back, my friend from Ipoh come to Penang, having 1 days penang tour, giving me an opportunities to visit the fort cornwallis again. Entrance Fees per adult is RM3 only. This place consider a good place for photography and full of Penang historical memories.

I snap a lot photo there, but all are my friend picture, not much really enjoy my own photograph there. Plan to visit Penang fort cornwallis again, and snap more photo on cannon. Any one interest to join me? (more…)

Posted by calvyn | 12 Comments »

Heard before sitemap? Did you understand the important of sitemap? and what the role of sitemap?

Long time ago, when I visit some cooperate website, I always see a “sitemap” link, in that page, it show all the website link, that time I was thinking does the webmaster create sitemap for visitor to view the summary of the website? I also thinking how come webmaster do double job, since the index (main page) already can found all the link such as “Product”, “Service”, “Company info” bla bla bla, and how come sitemap show it again…

I get this theory over some SEO consultant, they said Search Engine’s (SE) Spider or bot visit a website, can not crawl the website more then 3 level/ 3 page deep. Meaning that those content that I post week ago, or month ago or even year ago are unable to crawl from the spider, but sitemap show all the link, the spider can crawl all the page.

Seriously after I create a sitemap for iCalvyn.com, and submit my sitemap to google, the traffic increase time to time.

I found that google spider come to my website 3 time a month (March08 statistic) and my google traffic raise from 50/days to 100/days on that month.

Now, google come to crawl my website when I make a new post. Traffic raise to 600-800/days (November08 statistic)

If you are using wordpress, you require to use plugin to create sitemap, I will talk about how to create sitemap at joomla and other system soon, lets start with wordpress 1st.

How to create a Sitemap for Wordpress? (more…)

Posted by calvyn | 9 Comments »