Case Sensitivity

I'm sure this can be changed by your friendly SQL Server DBA but worth noting that, by default, SQL Server databases are case insensitive whereas with Oracle you do need to distinguish between your P's and your p's!

For example when searching for the word 'Tower', the following line

SELECT *
FROM MyTable
WHERE name LIKE '%ToWeR%'

will bring back the row in SQL Server but NOT in Oracle.