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.

Advertisements

No comments yet

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: