18:30 - 19:00 - Introduction, Networking and Food
19:00 - 20:00 – Implementing Hierarchies
Tony Rogerson SQL Server MVP, http://sqlblogcasts.com/blogs/tonyrogerson
In this session Tony will show a number of techniques for implementing hierarchies using relational methods with T-SQL, non-relational methods will also be reviewed specifically XML and HierarchyId. Aggregation problems will also be discussed as well as dealling with multiple hierarchies.
Tony Rogerson has been working as a developer/database professional since 1986 working mainly with DB2, since 1993 he has worked with Microsoft SQL Server. He went freelance in 1997.
20:00 - 20:10 - Break
20:10 - 20:50 – Complex Event Processing (CEP)
Allan Mitchell, SQL Server MVP
StreamInsight is Microsoft’s first foray into the world of Complex Event Processing (CEP) and Event Stream Processing (ESP). In this session I want to show an introduction to this technology. I will show how and why it is useful. I will get us used to some new terminology but best of all I will show just how easy it is to start building your first CEP/ESP application.
20:50 - 21:00 - Close
Microsoft Office at Waverley Gate
Registration will be necessary as I have to submit registrations to Microsoft on Thursday morning.