Skip to main content


Showing posts from 2013

Convert Any Files to PDF

One common question many asked is "How can I actually convert a document or even image to a PDF file?". In some of my earlier articles, I wrote about converting a webpage into a PDF without installing any tool [option 1, option 2] and also manipulating existing PDF file(s) like merging, splitting, etc with an absolutely free tool.

Today, I just chanced upon toPDF. toPDF provides the capability to convert text documents, presentations, spreadsheets and images to PDF format. Some of its attractiveness include free service and needless to install any tool onto your PC since it is web-based. This free service supports up to 5 files (25Mb max).

10 Tips For An Effective User Experience UX Debrief Meeting

How should one conduct an effective user experience (UX) debrief meeting such that all stakeholders in the team can benefit from and do better in the next round? Userfocus offers 10 practitioner tips for running an effective UX debrief meeting.

Don’t wing it. Prepare thoroughly. Have a plan.Don’t think of the debrief as a wrap-up meeting — think of it as a springboard to the next step. And make sure UX is part of the next step.Co-chair the meeting with a lead member of the project team.Make sure the main decision-makers attend.Don't give a PowerPoint presentation, and don’t rehash the report. If you have 60 minutes talk for 20 minutes, then discuss for 40 minutes.Insist that attendees must read the report and prepare comments and questions.Before you summarize the study findings, ask the team to share what they learned from the study, what surprised them and what usability issues they feel are most important or most serious.Simplify your message. Focus on just the 5 most severe usa…

Security Practices When Making Calls to Server From Client Side

With HTML5 getting more widely adopted and more application logic done on client side, better (a different type) security should be considered to mitigate risk. Nettuts+ discussed some of the measures that can be deployed for just that. The topics are:

Don’t Even Think About HTTPMake XSS Less Harmful With Content Security PolicyUse Cross Origin Resource Sharing Instead of JSONPSandbox Potentially Harmful Iframes
» Client-Side Security Best Practices | Nettuts+ launches automated tool to migrate from Gmail

