SQL Soton UG Meeting - Apr 6th, 2016
Wednesday, 6 April 2016 from 18:30 to 21:00 (BST)
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 - James Anderson - Source control for the reluctant DBA
Are you developing database solutions for applications? Use utility databases to manage your instances? Do you work with script libraries, SQL Agent jobs, PowerShell scripts, batch files? All of these need to be centralised, version controlled and made available to all members of your team. I'll show how easy it is to setup source control (GitLab) and tooling to achieve this goal. Scripts are easy; the difficult part is database deployments. ReadyRoll is the new Redgate tool and I think surpasses their old SQL Source Control tool in every way. I'll demo how this tool can be used to easily generate a package containing all of your database changes instead of enduring the pain of manually creating migration scripts.
19:45 - Break
20:15 - Simon Whiteley
It's time to face the fact that Data Warehouses, as we know them, are changing. The increasing power of automatically scaling systems and the rapidly dropping cost of storage are challenging how we decide which data to keep and how we push it out to those who need it. In this session we'll run through the architecture of the modern warehouse, from our structured/unstructured Azure Data Lake architecture to our platform as a service Azure Data Warehouse and the various tools bringing the two together. Expect a general overview of these new Azure components, a little BI theory and practical demonstrations of setting up Data Lake, writing U-SQL, linking up Data Warehouse and exposing data to users, all from the ground up (demo gods permitting)
21:15 - Prize Draw & Close
I am 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
Principal BI Consultant with Adatis. Simon has been working with the Microsoft BI Stack for a decade, starting off building traditional warehouses with SSIS and SSAS but bringing in alternative technologies where needed. Simon is a strong advocate of the use of modern development practices in the SQL World (we actually are developers, whether we like it or not). Most recently, he has turned his head to the clouds, advocating new methods of getting insight to the right people. Whether it's getting to grips with Data Lakes or shifting your current SSIS packages into the cloud, hopefully he can help.
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.
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.