Archive for June, 2007|Monthly archive page

Sorry Freddy

This weekend saw the end of term party for the Wellington Community Choir. T’was a great night all told and was good to see people in a different light. Turns out the event was a Karaoke night. Jordan was in heaven. She must have done 5 or 6 songs, and held her own in the most part (I guess that only has relevance if you know the standard of everyone else there :p).

I too can now no longer say I am a Karaoke virgin. Three others and myself (no names, no pack drill) did a successfull slaughtering of *ahem* “Bohemian Raphsody”. I am so sorry Freddy. In fairness we did alright. With a few “awesome”s and a fair few cheers and rounds of applause throughout and at the end. All told, good fun really.

Advertisements

SQL Server and Trade Me

I went along to the Wellington SQL Server Users Group this evening, where we heard a great talk by a guy named Paul Gold.
Paul was the technology and database architect for www.trademe.co.nz, New Zealand’s equivalent of E-Bay, from 2001 to 2007, so he has seen the business basically from start up to its current position in the top 5 sites in Australasia, Alexa rates this site 436 in the world!
He had some very interesting things to say about performance issues, from both a SQL and an IIS perspective, when you get into high volume transactions as well as database structures and server farms / clusters.
I would say that my eyes have opened a little to the different requirements in database design when you need to do serious performance without doling out serious investment to do it – and how much denormalisation and removing expensive SQL commands can impact it (for expensive commands see OR and IN clauses and aggregates as given examples).

A most informative speech well worth the time. And hey – we got pizza too.

Anyway – the group meets every 3rd Thursday of the month. Last months talk was a very good talk on the new SQL Spatial enhancements for SQL 2008. So there looks to be a good variety of speakers. Watch this space for more updates.