Check if a SQL Server database exists or not (TSQL)

No Comments » by Jon Hibbins on 1 August 2008
Filed under: Code, Database, MSSQL2005, SQL Server, Software Development, TSQL

Here is a usefull TSQL Script for checking if a database exists :

– Check if the Database Exists
DECLARE @DatabaseCount AS int
SELECT @DatabaseCount=COUNT(*) FROM master.dbo.sysdatabases WHERE name=‘master’
SELECT @DatabaseCount AS [DatabaseCount]

Iron Man – Great film

No Comments » by Greg Hibbins on 4 May 2008
Filed under: Uncategorized

Just went to see ’Iron Man’ yesterday – this was an excellent film!!! Best so far 2008,  really enjoyed this. Robert Downey Jr was better then expected, Jeff Bridges was good – the CGI was the best I’ve seen since ‘Transformers’ , just blew me away.

hibbins.com top movie list

No Comments » by Jon Hibbins on 24 November 2007
Filed under: Uncategorized

Every year at this time we seem to have a DVD rental subscription to get us through the winter, this year we are with Lovefilm, and they have the ability to create movie lists, so here is the hibbins.com top movies ever

Ban motors

1 Comment » by Jon Hibbins on 14 November 2007
Filed under: Uncategorized

Not cars but motors that power hard drives!, and replace them with a 64mb Solid State Disk, Samsung (among others I’m sure) state that their drives are High-Performance, Low-Power, Light, Rugged and Reliable. So far tapes and CD’s and maybe even DVD’s and HD-DVD’s/Blue ray will become a classic device and any electronic device with moving parts just won’t hack it anymore, I wonder how long until the car engine becomes solid state?

Funniest joke on the internet 2007

No Comments » by Jon Hibbins on 6 November 2007
Filed under: Uncategorized

This year CNN.com state that the funniest joke on the Internet is :

Two hunters are out in the woods when one of them collapses. He doesn’t seem to be breathing and his eyes are glazed. The other guy takes out his phone and calls the emergency services.

He gasps: “My friend is dead! What can I do?” The operator says: “Calm down, I can help. First, let’s make sure he’s dead.” There is a silence, then a gunshot is heard. Back on the phone, the guy says: “OK, now what?”

Amy The Persian Cat

No Comments » by Jon Hibbins on 26 October 2007
Filed under: Uncategorized

A close up of our cat.. Amy

50mm prime lense is the way to go

No Comments » by Jon Hibbins on 13 October 2007
Filed under: Uncategorized

Gary Voth says we should get a 50mm prime lens for our digital cameras, and so do many other camera professionals, to quote Gary:

“If you are like most photographers just starting out with a new 35mm SLR, chances are it came with one of those ubiquitous 28-80mm (or similar) “consumer” zooms. In the last 15 years these inexpensive lenses have all but replaced the traditional 50mm prime lens as the starter optic for 35mm photographers. The 50mm lens, once the mainstay of 35mm photography, has been all but forgotten by today’s photographers.”

So it looks like i made a great choice with my new primary lens the Sigma 30mm f/1.4 EX DC HSM Lens (approx 50mm DSLR Equivalent), for me the results speak for them selves

Wallaby Side On

No Comments » by Jon Hibbins on 8 October 2007
Filed under: Uncategorized

Many more pics on flickr, but this is one I took this weekend on my new lens

Excelent DSLR camera review site

1 Comment » by Jon Hibbins on 23 September 2007
Filed under: Uncategorized

Digital Photography Review has a very comprehensive review of my new Canon 400d, I have continued to be impressed with the pictures I have managed to take, even more with the fact I have managed to move from auto modes to program modes and actually start taking even better pictures!!! Canon 400d Front View

Human Eye’s “megapixel” Resolution

No Comments » by Jon Hibbins on 21 September 2007
Filed under: Uncategorized

Apparently a human eye has around 5 million cone receptors that detect colour and around hundred million rods that detect monochrome contrast which is about 105MP per eye, however you have 2 eyes and they are shaped with in built image processing, in perfect light and with perfect eyes (both not likely with facts like “Women have more cones than men”) your eyes pick up and give your brain a MP image of :

Approximately 210mega-pixels capture that your brain turns into an approximately 550 mega-pixels image