Microsoft is continuing its attack on Google by launching an automated tool to migrate Gmail to its very own web-based (successor of

The blog post claims emails, contacts, labels and even calendars can be imported. Immediately after the import is completed, Microsoft will send an email notification to your inbox.

Though I am not a fan of, I thought I should give the tool a try one day for curiosity sake.

Happy Birthday from Google

The birthday doodle from Google is in fact same as last year's.

HtmlEncode and HtmlDecode In JavaScript

In web development, we often need to encode a string especially input from user so data with potential malicious intention when displayed will be safe. On server side, we can use e.g. HtmlUtility.HtmlEncode (in ASP.NET for encode) and HtmlUtility.HtmlDecode (in ASP.NET for decode).

What if we need one in JavaScript? Here's how to do just that!

<script src=""></script> <script language="javascript" type="text/javascript"> <!-- function htmlEncode(value) { return $('<div/>').text(value).html(); } function htmlDecode(value) { return $('<div/>').html(value).text(); } var s = "<b>hello's world</b>"; var encoded = htmlEncode(s); var decoded = htmlDecode(encoded); alert(encoded); alert(decoded); //--> </script>

This Visual Guide Outlines How Men's Suits Should Fit

A visual guide on what how men's suits should fit so it look fit and neither too small nor big. A good general knowledge.

Generate VCard as QR Code Using Google Docs

Should you have lots of contacts to be imported into your phone, it can get pretty time consuming to input one at a time. One time saving tip is to have them entered into a spreadsheet and have them converted into VCard format. Google Docs does have a feature to generate VCard as QR Code which you may then use any QR Code reader to read them.

This article demonstrates exactly just how to do that.

A quick summary:
Create a new Google Spreadsheet

Setup 5 columns i.e. First Name, Last Name, Phone, Contacts, QR Code.

First 4 columns should be self-explanatory. As for the last column, it shall be a formula to generate QR Code. Copy and paste below formula.

=image("" & A2 & "%20" & B2 & "%0ATEL;CELL:" & C2 & "%0AEMAIL:" & D2 & "%0AEND:VCARD")
Hope it helps.

What is "Exit Rate" and "Bounce Rate"?

Exit rate

The number of times a visitor leaves your domain from a page, divided by that page’s total views. Generally expressed as a percentage.

Bounce rate

The number of times a visitor enters a domain on a page but leaves before viewing any other page in the domain, divided by the total number of views of that page. Also generally expressed as a percentage.

Responsive Design for Websites and Email

10 Steve Jobs videos you should watch instead of Ashton Kutcher’s ‘Jobs’

Sorry to say this - I actually read several reviews that Ashton Kutcher's movie - ‘Jobs’ were rather poor and this made me changed my mind watching it. The Next Web published an article on 10 Steve Jobs videos you should watch instead of Ashton Kutcher’s ‘Jobs’ and I thought they were excellent to watch!


JAVA: Get MD5 Hash On String

The following demonstrates how to perform MD5 hash on string. For it to run, you will need to import these 2 packages. static void main(String[] args) { try { String hash1 = computeMD5Hash1("hello world"); String hash2 = computeMD5Hash2("hello world"); System.out.println(hash1); System.out.println(hash2); } catch (Exception e) { } } //using HexBinaryAdapter to convert byte array to string public static String computeMD5Hash1(String plainText) { String hash = ""; try { MessageDigest md5 = MessageDigest.getInstance("MD5"); hash = (new HexBinaryAdapter()).marshal(md5.digest(plainText.getBytes())); hash = hash.toUpperCase(); } catch (Exception e) { hash = ""; } return hash; } //no library to convert byte array to string public static String computeMD5Hash2(Str…

National Day Parade (NDP) Theme Songs (Consolidated)

28 May 2015: Added theme song for NDP 2015.
20 June 2016: Added theme song for NDP 2016.

Just come of the video compilations used as themes songs for National Day.

NDP 1998: Kit Chan 陈洁仪 -- Home 家

NDP 2001: Tanya Chua - Where I Belong

NDP 2002: Stefanie Sun 孙燕姿 -- We Will Get There 一起走到

NDP 2003: Stefanie Sun 孙燕姿 -- One United People 全心全意

NDP 2008: Joi Chua 蔡淳佳 -- 晴空万里

NDP 2010: Corrine May -- Song for Singapore

NDP 2011: Sylvia Ratonel -- In A Heartbeat

NDP 2012: Olivia Ong, Natanya Tan -- Love at First Light

NDP 2013: Sing A Nation Choir -- One Singapore

NDP 2015: Dick Lee -- Our Singapore

NDP 2016: 53A -- Tomorrow's Here Today

Google Releases Seven Videos On Typical Manual Spam Actions Received On Webmaster Tools

Google released seven videos for the most common manual action notifications related to spam for websites in your free Google Webmaster Tools. The videos include user-generated spam, hidden text and/or keyword stuffing, pure spam, thin content with little or no added value video, unnatural Links to site video, unnatural links from your site and unnatural Links to site – impacts links.

User-generated spam

Hidden text and/or keyword stuffing

Pure spam

Thin content with little or no added value

Unnatural Links to site

Unnatural links from your site

Unnatural Links to site - impacts links

» Google Releases Seven Videos On Typical Manual Spam Actions | Search Engine Land

The Phantom of the Opera 2013 Casts (Singapore)

How to Do a Partial YouTube Embed (Custom Start and End)?

Suppose you have a long YouTube video but would like to do an embed only from say first to second minute? It's actually possible with a simple tweak.

The following is the standard embed code (without changing anything) of the PSY - Gangnam Style YouTube from first to second minute.

<iframe width="560" height="315" src="//" frameborder="0" allowfullscreen></iframe>
To do a partial embed from the first to second minute, you will first need to convert the periods into seconds. So it would be from the 1*60=60 seconds to the 2*60=120 seconds. We will then add the 2 new start and end parameters to the embed code. The following is the customised embed code.

<iframe width="560" height="315" src="//" frameborder="0" allowfullscreen></iframe>
The video goes like this!

World Map

{ prologue } bookstore at ION Orchard closing down sale

{ prologue } bookstore at ION Orchard is currently having its closing down sale. Yes, you didn't hear me wrongly - CLOSING down sale. Looks like high-end bookstore globally is not doing well at all. It must be because of the rising popularity of eBooks.

Don't miss it!

Modal window effects using CSS transitions and animations

Nifty Modal Window Effects offer many possibilities for modal overlays to appear using CSS transitions and animations.

How to Turn Off Thumbs.db From Appearing?

The auto creation of Thumbs.db files in folders with images can get annoying. Before burning photo albums into DVD-R, I often have to go around searching and deleting such files. This can also get annoying for web developers using version control software e.g. TortoiseGit and TortoiseSVN.

Eh .. Sometimes, deleting these files can get the "file is in use and cannot be deleted" prompt. Very annoying.

So what exactly is Thumbs.db? As quoted from Wikipedia,

On Microsoft Windows operating systems, starting with the IE4 Desktop Update for Win95/98, a thumbnail cache is used to store thumbnail images for Windows Explorer's thumbnail view. This speeds up the display of images as these smaller images do not need to be recalculated every time the user views the folder.
Yes we know the purpose of Thumbs.db but what if we still wish to turn off Thumbs.db from appearing? There is a way to do it by tweaking a setting on the Local Group Policy Editor.

From the Start Menu, click Run optio…

MSSQL: Generate Random String Using SQL

The following will generate a random fixed-length string using SQL. Simply pass in a string of accepted characters and the length of the random string to be generated.

IF ISNULL(object_id('cspRandomString'),0)<>0 DROP PROC cspRandomString IF ISNULL(object_id('fnGenRandomInteger'),0)<>0 DROP FUNCTION fnGenRandomInteger GO CREATE function fnGenRandomInteger(@MinValue int, @MaxValue int, @Seed float) returns int as begin -- ============================================= -- Author: Loh Hon Chun -- ============================================= return ((@MaxValue + 1) - @MinValue) * @Seed + @MinValue end go CREATE procedure cspRandomString ( @Result varchar(255) output, @AcceptedChars varchar(255), @Length int ) as begin -- ============================================= -- Author: Loh Hon Chun -- ============================================= set nocount on declare @ret char(255) declare @i int, @pos int set @Result = '' set @i = 0 …

11 tips for developing a mobile app that users will love

An article on The Next Web lists out 11 tips for developing a mobile app that users will love.

Testing is keyGo Deep With Your UsersPlan for the Offline ExperienceDesign With Ease of UseMake It Stupid SimpleTailor Your DesignUse GridsCover as Many Platforms as PossibleDon't Forget the Importance of ConvenienceEmulate the Real WorldPick One Thing and Nail It

Stop Windows from Restarting Your Computer After Windows Update

Almost always, Windows will always show the "your computer is going to restart in 15 minutes ..." prompt every time Windows Updates is performed. This can get annoying especially when the update setting is set to auto download and update. So I can we make the annoying prompt not to show?

The following fix should apply to both Windows 8 and 7.

Open your registry editor by typing regedit from your Start Menu → Run box.Navigate to key HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows\WindowsUpdate\AU. Many may see up to \Windows level. In that case, you will need to create new keys for \WindowsUpdate and \WindowsUpdate\AU.Now, create a new DWORD (32-bit) value NoAutoRebootWithLoggedOnUsers under the AU key. Give it a value of 1.Reboot your machine and you are done.
NOTE: It is still your responsibility and is definitely recommended to reboot whenever you are ready to so the updates can be applied completely.

» Stop Windows from Restarting Your Computer After Updates | LifeHa…

What to look out for for responsive adaptable web design?

An article on the Smashing Magazine website - How Much Has The Web Really Changed? discusses what has changed for the past one decade or so in web development. A lengthy but easy-to-read article.

Up until not so long ago, we used to base our designs on some rather general assumptions about screen size and input type. With the rise of devices with various screen sizes and alternative ways to interact, these assumptions have turned out to be unreliable. We need to upgrade the defaults that we use when we start designing our websites.

Google Doodle for Malaysia On Polling Day 2013

Google doodle for Malaysia as the Malaysians go to the poll today.

GS1 Prefix List - How to Determine Origin of Food From Barcodes?

Do you know that it may be possible to determine the country where a food product is manufactured bought from a supermarket by reading the barcodes on the package itself? However, do note that the barcodes do not provide identification of country of origin for a given product though hopefully the manufacturer can put our mind at ease if certain countries are in our blacklist.

How to read the barcodes?
Turn over the food product and look for the barcode.

The first 3 digits of the barcode will reveal the GS1 Prefix.

Tally with the list below to find out the country where the food product could have been manufactured at.

GS1 Prefixes do not provide identification of country of origin for a given product. They simply provide number capacity to different countries for assignment from that location to companies who apply. Those companies in turn may manufacture products anywhere in the world.
ASSIGNED GS1 PREFIXES000 - 019GS1 US020 - 029Restricted distribution (MO defined)030 - 039GS1 US040 - 04…

Samsung Galaxy S4 Commercial Video - Going Wireless

Official Chrome Extension for Google Keep

Google has released an official Chrome Extension for Google Keep - a task keeping minimalistic app. The Chrome extension can only be installed from the link above i.e. you won't find the app from doing a search.

As quoted from the Google Drive blog post,
The Google Keep Chrome app launches in its own window, so you can create notes, cross out your to-do lists, and attach photos to tasks while you work on other things. And if you don’t have an internet connection, don't fret: the Chrome app works offline because we all know that ideas (big and small) can be sparked at any time.

The Re-Imagining of Microsoft

Bing, Skype, and Xbox rebranding plans revealed in Microsoft design presentation.

WAKE UP! Malaysian Rapper United (Namewee / Ashtaka / 5Forty2)

ASP.NET fails to detect IE10 causing _doPostBack is undefined JavaScript error

Should you encounter _doPostBack is undefined JavaScript error on IE 10, it is because there is a bug in the browser definition files that shipped with .NET 2.0 and .NET 4.

Scott Hanselman published two ways to fix this: one is a machine-wide fix, the other is a way to fix individual sites. The replacement of the "fixed" ie.browser file will supposedly resolve the problem but it somehow didn't quite work for me. If that file didn't work for you, you may wish to use the below instead.


<browsers> <!-- Mozilla/5.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4325) --> <browser id="IE6Plus" parentID="IE"> <identification> <capability name="majorversion" match="^[6-9]|\d{2,}$" /> </identification> <capabilities> <capability name="ecmascriptversion" value="3.0" /> …

