Author: rocker8942

Use Sublime Text theme color in Visual Studio 2010

I started using Sublime Text since I went to the DDD event at Sydney, where all presenters were using Sublime Text as their main editor. Soon, I became a fan of it. Now I wanted to use its theme color on text editor screen in Visual Studio. Dark background with light font color may be… Continue reading Use Sublime Text theme color in Visual Studio 2010

MySQL: remove special character from DB field

UPDATE table_name SET `field_name` = REPLACE(`field_name`, ‘<‘, ”); UPDATE table_name SET `field_name` = REPLACE(`field_name`, ‘>’, ”); UPDATE table_name SET `field_name` = REPLACE(`field_name`, ‘”‘, ”); UPDATE table_name SET `field_name` = REPLACE(`field_name`, ‘%’, ”); UPDATE table_name SET `field_name` = REPLACE(`field_name`, ‘;’, ”); UPDATE table_name SET `field_name` = REPLACE(`field_name`, ‘(‘, ”); UPDATE table_name SET `field_name` = REPLACE(`field_name`, ‘)’,… Continue reading MySQL: remove special character from DB field

Quick ways to check SEO friendliness of website

Useful web to make a report on SEO readiness. 1. http://www.woorank.com/ Free for one report only for a week. For this reason, I’ll move over to the alternative that’s ‘grader’. 2. http://marketing.grader.com/ Free for unlimited sites. Good thing about these is the report is including advices to how to improve the SEO friendliness. 3. http://www.google.com/analytics/ Basic of… Continue reading Quick ways to check SEO friendliness of website