8 February 2018
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
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.
Matthew Boulton College