Skype Facing Problems Signing In Using Microsoft Account

It's confirmed that signing into Skype using Microsoft Account is facing problem as indicated on Skype Heartbeat.

It seem to be affecting only Skype for Desktop.

In case you do need to connect with your MSN friends urgently, you may explore the following options:

Skype on mobileThird party IM e.g. or eBuddy.
[UPDATE Apr 25, 2013 18:15 GMT+8] The issue has been resolved - at least for myself.

Xiang Yun (向云) Euology On Huang Wenyong (黄文永)

Quoted from the Wikipedia,

Huang Wenyong (25 July 1952 – 20 April 2013) was a Malaysia-born Singaporean actor, musician, and former teacher of Chinese descent. He was an actor for MediaCorp from the early 1980s until his death. Appearing in more than 100 television programmes, he was among the first few batches of locally-trained actors to enter the local entertainment industry and considered to be one of the "pioneers in local Chinese drama". Huang died on 20 April 2013 of Lymphoma.
Soon after his death, several fans and fellow colleagues pour in their consolation and regret to have lost an invaluable asset to Singapore local film industry. Long-time working colleague of Huang Wenyong's (黄文永) - Xiang Yun (向云) penned an euology on the passing of her friend.

Xiang Yun (向云) penned an euology on Huang Wenyong (黄文永)



