We are fortunate enough to have an opportunity to grab Rob Farley for an afternoon. Fortunate as he lives in Australia and is in the UK for a short period of time.
Rob Farley, a mentor/trainer with Solid Quality Learning, has been consulting in IT since completing a Computer Science degree with first class honours in 1997. He lives in Adelaide, where he heads up the Adelaide SQL Server User Group and sits on the South Australian Branch Executive Committee of the Australian Computer Society. He holds several Microsoft certifications including MCSD, MCDBA, MCTS, MCPD and MCITP. He is a Microsoft Certified Trainer and is a recipient of the Microsoft MVP Award for SQL Server. He blogs at http://msmvps.com/blogs/robfarley
Registration is at 2pm, talk will commence start at 2:30pm and finish 5:30pm
2:30pm - 3:00pm Round Table Discussion
Update on what's been going on and is going on in the SQL Server space.
Bring your SQL problems and ask the audience, bounce ideas - anything related to SQL Server.
3:00pm - 4.00pm Understanding the OVER clause in SQL 2005
SQL2005 introduces the OVER clause to T-SQL, and with it, ranking functions and windowing. Ranking functions, particularly the row_number() function, give database developers a lot more flexibility to solve many problems. And the windowing features of the OVER clause not only allow new solutions to old problems, but can allow a much higher level of query-optimisation than before. In this session, some of the uses of this new functionality will be explored - demonstrating some of the ways in which problems can be solved more easily and efficiently.