San Francisco, California
London, United Kingdom
Welcome to Southampton SQL Server User Group, this event is hosted at St Andrews United Reformed Church located on the corner of Alma Road and The Avenue.
Please be aware that in order to attend we need you to register in advance as there is limited space and we need to know how many people to order pizza for, thanks :-)
We have a couple of great speakers covering different SQL Server based topics along with a number of prizes to give away and free pizza during the break.
18:15 - Doors Open
18:30 - Introductions
18:45 - David Conlan - SSRS - The Dark Side: Custom Rendering
For those with the time, programming expertise and willingness to get their hands dirty, Microsoft provides a mechanism to write your own custom rendering engine for SSRS in .NET. Whether you want to create an interactive, self-service dashboard or a mechanism for exporting to Open Document Format, David will talk you through the stages required to write and implement your own renderer.
The first part of this session will focus on how reports are rendered. David will describe the Report Definition Language Specification and how to access the Report Object Model .NET API.
However, creating an individual custom rendering engine is a mammoth task. Therefore the second part of of this presentation focuses on how to leverage Microsoft's existing HTML renderer to deliver enhanced reporting capabilities. By taking a short-cut you will be able deliver some quite impressive new features and breathe life back into those online reports.
19:45 - Break
20:00 - John Mathews - SSIS - From the Asynchronous to the Synchronous
When moving SSIS from large on-premise servers to Azure VMs, CPUs and memory become golden commodities as the budgets move from capital expenditure to operational expenditure. This means simply throwing extra hardware at SSIS is no longer possible meaning that performance becomes a design time issue.
SSIS dataflows consists of both synchronous operations, which perform inline data transformations or add additional columns to each row, and asynchronous operations, which significantly modify the shape, scope or order of the rows. Asynchronous operations such as sort or aggregate are sometimes referred to as fully-blocking since they need to receive all of the rows before they can start to deliver rows downstream. In fact every transformation is a blocker since each one takes a finite amount or resources and time to perform its function. The performance goal is to minimise the resources and time taken by greedy transformations since a pipeline's overall performance is governed by its worst performing transformation.
This talk covers strategies that can be implemented using Script Component, in C#, that can be used to:
• Single pass de-normalised data to extract both dimensions and measures
• Perform alternative lookups whilst maintaining the order of rows being processed
• Reduce the memory resources required by SSIS's sort and aggregate dataflow transformations
• Speed up complex SQL queries that perform expensive cross joins
• Provide a technique for bulk loading partitioned tables within SQL Server.
BIO: 25 years database experience starting off with Informix in 1990 then concentrating on SQL Server since 2003 and C#/.NET. Worked on various projects ranging from data capture and reporting for mobile network optimisation, 4G network simulators and now as a database team lead at Centrix Software usage base IT estate management using SQL Server 2012, SSIS and OLAP. Migrating on premise solution to Azure VMs and Azure Databases has resulted in having to develop novel solutions for SSIS to process data using less resources than a typical on premise server as well as creating a domain specific generator to construct MDX queries.
21:00 - Prize Draw & Close
21:15 - Event close
A massive thanks to our sponsors, without them we would not be able to host this event for free.
When & Where
Southampton Data Platform User Group
Southampton Data Platform user group has been running since 2010, in that time we have had many speakers both local and international present high quality sessions on a range of SQL Server and data platform topics. We aim to deliver high quality training and insight for free to the SQL Server community. We meet on the first Wednesday of each month (except January).
The user group has been run by John Q Martin (Twitter | LinkedIn) & Steph Middleton (Twitter | LinkedIn) for the last four years, in which time we have seen the group grow significatly with members joining and moving on.
We are sponsored by SpectrumIT who are a local recruitment company, setup by recrutiment agents who have helped us by providing the location, Pizza and an Amazon voucher to raffle off each meeting.