Enforcing Workflow Through Relational Integrity
This session will look at a number of relational database
design patterns. Along the way we will investigate some advanced
relational integrity concepts as well as looking at a several possible designs
for recording history, giving a nod towards the world of Dimensional Modelling
in the process. After touching briefly on Trees and Hierarchies, we will
move on to examine ideas for enforcing a State Machine in the database without
the use of triggers, CLR assemblies and the like. Sounds like pure, old
fashioned fun for the whole family!
Andrew Whettam works as a Consultant for Information
Management Group and has previously led database teams for 3M and Capital
One. He works with both transactional and analytical databases and has
modelled, designed and developed database systems across a variety of industry
sectors, including a number of high profile government projects. He has
worked with all versions of SQL Server since SQL 7.0. Andrew holds
several Microsoft qualifications, including MCITP.
7:30pm – 8:00pm BREAK: Light refreshments
More time to network and ask questions...
8:00pm – 9:00pm What’s new in Analysis Services 2012?
AS 2012 sees Analysis Services splitting into two: the Multidimensional model, which is basically the Analysis Services of cubes and dimensions that we’re all familiar with, and the new Tabular model which is very similar to PowerPivot. This session will cover what’s new in Analysis Services 2012 Multidimensional, provide a brief overview of the Tabular model, discuss their relative strengths and weaknesses and help you decide which one is appropriate for your project.
Chris Webb is a UK based consultant (http://www.crossjoin.co.uk/) and trainer
specialising in SQL Server Analysis Services, MDX, PowerPivot and DAX. He is
the co-author of three books: “MDX Solutions”, “Expert Cube Development with
SQL Server Analysis Services 2008” and “SQL Server Analysis Services 2012: The
BISM Tabular Model”, and blogs regularly on Microsoft BI topics at http://cwebbbi.wordpress.com/.