Actions and Detail Panel
Leeds SQL Server User Group - 20th April 2017
Thu 20 April 2017, 17:30 – 21:00 BST
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 - if you want your own exposure then come and do a 1 - 5 minute nugget in front of your peers.
Remember to tell your friends and the people you work with; make sure you register as soon as you can.
17.30 – 18:00 Registration and networking
Meet and greet.
18:00 – 18:50 - Columnstore Tour – How & Why it can make your Database Faster
Speaker: Neil Hambly, SQL Server & BI Practice Lead Northdoor PLC
Taking a guided tour into the world of Columnstore indexes, you will gain an understanding of the key differences to traditional row-based indexing and storage; discover how this can benefit the performance of the database and when and where you should consider applying it. As we go deeper into this new feature we will look at a real world Columnstore index implementation project.
Neil Hambly is the Founder, CIO & Consultant @ DataMovements Limited (MSFT Data Platform Partner), previous roles @ Northdoor PLC, ABN AMRO, Accenture, ASOS, BBC, Confio Software with 18+ years in SQL Server roles Presented 150+ events, including 50 PASS Summit/24HOP/Rally/SQL Saturday, 20 European events (12 countries), 50 + UK (SQLBits, SQLRelay) Leader of PASS London (UK) & Professional Development VC, Melissa Data MVP (2015)
SQL Cruise Technical Lead, Likes Guinness, Loves Whisky, Dancing
18:50 - 19:40 - Azure SQL Data Warehouse
Speaker: Paul Duffett
Summary: My session will be on Azure SQL Data Warehouse. I will look to dispel some myths, take a deep-dive into the architecture and share some best practices. By the end of the session I am hoping to have changed your perception on what, on the face of it, seems to be a "Data Warehouse" product. All is not what it seems.
About Paul: Paul's married, with four (yes, 4!) daughters and by the time you are reading this he will have added a son to the collection, which is now finalised! This year, on the 5th of September to be exact, he'll be celebrating 30 years in the data+tech industry. He has an MSc in Business Intelligence from the University of Dundee and a bunch of MCPs mainly in SQL Server (Having been a DBA for many years) but more recently "Designing and Implementing Big Data Analytics Solutions". In April 2016 He was assimilated into Microsoft as a Data Solution Architect on the Azure Platform and as part of the collective hasn't slept since.
19:40 - 20:00 - Break
Time for pizza
20:00 - 20:50 - Faster Provisioning with SQL Clone
Speaker : Richard Macaskill, Product Manager Redgate
Database provisioning requests are the bane of many DBA’s working lives. Developers want to work with realistic data, DBAs want to protect Production and secure data. But copying databases for development and test is a job that gets 'delegated up'; DBAs, IT Managers, those with the keys to Production find themselves performing the task, and the development team is often blocked while it takes place. The same people are often responsible for ensuring the copy is appropriate for the environment (permissions, configuration data, sensitive data), so have to perform semi-manual tasks and maintain brittle scripts to do so. In this session Redgate’s Richard Macaskill shows how new tool SQL Clone enables self-service or easy automation of database copies and is near-instant at the time of need, using a fraction of the disk space, and allowing quick reversion to a baseline.
About Richard: Richard is a Product Manager at Redgate, having previously spent almost 20 years in IT management, database administration and development for Insurance and Financial Services firms in London, back-filling other roles along the way. He spends much of his time boring anyone in earshot about the DevOps and automation implications of financial compliance and audit.
20:50 - 21:00 - Feedback, Prize Draw and Close
Finally: Drinks down the pub