Monthly Archives: May 2012

SQL Server 2005 Instances do not show up in Server 2008 R2

I updated my SQL Server 2005 to SQL Server 2008. Everything worked great. After a few weaks later, I tried to connect to the db in SQL Server Management Studio after I had restarted the PC and it won’t connect. … Continue reading

Posted in SQL Server 2008 | Leave a comment

Format date in Crystal Report

To format date in Crystal Report, the field must be date type. If the field is an integer and you want to convert this into day please see convert int to date in Crystal Report To format date in Crystal … Continue reading

Posted in Tutorials/Tips | 1 Comment

Convert Integer to date in Crystal Report

There is no function available to convert integer date into proper date format. The closest that I came across use a crystal field which take integer date and converts it only proper date format. Local StringVar y; y := CSTR({?end_date}, … Continue reading

Posted in Tutorials/Tips | 1 Comment

Addressing boss in email

How to address boss in your email? How to ask for a raise? Some great advice on email etiquette

Posted in Uncategorized | Leave a comment

Interview Questions

Q. You have a large file where you want to replace a lot of variable names. Fore example Jon skeet Alan Bradley Micheal Moore There are 500 entries. You want to remove the last name, how will you you do? … Continue reading

Posted in Uncategorized | Leave a comment

Remove anything after space in the same line – Regular Expressions

For example you have an SQL query like this create table ipn_trans( id int not null primary key auto_increment, txn_type varchar(100), charset varchar(20), custom varchar(255) ) You want to create variables for each of the field. The first think you … Continue reading

Posted in Software Development | Tagged | Leave a comment

Freedom is not a good thing

Freedom is not always a good thing There is a lot of hype that freedom is a good thing. Well this is true, freedom is a good thing, it is not always a good thing and can be a really … Continue reading

Posted in Uncategorized | Leave a comment