Southampton SQL Server User Group
Network, learn, ask a question, meet other folk, get fed - these are all things that happen at user group events. These events are a really great opportunity to socialise in an informal learning experience.
Remember to tell your friends and the people you work with; make sure you register as soon as you can.
6.00pm - Networking / Biscuits
6.30pm - Introduction
6.45pm - Alex Whittles (@PurpleFrogSys)
Title: Mergetastic - A better way to load dimensions in SSIS.
In this session we’ll look at how T-SQL Merge can be used to perform complex multi-stage tasks such as loading data into data warehouse dimensions, including the handling of type 0, 1 & 2 slowly changing dimensions.
I’ll present a summary of my MSc dissertation findings, comparing the performance of using T-SQL Merge against other more traditional methods of loading data warehouse dimensions in SSIS.
We’ll also look at how we can use simple metadata configuration and dynamic SQL to completely automate the generation of the merge statement, resulting in an incredibly simple meta-data configurable data warehouse platform.
7.30pm - Pizza
8.00pm - Chris Testa-O'Neil
Title: Deploying Highly Available BI Environments
This one hour session will provide insight on what to expect when deploying a highly available end to end SQL Server 2012 Business Intelligence environment as experienced from the field. As well as leveraging the SQL Server Business Intelligence skills that you possess.
You will also gain an insight into the additional skills and knowledge that you will need to ensure the successful delivery of technologies such as such as PowerPivot, PowerView, SQL Server Reporting Services and SQL Server Analysis Services on a robust architecture.