I had to laugh at a comment on a Connect item suggesting SQL Server needed to "keep up" with MySQL.
March 2008
While <> and != behave the same, there is one reason you may want to use the former instead of the latter.
Big customers have big influence : see how some of the upper limits have changed in SQL Server 2008.