Come and socialise and learn from your peers; these physical meetings are great places to expand your network, get answers and find out how other people are using SQL Server and what is going on.
If you want to twitter please make sure you use the tag #uksqlug so it is shown on the site.
18:00 - 18:15 Meet & Greet
Meet up and socialise with your friends, meet new people, find out what other people are doing with SQL Server.
18:15 - 18:30 Round Table Discussion - Q & A from and to the audience
Bring your SQL problems and hopefully somebody within the room will be able to fix or advise you. There is always a wealth of experienced people at the user group meetings.
18:30 - 19:30 Implementing common business calculations using DAX
Chris Webb, SQL Server MVP
When you come to use PowerPivot in a real project, you'll need to know how to write calculations in DAX, PowerPivot's own calculation language. This session covers the basic DAX concepts and then describes how to implement common business calculations such as year-to-dates, previous period growths, and distinct counts.
19:30 - 20:00 Break
20:00 - 21:00 Case Study
Andrew Sadler, Hitachi consulting
Case Study: Come see how Square Enix have used SQL server to deliver player leaderboards and gamer stats for their recent game release JustCause2 - http://www.justcause2.com . JustCause2 is a very popular game (currently approx 700,000 unique players) which incorprates some significant internal metrics. Hear about the challenges of aggregating 7 billion rows of data, and how this was achieved cost effectivrly.
i think the agenda would look something like this:-
- Brief intro to Square Enix/Eidos
- Brief History of OnLine metrics (why/who for/use/etc)
- Just cause 2 Metrics Project
- The data lifecycle
- Demo of full metrics life cycle