Samsung Galaxy S4 (Corning Gorilla Glass) Scratch Test

Coming Samsung Galaxy S4, equipped with Corning Gorilla Glass, is put to scratches under knives, keys and coins, pass with flying colours.

See for yourself.

Yahoo! Mail New Re-thought iOS and Android App

Ever since Marissa Mayer came on board as the CEO of Yahoo, its mobile strategy seem to have taken quite a bit of a lift. Once slow and sometimes buggy Yahoo! Mail mobile app has now been revamped and re-thought.

Quote from Yahoo! corporate blog post Unbox Your Mail with Yahoo! Mail For Tablets,

Today, we’re excited to introduce the Yahoo! Mail Apps for iPad and Android tablets - a full-screen experience that gets rid of the noise. There are no folders, no buttons, no tabs - just you and your mail - and you can easily flip through it like a magazine. We've designed Yahoo! Mail to take full advantage of the tablet making reading your email faster, easier and just a little bit more fun.

Download Yahoo! Mail for iPad and Android tablets now.

Flat Design Language Makes It to Facebook Too

Facebook redesigned its icons moving from a more 3D-like icons to flat icons. The changed icons which also include its logo are as below:

Get Facebook Home on Any Android Phone

Facebook Home is live but is available only on selected phones for now. Lifehacker has a tip on how to Get Facebook Home on Any Android Phone.

