Out with the old and in with the new. I finally decided to update my blogs look and feel. So jumping on the band wagon of web 2.0 icons, I started to re-design the site.

And here it is! It’s taken me about 30 hours of work and lots of late nights, but I’m quite happy [...]

Something I needed today… I wish this was standarized, but it is not, so here are some examples:
SQL Server:

SELECT TOP 10 product, descr, email
FROM products

ORACLE:

SELECT product, descr, email
FROM products
WHERE ROWNUM

The cult classic where Mr Benn is an ordinary man who goes to an unusual Fancy Dress Shop where he tries on an outfit and as if by magic he enters a world of adventure. The complete series plus a brand new episode.

Relive the classic programmes of your childhood or introduce this fantastic series to [...]

Sometimes I’ve had the need to use SQL to go and get table information i.e is a field varchar or int etc.

For MS SQL server you can use the following to get info on a table

SELECT RIGHT(syscolumns.name, LEN(syscolumns.name)) AS dbFieldName, systypes.name AS typename, syscolumns.length AS maxlength, syscolumns.xprec AS [precision], syscolumns.xscale AS scale, syscolumns.isnullable AS isnullable
FROM [...]

Instead of using a graphic image (jpg or gif) it is possible to display a nice tick.

Use the following CSS and special character code:

The Css

.tick {font-family: Code2000, TITUS Cyberbit Basic, Doulos SIL, Chrysanthi Unicode, Bitstream Cyberbit, Bitstream CyberBase, Thryomanes, Gentium, GentiumAlt, Visual Geez Unicode, Lucida Grande, Arial Unicode MS, Microsoft Sans Serif, Lucida Sans Unicode;}

The [...]