A very nice keyboard concept!

Hi all!

Just saw this one...
Imagine a keyboard that has a screen under each key! :)

You can change the language of the keyboard and the "printed" letters will change!
Better yet, assign actions to keys and the tool icon will appear on the key!!!

Here's the product page: http://www.artlebedev.com/everything/optimus/

I won't say the price so I won't spoil the excitement but it's still a very "geeky" tool hein?

Getting the file extension on SQL Server

Today I had the need to get the extension of a file name I have stored on a table column.

Googled it a bit and ended wrapping the concepts I've found and making my own solution:

REVERSE(SUBSTRING(REVERSE('filename.pdf'), 0, CHARINDEX('.',REVERSE('filename.pdf'))))