Posted in System Admin on April 5th, 2009 No Comments »
IE8 came out not long ago and I just installed it and try it out
knowing that I would care much about its new features. But I was disappointed the first time I used it after installation. I went to Google Map it didn’t work and I went to Yahoo Map it didn’t work either. […]
Posted in SQL Server on April 5th, 2009 No Comments »
The other day when I installed SQL server 2000 on a 64 bit
machine a dialog box pop up and said I couldn’t install SQL server 2000 using the current installation program and and I had to use another executable under a different folder to do installation. Later on a person asked me whether the […]
Posted in SQL Server on April 2nd, 2009 No Comments »
Well it took me a while to figure out the easiest way to connect to a SQL server listening on a non standard port. The standard sql server port is 1433. When you connect
to SQL server using enterprise manager or Query Analyzer this is the port the tools automatically connect to on the server. […]
Posted in System Admin, Technology on March 5th, 2009 No Comments »
If you are brought to this post from search engine then most likely you are looking for a way to get rid of the virus or malware infected your PC or you want to make your disk defragmenter works.
I didn’t remember since when I start feeling my internet connection did not work as fast as […]
Posted in Programming, SQL Server on February 25th, 2009 No Comments »
I was looking for a way to find the first occurrence of 4 digit year in a column containing free from text. The first thing I think of was to use regular expression. I did some research and came up with the following function. Once the function is created it can be used like […]
