• Birmingham Data Platform - Using Python in SSMS, & other Machine Learning Demos

    Microsoft Data Platform Group Birmingham - 8th November 2018, 6.15pm *** Registration on MeetUp required for venue security *** Session 1: Using Python in SQL Server Management Studio (Pete Moore) Session 2: Machine Learning Demos (Alex Whittles, MVP) Agenda 6.15pm – 6:30pm Meet & Greet 6:30pm - 7:30pm: Using Python in SQL Server Management Studio (Pete Moore) The noise started far away: you need to learn Python, it whispered. We ignored it for a while because we could. Besides we were busy, busy architecting databases, busy writing T-SQL and busy learning all of the other stuff on the MS Data Platform. Real data. Then something happened: you could code Python from within SSMS. The whisper had become deafening. This was now part of T-SQL coding. This was us. The Python had infiltrated our world, but what did it mean for us, the SQL folk? Did we need to up-skill? What now? Did we need knew technology? Textbooks? New education? Or could we just ignore it? This decade’s LINQ (sorry LINQ folks)? This talk tackles these questions by coaxing Python out of its natural environment and debating the pros and cons of: SQL vs Python, Native Python vs Python in SSMS; and, ultimately, why we might just be able to have the best of both worlds - all from the comfort of your own SQL Server Management Studio. 7:30pm - 8:00pm Break & Pizza 8:00pm – 9:00pm Machine Learning Demos Alex Whittles (MVP) will be running through a number of hands-on demos of different ways of accessing and running Machine Learning code. Using a combination of drag and drop GUI through to Cognitive Services, and R & Python scripting, and using tools from Machine Learning Workbench, SQL Server, R-Studio, Python, Data Lake and Data Bricks. Lots of demos, not much theory! Venue This session will be held at Matthew Boulton College. Room: MB114 Address: Matthew Boulton College Jennens Road Birmingham B4 7PS https://www.bmet.ac.uk/our-locations/matthew-boulton/find-us/ On site parking is very limited and likely to already be taken by college staff/students. There are several car parks in the area, see Park-O-Pedia for more details: https://en.parkopedia.co.uk/parking/locations/jennens_road_birmingham_b4_7ps_united_kingdom_gcqdt422cgm/?arriving=201709071700&leaving=201709072130 Other Details We'll be putting on food for the event, so please do register so we know numbers. If you then can't make it we'd really appreciate it if you'd unregister and/or let us know. Dress code: relaxed Event Organiser Contact Details If you need any further details or have any requests for this or future Data Platform Group events, please contact get in touch. Alex Whittles Twitter: @PurpleFrogAlex (https://twitter.com/purplefrogalex) Email: [masked] ([masked]) Microsoft Data Platform Group - Birmingham Twitter: @MSDataGroupBrum (https://twitter.com/MSDataGroupBrum) Speaker Profiles Pete Moore (@TheDataBloke) is a Data Scientist specialising in R, Python and SQL. He is founder of Look at your Data Ltd and available for freelance work, you can view his CV here: https://goo.gl/rvLhy1 Prior to Look at your Data, Pete was an IT Director. He is a present day student at the Data Science MSc at the University of Dundee. Alex Whittles (@PurpleFrogAlex) is a Microsoft Data Platform MVP, and is Principle Consultant at Purple Frog Systems, a data warehousing, cube & analytics consultancy in the Midlands.

    2
  • Birmingham Data Platform - Agile development for BI, and documenting Power BI

    Microsoft Data Platform Group Birmingham - 13th September 2018, 6.15pm *** Registration on MeetUp required for venue security *** Session 1: Applying Agile and Behaviour Driven Dev to BI work - with John Mathews Session 2: Automating SSAS and PowerBI Documentation - Steve Powell [Please note the changed agenda] Agenda 6.15pm – 6:30pm Meet & Greet 6:30pm - 7:30pm Applying Agile and Behaviour Driven Dev to BI work - with John Matthews Transform your BI development process and adopt an agile methodology 7:30pm - 8:00pm Break & Pizza 8:00pm – 9:00pm Documenting the data models in your SSAS and PowerBI Solutions - with Steve Powell Using Extended Properties you can provide data model documentation directly from your solutions for SSAS and PowerBI files. We will cover how and where you add the properties, how you can access them using PowerShell and how to extract and display them using good old SSRS. Venue This session will be held at Matthew Boulton College. Room: MB114 Address: Matthew Boulton College Jennens Road Birmingham B4 7PS https://www.bmet.ac.uk/our-locations/matthew-boulton/find-us/ On site parking is very limited and likely to already be taken by college staff/students. There are several car parks in the area, see Park-O-Pedia for more details: https://en.parkopedia.co.uk/parking/locations/jennens_road_birmingham_b4_7ps_united_kingdom_gcqdt422cgm/?arriving=201709071700&leaving=201709072130 Other Details We'll be putting on food for the event, so please do register so we know numbers. If you then can't make it we'd really appreciate it if you'd unregister and/or let us know. Dress code: relaxed Event Organiser Contact Details If you need any further details or have any requests for this or future Data Platform Group events, please contact get in touch. Alex Whittles Twitter: @PurpleFrogAlex (https://twitter.com/purplefrogalex) Email: [masked] ([masked]) Microsoft Data Platform Group - Birmingham Twitter: @MSDataGroupBrum (https://twitter.com/MSDataGroupBrum) Speaker Profiles TBC

    3
  • Birmingham Data Platform - Power BI & Powershell

    Matthew Boulton College

    Microsoft Data Platform Group Birmingham - 9th August 2018, 6.15pm *** Registration on MeetUp required for venue security *** Session 1: Power BI, compelling data stories - with Prathy Kamasani (MVP) Session 2: Powershell in SQL Server - with Rob Sewell (MVP) Agenda 6.15pm – 6:30pm Meet & Greet 6:30pm - 7:30pm Compelling data stories using Power BI - with Prathy Kamasani (MVP) This demo filled session is packed with tips and tricks to upgrade the visual appeal of your Microsoft Power BI reports. In this session, you’ll learn: • How to use background images and useful resources to create background templates • Use of colour and tips on how to create appealing colour pallets • Multiple ways to utilise conditional formatting to highlight specific data points • How to create Power BI theme files • Additional DataViz resources 7:30pm - 8:00pm Break & Pizza 8:00pm – 9:00pm Using Powershell with SQL Server - with Rob Sewell (MVP) Venue This session will be held at Matthew Boulton College. Room: MB723 Address: Matthew Boulton College Jennens Road Birmingham B4 7PS https://www.bmet.ac.uk/our-locations/matthew-boulton/find-us/ On site parking is very limited and likely to already be taken by college staff/students. There are several car parks in the area, see Park-O-Pedia for more details: https://en.parkopedia.co.uk/parking/locations/jennens_road_birmingham_b4_7ps_united_kingdom_gcqdt422cgm/?arriving=201709071700&leaving=201709072130 Other Details We'll be putting on food for the event, so please do register so we know numbers. If you then can't make it we'd really appreciate it if you'd unregister and/or let us know. Dress code: relaxed Event Organiser Contact Details If you need any further details or have any requests for this or future Data Platform Group events, please contact get in touch. Alex Whittles Twitter: @PurpleFrogAlex (https://twitter.com/purplefrogalex) Email: [masked] ([masked]) Microsoft Data Platform Group - Birmingham Twitter: @MSDataGroupBrum (https://twitter.com/MSDataGroupBrum) Speaker Profiles Prathy Kamasani is a Microsoft Valuable Professional working as an independent MSBI contractor based in London.She specialises in Power BI, SSIS, SSAS and SSRS. Prathy is active in the SQL Server community as a speaker, volunteer and organises London Power BI User Group. She is a regular speaker at events like SQL Saturdays and PASS User groups. Rob Sewell is a SQL Server DBA with a passion for Powershell, Azure, Automation, & SQL (PaaS geddit?). He is an MVP & an officer for the PASS PowerShell VG & has spoken at, organised & volunteered at many events. He is a member of the committee that organises SQL Saturday Exeter, PSDayUK & also the European PowerShell Conference. He is a proud supporter of the SQL & PowerShell communities. He relishes sharing & learning & can be found doing both via Twitter & his blog. He spends most of his time looking at a screen & loves to solve problems. He knows that looking at a screen so much is bad for him because his wife tells him so. Thus, you can find him on the cricket field in the summer or flying a drone in the winter. And he has a fabulous beard!

  • Birmingham Data Platform - SQL Server Managed Instances & SQL DB

    Matthew Boulton College

    Microsoft Data Platform Group Birmingham - 12th July 2018, 6.15pm *** Registration on MeetUp required for venue security *** SQL Server Managed Instances and SQL DB in Azure - with Neil Hambly What are Azure SQL Database Managed Instances? The range of options for storing data in Microsoft Azure keeps growing, the most notable recent addition is the Managed Instance. But what is it, and why is it there? Join John as he walks through what they are and how you might start using them. Managed Instances add a new option for running workloads in the cloud. Allowing near parity with a traditional on-premises SQL Server. Including SQL Agent, Cross Database Queries, Service Broker, CDC, and many more. Overcoming many of the challenges to using Azure SQL Databases. But, what is the reality, how do we make use of it, and are there any gotcha’s that we need to be aware of? This is what we will cover, going beyond the hype and looking at how we can make use of this new technology, working through a full migration including workload analysis, selecting the appropriate migration pathway and then putting it in place. Agenda 6.15pm – 6:30pm Meet & Greet 6:30pm - 7:30pm SQL Server Managed Instances in Azure - with Neil Hambly - Part 1 7:30pm - 8:00pm Break & Pizza 8:00pm – 9:00pm SQL Server Managed Instances in Azure - with Neil Hambly - Part 2 Venue This session will be held at Matthew Boulton College. Room: MB114 Address: Matthew Boulton College Jennens Road Birmingham B4 7PS https://www.bmet.ac.uk/our-locations/matthew-boulton/find-us/ On site parking is very limited and likely to already be taken by college staff/students. There are several car parks in the area, see Park-O-Pedia for more details: https://en.parkopedia.co.uk/parking/locations/jennens_road_birmingham_b4_7ps_united_kingdom_gcqdt422cgm/?arriving=201709071700&leaving=201709072130 Other Details We'll be putting on food for the event, so please do register so we know numbers. If you then can't make it we'd really appreciate it if you'd unregister and/or let us know. Dress code: relaxed Event Organiser Contact Details If you need any further details or have any requests for this or future Data Platform Group events, please contact get in touch. Alex Whittles Twitter: @PurpleFrogAlex (https://twitter.com/purplefrogalex) Email: [masked] ([masked]) Microsoft Data Platform Group - Birmingham Twitter: @MSDataGroupBrum (https://twitter.com/MSDataGroupBrum) Speaker Profiles Neil Hambly is the Founder/CIO/Consult @ DataMovements Limited (Silver Data Analytics Partner), previous roles @ ABN AMRO, Accenture, ASOS, BBC, Confio Software with 20+ years using SQL Server. Presented 200+ 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, and Dancing

    1
  • Birmingham Data Platform - PowerApps, SQLDB, PowerBI, & SQL Server in Docker

    Microsoft Data Platform Group Birmingham - 7th June 2018, 6.15pm *** Registration on MeetUp required for venue security *** Session 1: The Server-less Data Application, using PowerApps, SQLDB and Power BI - with James Boother Session 2: SQL Server in Docker - with Justin Langford Agenda 6.15pm – 6:30pm Meet & Greet 6:30pm - 7:30pm The Server-less Data Application, using PowerApps, SQLDB and Power BI - with James Boother 7:30pm - 8:00pm Break & Pizza 8:00pm – 9:00pm SQL Server in Docker - with Justin Langford Venue This session will be held at Matthew Boulton College. Room: MB114 Address: Matthew Boulton College Jennens Road Birmingham B4 7PS https://www.bmet.ac.uk/our-locations/matthew-boulton/find-us/ On site parking is very limited and likely to already be taken by college staff/students. There are several car parks in the area, see Park-O-Pedia for more details: https://en.parkopedia.co.uk/parking/locations/jennens_road_birmingham_b4_7ps_united_kingdom_gcqdt422cgm/?arriving=201709071700&leaving=201709072130 Other Details We'll be putting on food for the event, so please do register so we know numbers. If you then can't make it we'd really appreciate it if you'd unregister and/or let us know. Dress code: relaxed Event Organiser Contact Details If you need any further details or have any requests for this or future Data Platform Group events, please contact get in touch. Alex Whittles Twitter: @PurpleFrogAlex (https://twitter.com/purplefrogalex) Email: [masked] ([masked]) Microsoft Data Platform Group - Birmingham Twitter: @MSDataGroupBrum (https://twitter.com/MSDataGroupBrum) Speaker Profiles James Boother is a Principal Consultant and Microsoft Certified Master working for Coeo following 15 years experience within the software industry working as a programmer, system architect, head of technology and consultant. James helps Coeo’s clients scope, design, deploy and performance tune their Microsoft SQL Server database platforms. Coeo is a Microsoft Gold Partner specialising in Data Platform and BI solutions. Justin Langford works at Coeo, a Microsoft Gold Partner providing consulting services for upgrade, performance tuning, migration scalability and availability solutions for SQL Server and Azure data services. Coeo also deliver 24x7 Dedicated Support services for mission critical SQL Server platforms and Azure data solutions.

    4
  • Birmingham Data Platform Meetup - SQL Server Query Tuning, and ETL using T-SQL

    Microsoft Data Platform Group Birmingham - 10th May 2018, 6.15pm *** Registration on MeetUp required for venue security *** Session 1: Query tuning in SQL Server - with Kev Riley Session 2: ETL using T-SQL and SQL agent - with Richard Swinbank Agenda 6.15pm – 6:30pm Meet & Greet 6:30pm - 7:30pm Query tuning in SQL Server - with Kev Riley 7:30pm - 8:00pm Break & Pizza 8:00pm – 9:00pm ETL using T-SQL and SQL agent - with Richard Swinbank Venue This session will be held at Matthew Boulton College. Room: MB723 Address: Matthew Boulton College Jennens Road Birmingham B4 7PS https://www.bmet.ac.uk/our-locations/matthew-boulton/find-us/ On site parking is very limited and likely to already be taken by college staff/students. There are several car parks in the area, see Park-O-Pedia for more details: https://en.parkopedia.co.uk/parking/locations/jennens_road_birmingham_b4_7ps_united_kingdom_gcqdt422cgm/?arriving=201709071700&leaving=201709072130 Other Details We'll be putting on food for the event, so please do register so we know numbers. If you then can't make it we'd really appreciate it if you'd unregister and/or let us know. Dress code: relaxed Event Organiser Contact Details If you need any further details or have any requests for this or future Data Platform Group events, please contact get in touch. Alex Whittles Twitter: @PurpleFrogAlex (https://twitter.com/purplefrogalex) Email: [masked] ([masked]) Microsoft Data Platform Group - Birmingham Twitter: @MSDataGroupBrum (https://twitter.com/MSDataGroupBrum) Speaker Profiles TBC

    7
  • Birmingham Data Platform Meetup - Intro to Azure Databricks, and Azure SSAS

    Microsoft Data Platform Group Birmingham - 19th April 2018, 6.15pm *** Registration on MeetUp required for venue security *** Session 1: Introduction to Azure Databricks - Is this the perfect combination of big data manipulation, cloud ETL, machine learning and data analytics? This demo heavy session will cover what it is, how to use it and what it can do. Session 2: Azure Analysis Services - Learn how to build and deploy cubes to Azure Analysis Services. Including partition management, scale out for performance, security, setting up the processing so that it doesn't impact query performance, monitoring, connecting to Power BI and much more. Agenda 6.15pm – 6:30pm Meet & Greet 6:30pm - 7:30pm Introduction to Azure Databricks 7:30pm - 8:00pm Break & Pizza 8:00pm – 9:00pm Azure Analysis Services Venue This session will be held at Matthew Boulton College. Room: MB723 Address: Matthew Boulton College Jennens Road Birmingham B4 7PS https://www.bmet.ac.uk/our-locations/matthew-boulton/find-us/ On site parking is very limited and likely to already be taken by college staff/students. There are several car parks in the area, see Park-O-Pedia for more details: https://en.parkopedia.co.uk/parking/locations/jennens_road_birmingham_b4_7ps_united_kingdom_gcqdt422cgm/?arriving=201709071700&leaving=201709072130 Other Details We'll be putting on food for the event, so please do register so we know numbers. If you then can't make it we'd really appreciate it if you'd unregister and/or let us know. Dress code: relaxed Event Organiser Contact Details If you need any further details or have any requests for this or future Data Platform Group events, please contact get in touch. Alex Whittles Twitter: @PurpleFrogAlex (https://twitter.com/purplefrogalex) Email: [masked] ([masked]) Microsoft Data Platform Group - Birmingham Twitter: @MSDataGroupBrum (https://twitter.com/MSDataGroupBrum) Speaker Profiles Alex Whittles Alex is an MVP, and is the owner and principle consultant at Purple Frog, a SQL Server Business Intelligence consultancy in the UK with multinational clients in a variety of sectors. He specialises in the architecture and design of all aspects of data warehousing, ETL, cubes, Power BI and Big Data analytics. He organises SQL Bits and SQL Relay, as well as the Birmingham Data Platform Group.

    9
  • A Whirlwind Tour Of Azure SQLDB & PaaS SSIS Advanced Design Patterns with ADFV2

    Microsoft Data Platform Group Birmingham - 8th February 2018, 6.15pm *** Registration on MeetUp required for venue security *** Session 1: Arun Sirpal - A Whirlwind Tour Of Azure SQLDB Session 2: Simon Whiteley - Cloud Processing: PaaS SSIS Advanced Design Patterns with ADFv2 Agenda 6.15pm – 6:30pm Meet & Greet 6:30pm - 7:30pm Arun Sirpal - A Whirlwind Tour Of Azure SQLDB Azure SQL Database is a general-purpose relational database service in Microsoft Azure. With Microsoft's cloud-first strategy, the newest capabilities of SQL Server are released first to Azure SQL Database and then to SQL Server itself. During this entry level presentation you will get to see the differences in security, high availability, performance, and monitoring of this cloud-first solution. You will also learn about the different service tiers and performance levels that are specific to Azure SQL Database and learn about the different methods that you could use to migrate to Azure. 7:30pm - 8:00pm Break & Pizza 8:00pm – 9:00pm Simon Whiteley - Cloud Processing: PaaS SSIS Advanced Design Patterns in ADF Many existing Data Factory solutions include a large number of workarounds due to limitations with the service. Now that Data Factory V2 is available, we can restructure our Data Factories to be lean, efficient data pipelines, and this session will show you how. The initial Data Factory release was targeted at managing hadoop clusters, with a couple of additional integrations thrown in - it was mistakenly believed to be "the new SSIS" and subsequently there were a lot of very disappointed people. The new release remedies many of these complaints, adding in workflow management, expressions, ad-hoc triggers and many more features that open up a world of possibilities. This session will run through the new features in ADFV2 and discuss how they can be used to streamline your factories, putting them in the context of real-world solutions. We will also look at the additional compute options provided by the new SSIS integration, how it works within the context of Data Factory and the flexibility it provides. A working knowledge of ADF V1 is assumed. Venue This session will be held at Matthew Boulton College. Level 1. Room MB 114. Address: Matthew Boulton College Jennens Road Birmingham B4 7PS https://www.bmet.ac.uk/our-locations/matthew-boulton/find-us/ On site parking is very limited and likely to already be taken by college staff/students. There are several car parks in the area, see Park-O-Pedia for more details: https://en.parkopedia.co.uk/parking/locations/jennens_road_birmingham_b4_7ps_united_kingdom_gcqdt422cgm/?arriving=201709071700&leaving=201709072130 Other Details We'll be putting on food for the event, so please do register so we know numbers. If you then can't make it we'd really appreciate it if you'd unregister and/or let us know. Dress code: relaxed Event Organiser Contact Details If you need any further details or have any requests for this or future Data Platform Group events, please contact get in touch. Paul Andrew Twitter: @mrpaulandrew (https://twitter.com/mrpaulandrew) Email: [masked] Alex Whittles Twitter: @PurpleFrogAlex (https://twitter.com/purplefrogalex) Email: [masked] ([masked]) Microsoft Data Platform Group - Birmingham Twitter: @MSDataGroupBrum (https://twitter.com/MSDataGroupBrum) Speaker Profiles Arun is a DBA from Birmingham and Microsoft Data Platform MVP with interests in Microsoft technology. During 2015 he was mentored by Paul Randal of SQLskills and during 2016 he completed SQLskills Immersion training on Internals and Performance Tuning. As Chief Cloud Architect with Adatis Consulting, 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. Most recently, he has turned his head to the clouds, advocating new methods of

  • PowerBI Visual Design Choices & An Intro to Azure Machine Learning

    Microsoft Data Platform Group Birmingham - 11th January 2018, 6.15pm *** Registration on MeetUp required for venue security *** Session 1: Jon Lunn - The impact of data visualisation design choices Session 2: Alex Whittles - An Introduction to Azure Machine Learning Agenda 6.15pm – 6:30pm Meet & Greet 6:30pm - 7:30pm Jon Lunn - The impact of data visualisation design choices This presentation will show how the choices that you make in displaying the data, affect how you understand the data. We’ll also explain what is a cognitive burden and attentive process and why it matter in report design. This will apply to any reporting platform, but I’ll be using Power BI to do a reporting make over on a report. 7:30pm - 8:00pm Break & Pizza 8:00pm – 9:00pm Alex Whittles - An Introduction to Azure Machine Learning earn how to build an Azure Machine Learning model, how to use, integrate and consume the model within other applications, and learn the basic principles and statistics concepts available in the different ML algorithms. If you want to know whether to choose a 'neural net' or a 'two class boosted decision tree', this session will reveal all! Venue This session will be held at Matthew Boulton College. Level 7. Room MB 723. Address: Matthew Boulton College Jennens Road Birmingham B4 7PS https://www.bmet.ac.uk/our-locations/matthew-boulton/find-us/ On site parking is very limited and likely to already be taken by college staff/students. There are several car parks in the area, see Park-O-Pedia for more details: https://en.parkopedia.co.uk/parking/locations/jennens_road_birmingham_b4_7ps_united_kingdom_gcqdt422cgm/?arriving=201709071700&leaving=201709072130 Other Details We'll be putting on food for the event, so please do register so we know numbers. If you then can't make it we'd really appreciate it if you'd unregister and/or let us know. Dress code: relaxed Event Organiser Contact Details If you need any further details or have any requests for this or future Data Platform Group events, please contact get in touch. Paul Andrew Twitter: @mrpaulandrew (https://twitter.com/mrpaulandrew) Email: [masked] Alex Whittles Twitter: @PurpleFrogAlex (https://twitter.com/purplefrogalex) Email: [masked] ([masked]) Microsoft Data Platform Group - Birmingham Twitter: @MSDataGroupBrum (https://twitter.com/MSDataGroupBrum) Speaker Profiles Jon is a senior consultant for Ricoh Business Solution Group (formally Ridgian) a MS Gold partner, focusing on Microsoft SQL Server Platform and the BI stack of applications, SSAS, SSIS, SSRS, Power BI, and R Server, and Azure services such as Data Factory, Cosmos DB. On a personal note, keen photographer and as I have young kids, visitor of farms and castles on a regular basis. Alex is the owner and principle consultant at Purple Frog, a SQL Server Business Intelligence consultancy in the UK with multinational clients in a variety of sectors. He specialises in all aspects of dimensional data modelling, data warehousing, ETL and cubes using the SQL Server stack. Alex has an MSc in Business Intelligence, is a chartered engineer, and a member of Mensa. Community leadership includes being on the SQL Bits committee, Director of SQL Relay, founder and leader of the Birmingham Data Platform user group. Alex is also a regular speaker at many SQL Server events around the world including SQL Relay, SQL Bits, SQL Saturdays, 24 HOP and the PASS Summit.

    6
  • Azure Data Lake, the services, the U-SQL, the C# & SQL2017 Graph Tables

    Microsoft Data Platform Group Birmingham - 7th December 2017, 6.15pm *** NEW VENUE *** *** Registration on MeetUp required for venue security *** Session 1: Paul Andrew - Azure Data Lake - The Services. The SQL. The Sharp. Session 2: Terry McCann - Enhancing Relational Models with Gaph processing In SQL Server 2017 Agenda 6.15pm – 6:30pm Meet & Greet 6:30pm - 7:30pm Paul Andrew - Azure Data Lake - The Services. The SQL. The Sharp. How do we implement Azure Data Lake? How does a lake fit into our data platform architecture? Is Data Lake going to run in isolation or be part of a larger pipeline? How do we use and work with USQL? Does size matter?! The answers to all these questions and more in this session as we immerse ourselves in the lake, that’s in a cloud. We'll take an end to end look at the components and understand why the compute and storage are separate services. For the developers, what tools should we be using and where should we deploy our USQL scripts. Also, what options are available for handling our C# code behind and supporting assemblies. We’ll cover everything you need to know to get started developing data solutions with Azure Data Lake. Finally, let’s extend the U-SQL capabilities with the Microsoft Cognitive Services! 7:30pm - 8:00pm Break & Pizza 8:00pm – 9:00pm Terry McCann - Enhancing Relational Models with Gaph processing In SQL Server 2017 Analysing highly connected data using SQL is hard! Relational databases were simply not designed to handle this, but graph databases were. Built from the ground up to understand interconnectivity, graph databases enable a flexible performant way to analyse relationships, and one has just landed in SQL Server 2017! SQL Server supports two new table types NODE and EDGE and a new function MATCH, which enables deeper exploration of the relationships in your data than ever before. In this session, we seek to explore, what is a graph database, why you should be interested, what query patterns does they solve and how does SQL Server compare with competitors. We will explore each of these based on real data shredded from IMDB. Venue This session will be held at Matthew Boulton College. Level 1. Room MB 114. Address: Matthew Boulton College Jennens Road Birmingham B4 7PS https://www.bmet.ac.uk/our-locations/matthew-boulton/find-us/ On site parking is very limited and likely to already be taken by college staff/students. There are several car parks in the area, see Park-O-Pedia for more details: https://en.parkopedia.co.uk/parking/locations/jennens_road_birmingham_b4_7ps_united_kingdom_gcqdt422cgm/?arriving=201709071700&leaving=201709072130 Other Details We'll be putting on food for the event, so please do register so we know numbers. If you then can't make it we'd really appreciate it if you'd unregister and/or let us know. Dress code: relaxed Event Organiser Contact Details If you need any further details or have any requests for this or future Data Platform Group events, please contact get in touch. Paul Andrew Twitter: @mrpaulandrew (https://twitter.com/mrpaulandrew) Email: [masked] Alex Whittles Twitter: @PurpleFrogAlex (https://twitter.com/purplefrogalex) Email: [masked] ([masked]) Microsoft Data Platform Group - Birmingham Twitter: @MSDataGroupBrum (https://twitter.com/MSDataGroupBrum) Speaker Profiles Paul is a Microsoft Data Platform MVP with 10+ years’ experience working with the complete on premises SQL Server stack in a variety of roles and industries. Now as the Business Intelligence Consultant at Purple Frog Systems has turned his keyboard to big data solutions in the Microsoft cloud. Specialising in Azure Data Lake Analytics, Azure Data Factory, Azure Stream Analytics, Event Hubs and IoT. Paul is also a STEM Ambassador for the networking education in schools’ programme, PASS chapter leader for the Microsoft Data Platform Group – Birmingham, SQL Bits, SQL Relay, SQL Saturday speaker and helper. Currently the Stack Overflow top user for Azure Data Factory. As well as very active member of the technical community. Terry McCann is a Data Science & Advanced Analytics Consultant for Adatis Consulting Limited a Microsoft Data & Analytics consultancy in the UK. Data Science Master's student, organiser of the Data Science Exeter user group, frequent speaker at SQL Saturdays in the UK and Europe. Previous co-organiser of SQL Saturday Exeter.

    2