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:15 - James Anderson - Columnstore Indexes
Columnstore indexes have the ability to improve the performance of analytical queries operating on large datasets by orders of magnitude. Without an understanding of their internal structure you may not be getting the most out of them.
In this session I'll briefly cover how columnstore indexes store their data and then quickly get into the interesting stuff like compression, batch mode and data dictionaries. I'll also cover some of the common issues such as row group pressure and processes not using batch mode. If not addressed these issues can dramatically impact query performance. There are many limitations in the SQL 2012 implementation that are alleviated in 2014 and 2016 but these versions bring their own set of complications and problems that I will discuss
19:45 - Break
20:00 - Gavin Payne - How to design and benefit from cloud data platforms
Many digital businesses now have a cloud-only approach to innovation, with most others promising themselves they won’t be too far behind. The reality is though that the expected benefits of a move to the cloud - new capabilities and rapid innovation - depend on having a solid data platform. There needs to be somewhere that applications can store the information they collect and where analytics systems can generate knowledge to share. The capabilities of the Microsoft cloud data platform have never been deeper or broader. It now supports cloud only and hybrid deployment models, structured and non-structured data, and operational and analytical workloads. The question being asked now is how to use the Microsoft cloud data platform rather than when or if.
This session discusses:
• The services in the Microsoft cloud data platform
• How to design solutions to play to their strengths
• The benefits you should and shouldn’t expect from using them
21:00 - Prize Draw & Close
21:15 - Event close
James is a SQL Server production DBA for HTEC in Southampton. I work on multi terabyte databases that provide the backbone for many large scale loyalty reward schemes in the UK and Europe. I have been working with databases since 2008. The first and worst RDBMS I worked with was Paradox. I quickly moved to using T-SQL in SQL Server 2005 and I have worked on every version of the product since. I enjoy query tuning and server optimisation. I detest transnational replication. I blog at TheDatabaseAvenger.com and tweet from @DatabaseAvenger
Gavin is Coeo's head of digital transformation and defines how it supports its customers as they transform into digital businesses. He uses his background as a principal data platform architect to create new Coeo services that will help its customers use digital technologies, such as cloud data platforms and advanced analytics solutions, to support their transformation. As well as his commercial strategy role, Gavin also provides guidance to Coeo's customers and presents at industry events about Microsoft data platform technologies. He is a Microsoft Certified Architect and a Microsoft Certified Master for SQL Server.
A massive thanks to our sponsors, without them we would not be able to host this event for free.
SpectrumIT kindly provide funding for the room pizza and a £20 Amazon Voucher.
Pluralsight kindly provide two one month free passess to their Excellent training content.
|Redgate kindly provide swag, licenses and help source speakers.
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.