A first look on Facebook Home.

Constant "Check Disk" After Windows Update 2823324

You may be encountering constant prompt to perform "Check Disk" on boot-up after performing the recent Windows Update. Microsoft Security team has confirmed a problem with security update 2823324 and has since pulled it off from the pipe.

Should you have unfortunately installed it, please read this Microsoft release on the steps required to uninstall 2823324. I personally experienced the problem and resolved it using the just-mentioned instruction.

All the best.

Control Postback Only On Second Attempt After Validation Error

Recently, I encountered a problem whereby my DropDownList in UpdatePanel didn't AutoPostBack after a validator control return failure. The PostBack only happen after I tried to change the SelectedIndex the second time.

Reading from a blog, I learnt that resetting Page_BlockSubmit back to False in client side will resolve the problem.

What is Page_BlockSubmit?

When the user clicks on a button causing a full post back, after running Page_ClientValidate ASP.NET runs another built in function ValidatorCommonOnSubmit. Within Page_ClientValidate, Page_BlockSubmit is set based on the validation. The postback is then blocked in ValidatorCommonOnSubmit if Page_BlockSubmit is true. No matter what, at the end of the function Page_BlockSubmit is always reset back to false.

If a page does a partial postback without running any validation and Page_BlockSubmit has not been reset to false, the partial postback will be blocked. In essence the above function, RunValidation, acts similar to Validator…

Video: Accident Near Bugis Involving Mercedes Driver

On 15 April 2013 before 8:30pm, an accident involving up to 7 vehicles occurred near Bugis at the junction of Victoria Street and Middle Road. This accident is said to be the result of a drunken or fainted Mercedes driver.

Investigation is still on-going. Thank goodness, passengers in the taxi are unharmed.

Facebook Home "Launch Day" Video Ad

What do you think of the Facebook Home "Launch Day" video ad? What message is Facebook trying to convey? Did you having a better understanding what Facebook Home is all about after watching this video? IMO, the video seems to suggest Facebook Home is a great potential for creating distractions.

PSY - Gentleman

South Korean the Gangnam Style man has just released his new music video - Gentleman. Will this new Gentleman video break previous Gangnam Style record 1.5 billion YouTube views? Currently, the Gentleman video has recorded 6.9 million views so far.

What do you think of this new video? IMO, I find it rather clown and non-gentleman.

How to Disable Chrome New Right Menu?

If you somehow or rather don't like the latest Chrome's right menu, there is a way to disable it.

Look for the shortcut where you usually start Chrome e.g. on your Desktop.

Right click on the shortcut and then Properties.

Make sure the Shortcut tab is selected.

In the Target field at the end of "C:\Program Files\Google\Chrome\Application\chrome.exe" after space add "–-disable-new-menu-style" without quotes. (note we have got two hyphens before disable).

Click OK to apply changes.
Done! The next time you click on this shortcut, the good usual familiar right menu will be used.

» Don't like Chrome’s New Menus? Here is how to Disable Them | TechDows

Difference Between LCD, LED, Plasma, and OLED TV

My trust in Citibank has gone down the drain

Please do share if you do have a bad experience with Citibank or any other banks too.

Dear Sir/Mdm,

