Nik's Technology Blog

Travels through programming, networks, and computers

Have Anti-Spyware Utilities Become The Killer App?

In the past few days there seems to have been lots of excitement in the computer industry concerning Anti-Spyware utilities - Programs aimed at ridding peoples machines of troublesome and annoying programs.

Firstly Yahoo have launched a new version of their popular Internet Explorer Toolbar which adds an Anti-Spy utility right on the bar (available from I've installed this on a couple of machines to test it and it seems to be fairly successful, although I know of a few friends machines which would give it much more of a thorough test.

This afternoon, the mighty Microsoft launched a Beta version of their own Windows AntiSpyware software, available to all owners of Genuine Microsoft Windows.

This product has clearly come about from the acquisition of Romanian anti-virus firm GeCAD Software in 2003 and New York-based anti-spyware firm Giant Company Software in December 2004.

After installing an activeX component to validate your version of Windows(TM) you are taken to a download screen, where you can download the test version of their new software.

I'll be testing these anti-spyware tools in the coming weeks and will report my findings in the near future.

Microsoft(R) Windows AntiSpyware (Beta)

MySQL vs TSQL Concatenation CONCAT()

Following on from an entry posted last year concerning converting SQL queries from Microsoft TSQL to MySQL I've come across another function which is treated somewhat differently in MySQL than TSQL.

The following SQL code adds the .jpeg file extension onto the end of the image names from tblImages.

TSQL Concatenation

SELECT ImageName+'.jpeg' FROM tblImages

The above SQL syntax is used on Microsoft SQL Server, Microsoft Access and Sybase

MySQL Concatenation

SELECT CONCAT(ImageName,'.jpeg') FROM tblImages

Oracle Concatenation

SELECT ImageName || '.jpeg' FROM tblImages

The Oracle syntax is the syntax recommended by the SQL specification. It uses 2 pipes || instead of a plus + sign. This avoids the problems of trying to concatenate integer fields which might otherwise result in an unwanted addition.