2009 August | Tech Sharing Blog

Get the latest sport result for all the major league in the world.

By David on August 30, 2009

Livescore is a site dedicate for sport lovers who want to get the up to date sport result range from soccer, hockey, basketball, tennis to cricket.

I’m not really sure the accuracy of other sport as most of the time i’m only focus on the soccer. The result show on the livescore.com is almost live if compare with the ESPN channel.

Livescore.com is not only available for web user, they also have the iPhone version and WAP version where you may access through your mobile devices to keep your self update on your favorites sport result.

When you on the livescore.com home page, you may get the latest game result just infront of you. By clicking on the score link on the game, you may get the goal scoring time and scorer name.

Hopefully for those sport lovers, you may still get your favorites result while you are away from the TV.

livescore home page Get the latest sport result for all the major league in the world.

Livescore.com home page with the latest match on the home page

manchester vs arsenal result Get the latest sport result for all the major league in the world.

Match detail including goal scorer, time and card given out

Popularity: 1% [?]

SQL Server Do’s And Dont’s

By David on August 29, 2009

data SQL Server Dos And Donts So, you are now the leader of a SQL Server based project and this is your first one, perhaps migrating from Access. Or maybe you have performance problems with your SQL Server and don’t know what to do next. Or maybe you simply want to know of some design guidelines for solutions using SQL Server and designing Database Access Layers (DAL): this article is for you.

Even if you are not using SQL Server, most of these design guidelines apply to other DBMS, too: Sybase is a very similar environment for the programmer, and Oracle designs may benefit from this too. I won’t show here how to use specific T-SQL tricks, nor won’t give you miracle solutions for your SQL Server problem. This is by no means a complete, closed issue. What I intend to do is give you some advices for a sound design, with lessons learned through the last years of my life, seeing the same design errors being done again and again.

Do know your tools

Please, don’t underestimate this tip. This is the best of all of those you’ll see in this article. You’d be surprised of how many SQL Server programmers don’t even know all T-SQL commands and all of those effective tools SQL Server has.

“What? I need to spend a month learning all those SQL commands I’ll never use???” you might say. No, you don’t need to. But spend a weekend at MSDN and browse through all T-SQL commands: the mission here is to learn a lot of what can and what can’t be done. And, in the future, when designing a query, you’ll remember “Hey, there’s this command that does exactly what I need”, and then you’ll refer again to MSDN to see its exact syntax.

In this article I’ll assume that you already know the T-SQL syntax or can find about it on MSDN.

[More]

More From david_cheong

david_cheong Recommends

Digital Piano Buyer’s Guide – How to Choose (Abba Piano Tuning)
Facebook adds more privacy and sharing related features (Sathiya seelan)

Popularity: 1% [?]

Attaching event in both MSIE and FF with Javascript

By David on August 27, 2009

Most of the developer who working in MS platform will be used to the javascript window.attachEvent.

But maybe some of you don’t know that window.attachEvent is only working on IE7+ and Opera only. Your coding will hit an javascrpit error when running at IE 6 or any version of firefox.

To resolve this issue, you may need to modify your code as such:

Original Code:

window.attachEvent(“onload”, Page_load);

function Page_load(){
//function code
}

Modify code:

//set page event handlers
if (window.attachEvent) {

//IE and Opera
window.attachEvent(“onload”, Page_load);

} else if (window.addEventListener) {

// IE 6
window.addEventListener(“load”, Page_Unload, false);

} else {

//FireFox
document.addEventListener(“load”, Page_Unload, false);

}

function Page_load(){

//function code

}

More From david_cheong

david_cheong Recommends

Improved features in Windows 8 – Preview (Sathiya seelan)
Sony Ericsson Xperia Mini and Pro debuts in Taiwan, HongKong (Sathiya seelan)

Popularity: 1% [?]

Facebook down?

By David on August 20, 2009

icon facebook Facebook down? Some thing happen tonight while I’m posting the product that I sold to e-bay, Cari Mall and EC-Lifestyle.com. At the mean time, I’m thinking of posting some news and link to the most famous sociall network portal – Facebook.

I believe that Facebook have a very strong and solic hardword and infrastructure, but I see something that I have never seem before at facebook.com – “Service Unavailable – DNS Failure”.

Is that this mean the the one of the world biggest social networking website down?