Reference to a request from @AskCiti (Twitter handler) to send an email to the above email address for elaboration as to why I have decided to terminate my credit card and my relationship with Citibank, I am here - now writing this email.

Twitter correspondence here:

So, what actually happened?

On Feb 2013, I received a credit card bill from Citibank showing an annual fee of S$150 + S$10.50 charged onto my card.

I called in to +65 6225 5225, spoke to a customer service officer (CSO) and requested for a waiver. The guy I spoke to promised and reassured me a total of S$160.50 would be waived on the spot. I proceeded to make bill payment without the waived amount.

On Mar 2013, I received a credit card bill from Citibank. What shocked me was not only the S$160.50 wasn't been waived, a further S$21.85 was incurred due to an unexpected deb…

How to Determine Origin of Food From Bar Codes?

According to a Facebook post, it is possible to determine the origin of food bought from a supermarket by reading the barcodes on the package itself.

Disclaimer: I am not sure if it is 100% accurate.

HOW TO READ BAR CODES... (everyone must know)


With all the food and pet products now coming from China, it is best to make sure you read label at the supermarket and especially when buying food products. Many products no longer show where they were made, only give where the distributor is located. The whole world is concerned about China-made "black-hearted goods".

Can you differentiate which one is made in Taiwan or China ? The world is also concerned about GMO (Genetically Modified Organism) foods; steroid fed animals (ex: 45 days old broiler chicken).

It is important to read the bar code to track its origin. How to read Bar…

MSSQL: Run Large SQL Script

Having problems when running large SQL scripts using the SQL Management Studio (SSMS)? I would suggest you use sqlcmd instead. Save your script in a flat file (e.g. .sql or .txt) and pass the file as an input parameter to sqlcmd like below.

sqlcmd -S SERVER\INSTANCE -i mysqlscript.sql
In case you are having problems logging in, you may wish to try either one of them.

sqlcmd -S SERVER\INSTANCE,PORT -i mysqlscript.sql

sqlcmd -S np:\\\pipe\MSSQL$INSTANCE\sql\query -i mysqlscript.sql
NOTE: Replace SERVER, INSTANCE, PORT accordingly to suit your server configuration.

Hope it helps.

Google New April Fools' Day Features

As part of Google's tradition, a series of new features or initiatives were announced in this year's April Fools' Day.

We have announcement from YouTube at which they announced they are now ready to announce the best ever uploaded video in 10 years' time. The selection process will be by several technicians based on strict guidelines. And YouTube will be shut down for good.

Next, we have announcement featuring whole new service in beta - Google Nose - a whole new different experience in search using a sense.

We also have got Google Maps launching treasure mode.

Joining in the fun, Gmail is launching Gmail Blue, obviously in mockery on Windows Blue - making everything blue.

Google Fiber is bringing fiber close to you, as long as you are connected to a "pole".

For webmasters and marketers, Google Analytics participated in this joke day by including hits from the International Space Stations.

Last but not least, a Google Easter Egg for you just by doing a search

10 Must-Have Chrome Extensions for Developers

The Mashable published 10 Chrome extensions for web developers and I bet web developers like you yourself must be using some of them. Do you have your own favourite extensions? Do share with us.

Firebug LiteWeb DeveloperSession ManagerClear CacheChrome SnifferJSONViewResolution TestEdit This CookiePage Speed InsightsPostman - REST Client
Related Readings:
10 Firefox Add-Ons for Developers10 Firefox Add-Ons for Designers

10 Firefox Add-Ons for Designers

The Mashable published 10 Firefox Add-Ons for Designers and I bet web designers and web developers like you yourself must be using some of them. Do you have your own favourite add-ons? Do share with us.

ColorZillaPencilMeasureItStylishView Source ChartFiresizerHTML ValidatorFont FinderCSS UsageTab Mix Plus
Related Readings:
10 Firefox Add-Ons for Developers10 Must-Have Chrome Extensions for Developers

10 Firefox Add-Ons for Developers

The Mashable published 10 Firefox Add-Ons for Developers and I bet web developers like you yourself must be using some of them. Do you have your own favourite add-ons? Do share with us.

