Maidenhead SQL Server User Group
Speakers to include SQL Server Alex Whittles and John Martin.
18:00 - 18:30 - Registration, Intro, Round Table discussion, Nuggets etc.
18:30 - 19:30 - Session by Alex Whittles
19:30 - 19:45 - Possible Sponsor Session
19:45 - 20:00 - Refreshments
20:00 - 21:00 - Session by John Martin
Alex Whittles - Data Modeling for Analysis Services Cubes
Abstract: Analysis Services OLAP cubes provide an incredibly powerful platform for the analysis and reporting of complex data. Unfortunately we often find that our source data is not in the right structure to make the best use of the cube’s power. This limits the cube’s functionality, compromises performance and complicates the reports.
In this session we’ll look at a number of different data scenarios that we encounter and explore ways of remodelling the data to optimise it for cubes and MDX. We’ll see how adding functionality into the ETL layer can have a dramatic effect on the functionality and simplicity of the cube.
John Martin - SQL Server, the DBA and Compliance
Abstract: Compliance is something that we are all having to deal with and this is only going to increase with heightened privacy concerns and due diligence requirements in business. This session will cover three of the main areas that you are likely to have to deal with; Payment Card Industry - Data Security Standard (PCI-DSS), Sarbanes Oxley Act (SOX) and the UK Data Protection Act 1998 (DPA). I will look at what these standards are for and how they sometimes conflict. Information Heavy and Demo Light, this session will help you identify what you need to keep an eye on and I will show a couple of options on how to monitor who is doing what with your data.
Location: Maidenhead, Berkshire