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 19993 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
http://sqlis.com/sqlis

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

Location:

Microsoft Office at Waverley Gate

http://www.microsoft.com/uk/about/map-edinburgh.mspx

Registration will be necessary as I have to submit registrations to Microsoft on Thursday morning.