Recent SQL 2005 Events in Melbourne

I have been to a couple of events in the last few weeks and have been a bit slack in getting information up here about them.

I went to the SQL Server User Group meeting in Melbourne and heard a talk from Itzik Ben-Gan from Solid Quality Learning about uses for row numbers and specifically how the new Row Number function in SQL 2005 makes these techniques a whole lot easier to implement. The one standout demo for me was where he showed how you can use row numbers to calculate median values, with just a single scan of the table in question. It basically revolved around calculating an ascending and a descending row number and then averaging the value where the difference between the two row numbers was less or equal to 1. It takes a bit to get your head around this, but trust me it works, hopefully the code samples will be available on soon.

I also met up with Thomas Williams there who blogged about this event weeks ago - Hi Thomas :)

The local MS office is also running a number of SQL 2005 sessions, the most recent one was on the BI features. Not surprisingly we ran out of time, there was a lot of interest in Reporting Services and some of the new features in Analysis Services, particularly the proactive caching feature. This stuff really rocks, I have two potential projects for AS 2005 in the pipeline and can't wait to get into them. 

There is another event coming up on November 22nd, about Developer productivity enhancements in SQL 2005, if you are interested you can find out more details here.

Print | posted on Friday, November 11, 2005 7:07 AM

Comments on this post

# re: Recent SQL 2005 Events in Melbourne

Requesting Gravatar...
Hi Darren, thanks for the shout-out! I too was impressed with Itzik's implementation of the median function using row numbers, I had to tell it to basically anyone who asked (even my wife, who didn't ask)!

See you at the next meeting,

Left by Thomas Williams on Nov 14, 2005 8:39 AM

Your comment:

 (will show your gravatar)