19th - 21st November 2009

Celtic Manor, Newport

Platinum Sponsors
Microsoft
Training Day

To complement the great experience of the sessions on the Saturday we have partnered with some companies to provide training seminars on the first day of the conference (Thursday, November 19, 2009)

There are 5 seminars to choose from.

All the seminars are for a full day (9am til 5pm) with lunch and refreshments provided. The seminars are being held at the Celtic Manor. If you need accommodation then have a look at the details on the accommodation page


Introduction to MDX with Chris Webb

If you want to get the most out of your Analysis Servicescube it’s essential to know and understand MDX: you need it to be able to writequeries and calculations, and also to be able to use more advanced featuressuch as cell security. This one-day seminar, aimed at those with little or noprevious MDX experience, will teach you the basic concepts of the language aswell as show you how to write common queries and calculations.

Self Service Business Intelligence – making it real with Donald Farmer

With SQL Server 2008 R2, Microsoft is bringing “Self Service” Business Intelligence to a potentially huge audience of Office and SQL Server users. But what is “Self service” and how will it affect the roles of business users and IT professionals? In this session we explore the business cases, the technologies and the techniques of self-service BI in SQL Server 2008 R2. We’ll explore the background to these exciting technologies, and we’ll carefully cover the role of IT in securing, provisioning and sustaining the infrastructure required to bring the next generation of BI to the world of business.

 

Practical Performance Tuning and Monitoring for SQL Server with Jasper Smith

This training day will focus on two key areas, collecting and analyzing SQL Server performance metrics and Index Tuning. At the end of the day you will have the tools and knowledge toeffectively monitor your SQL Server environment large or small and to analyze and interpret the data to tune your SQL Server workloads

A Day of SQL Server 2008 for Developers with Rob Farley

SQL Server 2008 introduces many new exciting features for developers.
In this day long workshop we will have an in-depth look at some of these new features and see what they can do for us as developers. The agenda for the day looks like this:
We will start with looking at new T-SQL enhancements in SQL Server 2008 and what the can do for us as developers in order to become more productive and also get better performance from our code.
We then go on to look at changes in the type system of SQL Server 2008 and specifically the more“traditional” T-SQL types. We will look at how the changes are implemented and how we as developers can utilise these types to write as efficient applications as possible.
After lunch we start looking at a really new exciting feature in SQL Server 2008; Automatic Data Change Management. This is a lightweight solution that provides an efficient change tracking mechanism for applications and we will look at how change tracking is implemented inside SQL Server and how it can be used from inside applications.
Finally we will go outside the realm of relational data and look at the new spatial datattypes that was introduced in SQL Server 2008. We look at what theyare and how they can be used.

XML master class – using XML with SQL Server with Simon Sabin

In this seminar we will cover the end to end story of processing XML with SQL Server.

Throughout the seminar we will highlight the advantages and disadvantages of using XML at each stage along with the options available to you. This will focus on supportability, performance and extensibility. At eachstage we will also highlight how to use namespaces, most examples skip overthis area which is unfortunate as most XML documents contain namespaces of someformat. After this seminar you will be able to troubleshoot the commonnamespace situations you will encounter

Use of XML as an interface format is very wide spread and soyou will likely have to be importing or exporting XML documents at some point.This seminar will give you the tools you need to be able to achieve this andalso highlight many of the pitfalls you may encounter along the way.