Search Engine Optimization

Nowadays Google, Yahoo! or the other search engine being essential part of our life. Every single thing that we need, first thing we do is search about it on those search engine. So when we have product to promote or to sell, all that we need is when people typing on Google about our product or product categories, on the result  our product is the top of the list (being number one)  or at least on page one.

the biggest Question is HOW TO DO IT?

There several things we need to do. Do not ever believe on people or company that promise you they can do it instantly. Several company promise they can increasing traffic to your website twice or even threefold. Actually, they just sending robots to your website and would be burdensome  to the network with those robots, and maybe can effect decreasing traffic from your target costumer.

SMTP setting on IIS7 and PHP

Since my new role on the new office made me to have more contact with PHP and IIS,

i will try to share some trick and tips to bridging those two platform

This week I spend more than two days to figuring out how to using PHP mail function under IIS7

previously I have configure phpmail setting under xampp platform, on that platform you only need to make sure PHP.ini and sendmail.ini is working good.

but on IIS you need to install smtp service on the server.

and Finally I found this GREAT tutorial from LEARN.IIS.NET

Fyi LEARN.IIS.NET is very reliable website for you that want to search anything.. yap anything about IIS especially IIS7

so this is the problem. I need to have my email notification from TYPO3 to be work on my IIS server, my email server is on the other location and it need login authentication (username and password).

first of all, you need to check php.ini configuration

Call to undefined method com::GetRandom()

Starting now on we will also to talk about TYPO3! *typowhat?* yes, since sometimes ago i have to worked with this CMS. Typo3 is very popular  CMS in europe.

However this is my fist post about error on typo3, i just upgrade my pc, from xp to win 7, then i restore all the web application that i already create on Xampp.

and I got this error “PHP Fatal error:  Call to undefined method com::GetRandom()” from php error logs.

This problem occurred related to COM library (CAPICOM) that accessed by windows. All you need to do is re-install the  from here and re-register that library using regserv command. example

regsvr "C:\Program Files\Microsoft CAPICOM 2.1.0.2 SDK\Lib\X86\capicom.dll"

and Voila.. this error will disappear.

PDF View issue on Server 2008 IIS 7

Did you know that Microsoft did some blunder (again), its happen on they new web server system (IIS 7  and Server 2008) because some reason it have problem when displaying PDF from webserver, its only appear when visitor view it on the browser, if the chose to download it, the problem will not occurred.

From webmaster view its just like a curse, because all that you wanted is upgrade the system environment but what you got is a hell. And unfortunately Microsoft guys did not sure this was they problem and blamed adobe about this problem.

After several time (very longggggg time from user view) Microsoft have release the fix. you can download it from here.

as far i know this hotfix is work to fix that issue.

Credits to this post

 

How to import big mysql dump file

How to import a big dump v file to your database? Phpmyadmin is the common tools to import database on mysql, but dumping a big file it need a loot of effor to do on it.

Actually we can do it without using any tools and believe me it is easy to do.

1. You need to open mysql using command prompt
2. Connect to the mysql using the user name and password
3. Connect to the database

   USE`database`
   

   where ‘database’ is name of your database

4. the next thing to do is import the dump file, the fastest way is using ‘source’ command and point it to your physical path of sql file

   source D:\data\source.sql
   

5. Taraaa… that ‘s  it..

The other knowledge command that you might need is information about mysql variable setting  and you can use this command to view and set the mysql variable setting

show variables;

# With this command can help you to check values of mysql setting

set @@GLOBAL.max_allowed_packet = 1048576000;

#With this command, you can set the variable values

Shrinking database script

—1. backup database

—2. untuk menjalankan sp_dboption dengan parameter-parameter tertentu di belakangnya

EXEC sp_dboption EPC, ‘trunc. log on chkpt.’, ‘TRUE’

go

—3. untuk checkpoint database

use EPC

checkpoint

go

—4. shrink database

—notes : 10 adalah angka yang memberitahukan kepada DBCC SHRINKDATABASE untuk menyisakan 10 persen dari file log yang ada sekarang. Ini berguna untuk database sendiri biar ntar setelah di-shrink masih bisa auto-growth.

DBCC SHRINKDATABASE (EPC, 10)

Connecting sqldatasource with mysql in VS 2005

download odbc here :

http://dev.mysql.com/downloads/connector/odbc/

MySQL by using a ODBC 5.1.6  connection string:

web.config:

aspx:

…
<asp:SqlDataSource ID="Apts_srcddnCity"
ConnectionString="”
ProviderName=”"
SelectCommand=”SELECT DISTINCT AptCity FROM tblApt;”
runat=”server” />

JQuery

JQuery is powerfull javascript library function that can subtitute flash app on our website.

Like the tagline say “Write Less Do More”..

I’ll write it later then..

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding

This is a error information causes by connection between MSSQL and VS.

MSSQL query respond time take more than VS expected.

People usually thing this is a web.config setting issue, but when you update timeout setting on connection string, this error still appear.

Script for Backup

This Script Can help MSSQL programmer to create Procedure for back up plan

Declare @Location varchar(200)

SET @Location = ‘C:\SQL Backup\’ + cast(Year(getdate()) as varchar(4)) + ‘-’ + Right(’00′ + cast(Month(getdate()) as varchar(2)),2) + ‘-’ + right(’00′ + cast(day(getdate()) as varchar(2)),2) + ‘_dbname Backup’
BACKUP DATABASE [DBNAME] TO DISK = @Location WITH NOINIT , NOUNLOAD , NAME = N’dbname -Full Database Backup’, SKIP, NOREWIND, STATS = 10

GO

furthemore, DBA can create sql job and scheduling job to do maintenance plan using this script.

MSSQL 2005 provide maintenance plan embedded, but don’t know why, i do create error using maintenace tools