MSSQL has the function called backup & restore, which is useful. It works fine between different versions. But, if you need to restore from script.sql, you can do it on command line. sqlcmd -S <server> -i C:\<your file here>.sql -o Full explanation : Link and Sometimes connection string can be tricky. You can get full help… Continue reading MSSQL backup & restore using script.sql
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
Best PHP IDE for junior php developer
PHPStorm Many said this is the best, but cost $99 for individual purchase. NetBeans 7 I just started to use it. My verdict is 10 out of 10 at least for now. The big difference between Netbeans and Eclipse PDT is that you can do pretty much all you need to use just out of the box,… Continue reading Best PHP IDE for junior php developer
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