FirebugWeb DeveloperFireFTPYSlowGreasemonkeyJSONViewRESTClientEmpty CacheJS DeminifierFireshot
In my own opinion, HttpFox should be the other worthy mention add-on.

Related Readings:
10 Firefox Add-Ons for Designers10 Must-Have Chrome Extensions for Developers

Infographics: Blog Weekly Insights

MSSQL: Update running sequence / number

Let's say we have a table with a column of numbers and for some reason, they are not in running sequence. Instead of editing the rows manually, we can actually do it using a SQL script.

Hopefully the following helps.

--Create some test data IF EXISTS (SELECT 1 FROM sys.objects WHERE object_id = OBJECT_ID(N'tblTest') AND type in (N'U')) DROP TABLE tblTest GO CREATE TABLE tblTest (Label VARCHAR(20), OriginalOrderNo INT, OrderNo INT) INSERT INTO tblTest (Label, OriginalOrderNo, OrderNo) VALUES ('four', 4, 4) INSERT INTO tblTest (Label, OriginalOrderNo, OrderNo) VALUES ('seven', 7, 7) INSERT INTO tblTest (Label, OriginalOrderNo, OrderNo) VALUES ('one', 1, 1) INSERT INTO tblTest (Label, OriginalOrderNo, OrderNo) VALUES ('two', 2, 2) INSERT INTO tblTest (Label, OriginalOrderNo, OrderNo) VALUES ('five', 5, 5) INSERT INTO tblTest (Label, OriginalOrderNo, OrderNo) VALUES ('nine', 9, 9) GO --BEFORE SELECT * FROM tblTest ORDER BY…

MSSQL: Get schema owner of database tables

To retrieve a list of schema owner of database tables, try the following code snippet. Hope it help.s

SELECT t.object_id AS 'TableID', AS 'TableName', s.schema_id AS 'SchemaID', AS 'SchemaOwner' FROM sys.tables t inner join sys.schemas s ON t.schema_id = s.schema_id ORDER by

Infographics: The evolution of Samsung’s Galaxy S flagship

Introducing Samsung GALAXY S 4

This is really looking like Samsung is building its own ecosystem. Looks like there is going to have more and more Samsung in-house apps and a growing personalisation going on in an Android phone.

Samsung S IV accessories announced

Samsung introduced together with the Samsung Galaxy S 4, 11 accessories for the Samsung Galaxy S 4. The accessories are: S Band, S View Cover, Game Pad, Wireless Charging Pad / Cover, Flip Cover, Pouch, Protective Cover+, Headset, Extra Battery Kit, HRM and Body Scale.

Most of the accessories can be used by Samsung’s S-Health 2.0 application.

» Accessories announced by Samsung for the Galaxy S 4 | SamMobile

McDonalds FREE 1,000 Egg McMuffin

McDonalds Singapore is participating its "National Breakfast Day" by giving away 1,000 Egg McMuffinTM absolutely FREE per participating stores, while stocks last, on 18 March 2013 (coming Monday).

How does it work?

McDonalds will give away Free Egg McMuffinTM Giveaway coupon at its participating stores on 18 March 2013. Recipients will then have to present the original coupon on the same day in the morning for redemption.

More information on the giveaway can be found at

List of known domain names blocked by Kaspersky products

I am putting across a serious note on Kaspersky products blocking domains including Google, Facebook and Twitter. From my experiment, it seems this is true when I am using Google Chrome browser. Have tried to contact Kaspersky via Twitter but am ignored completely. A quick web search on the world wide web reaffirmed that this is not affecting just me, but possibly thousands others as well.

The Kaspersky product I am using is Kaspersky Endpoint Security 8 with the latest database definitions installed as of today. I am not too sure if other Kaspersky variant products are having similar restrictions too.

Some of the confirmed legitimate domains blocked are the following:

Last Updated: 25 March 2013, 3:00 PM (GMT+8)

VictimDomainRemarkAdded onFacebook**Facebook photos15 Mar 2013Facebook**General website15 Mar 2013Get Satisfaction**Resources19 Mar 2013Google**Resources15 Mar 2013Google**Several Google services15 Mar 2013Goog…