Hopefully is my area having problem to access Facebook and what I saw on my screen is the error message from some other party such as our ISP (We used to that becuase Streamyx(one of the Internet provider in Malaysia) always have this kind of problem.

Hopefully what I saw now is not the true.

Facebook down while tech.david-cheong.com is still online

More From david_cheong

david_cheong Recommends

Car Washing At Auto Dealers – Before The Snowstorm?? (WashOnWheels)
The Benefits of the Digital Piano (Abba Piano Tuning)

Popularity: 1% [?]

Start your online business with cost as low as RM 1 per day

By David on August 17, 2009

Good news for all the new e-commerce seller, especially for those who just start their online business with very low capital (like me).

Now webShaper is target to help this group of people to join the e-commerce market. With this new “Webshaper + Paypal” promotion, you can start your online business as low as RM 1 per day. This special attractive promotion started by today until the end of September 2009.

At the mean time, if you first 100 user who sign up this special promotion within the promotion period, you may get an authentic Paypal Crumpler-Style bag for FREE.

Why Webshaper + Paypal?

I believe of the online user should know that Paypal is one of the world well know payment gateway which allow you to accept 19 different currencies from 190 countries around the world. (Paypal 2009 Fast Facts).

On the other hand, Webshaper is one of the top SEO friendly e-commerce solution in Malaysia. Webshaper is develop by Neowave who they have a very good experience in e-commerce field because they are only focused on building the best and most cost effective e-commerce solution for SME as ranging from one-men-show to large enterprice such as AirAsia and Telekom Malaysia.

With the combination of most powerful, SEO friendly, Cost effective E-commerce solution and the well know payment gateway in the world, now you may turn the whole wold web user become your customer.

Are you ready to turn the world web user become your customer? Just kick start from here.

More From david_cheong

david_cheong Recommends

How to download files from web directly to your Dropbox | Computechgadgets.com (Sathiya seelan)
6 Tips to Survive Working As a Freelancer in the Film, Television and Video Business (World Class Media)

Popularity: 1% [?]

How does WordPress make money?

By David on August 16, 2009

wordpress How does Wordpress make money?

How can a company like Automattic make money if they are giving away all their products (including WordPress) for free? Someone asked this question to WordPress founder Matt at WordCamp India and he surprised, at least some of us, by saying that Automattic is profitable.

Here’s how WordPress makes money according to the creator himself:

1. Blog Hosting – WordPress offers blog hosting services at $500 per month to big publishers like Om Malik, All Things D and CNN’s Political Ticker among others. They use WordPress.com’s server infrastructure to host your blog and therefore the performance will obviously be great but unlike other web hosting services, WordPress VIP Hosting doesn’t accept everyone who applies so good luck.

2. Google AdSense - Free blogs hosted on WordPress.com may sometimes carry Google ads but these ads may only appear if all the following three conditions are met:

The visitor is not using Firefox browser.
He has logged out of his WordPress account, if he has one.
The referring source is not a WordPress powered blog. So a person reaching abc.wordpress.com from xyz.wordpress.com won’t see any Google Ads.

Even with all these conditions, the revenue generated from serving Google AdSense ads on WordPress.com hosted blog may still be significant as do around a billion page views per month.

3. Automattic Kismet – You don’t see Viagra spam in your blog posts because it all gets filtered automatically by Automattic Kismet (Akismet for short), the excellent spam protection plug-in available for WordPress.

Now Akismet spam catching technology is free for personal blogs but if you maintain a corporate blog or run a network of blogs, you are required to buy a commercial license of Akismet that starts at around $50 per month.

What may surprise you is that professional bloggers, or anyone who is making more than $500 per month in advertising revenue from a WordPress blog, also needs to pay a $5 per month fee for the Akismet license.

4. Premium Accounts – While anyone can host a blog on WordPress.com for free, they charge you a fee if you want to buy additional storage space for your multimedia files or want to use a custom web domain instead of the default wordpress.com sub-domain. These arepremium features.

There’s also (unconfirmed) talk that WordPress may soon allow users to add AdSense in their free blogs for a subscription fee.

5. Web Host Referrals – WordPress.org suggests of list of third-party web hosting companies where you may self-host your WordPress blog(s) for a fee. Now all these are referral links so Automattic gets a commission per sale.

In fact, this hosting referral system may be extremely profitable for Automattic because if you search for “WordPress Hosting” on Google (a very competitive keyword phrase), the first sponsored link on the Google results page is paid by WordPress itself and it says – “Top 5 WordPress Web Hosts – Chosen by the developers of the WordPress blogging software”.

6. WordPress Support – If you need help with WordPress (or WordPress MU) but the free support forums aren’t solving the purpose, consider subscribing to the Support Network of Automattic. The WordPress development team will help you solve problems related to your WordPress system and the response time can be as low as 6 hours. This service is primarily for Enterprise users who are willing to shell out a $2.5-5k per year for support.

7. Poll Daddy – I am not sure if Matt discussed this but Automattic also provides a paid version of Poll Daddy where you can have unlimited number of questions per survey and there’s no Poll Daddy branding in your polls or surveys.