Migrating MSDE 2000 db to MSSQL 2005 Express

Scenario :
An ASP web application in which the backend DBMS is running on MSDE 2000 SQL Server.

Objective :
Making the ASP web application to use MSSQL 2005 Express on to the server. On top of that database created on the MSDE 2000 Instance needs to be migrated over to the MSSQL 2005 .

Scope :
1. MSDE 2000 SQL Server instance name is localhostHELM , MSSQL db name HelmDb.
2. MSDE 2000 SQL Server instance is running at a non MSSQL default port (not 1433).
3. MSSQL Server 2005 Express is used.
4. Using default MSSQL Server 2005 Express instance localhostSQLEXPRESS .
5. OS used Windows Server 2003.

Workflow : Continue reading

How to prevent SPAM

Email, love them… hate them or loving them and hating them.

For most users email will means business deal, appointment, opportunity or simply a hello.

Unfortunately, as long as you are an email user, you will not be able to prevent SPAM.

That’s right no matter how expensive, how sophisticated  Anti-SPAM countermeasure which you has taken there is no way to prevent spam.

SPAM can only be reduced but not prevented.

The good news is, you need not to be a nuclear scientist to combat spam. User, which is us needs to follow this few simple steps :
1. Ty not to expose your email in internet, e.g. webpage,  forums, contact form.
2. Do not provide/write your email in query forms in exchange for freebies.
3. Use common sense, think like spammer e.g. ways to harvest emails or obtain email either ethical or unethical way.

The reason for step 1, spammers can use programs/bots to harvest email addresses from webpage, forums, contact us form.

The reason for step 2,  unethical person or some company makes money by providing biodatas in electronic as well as paper forms.

Lastly, use common sense, example do not betray your self with a cheap freebie. Nothing is free in the world 😛

P.S.: I lied, there is no way of preventing SPAM 😛 Only good practices to reduce spam ends in your inbox.