Next Meetup

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: Paul@MSDataGroupBrum.com Alex Whittles Twitter: @PurpleFrogAlex (https://twitter.com/purplefrogalex) Email: Alex@MSDataGroupBrum.com (Alex@MSDataGroupBrum.com) 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

Matthew Boulton College

Jennens Road · Birmingham

What we're about

Public Group

Microsoft Data Platform Group - Bringing the West Midlands Microsoft data platform community together.

WHAT?

We normally hold meetings every other month, usually on a Thursday after work in the centre of Birmingham. It's an informal gathering of like minded people, with a couple of speakers presenting hour long sessions including tips, techniques and information on old, new and upcoming technology.

We like to get a mixture of world leading speakers as well as providing an opportunity for our members to present. We tailor the speakers and sessions to your requests so if you have any specific topics that you want to go through, then come along and let us know. Each meetup consists of two speakers presenting topics for an hour each, with a break in the middle for some food and networking.

We're part of the UK SQL Server community and an official PASS chapter (the Professional Association for SQL Server) covering the Midlands in the UK.

WHERE?

Aston Manor Academy
Phillips Street
Aston
Birmingham
B6 4PZ

In the main hall. Through reception, bear left down the stair. It's at the end of the corridor on the right.

Free parking on site, but is limited. Street parking also available.

WHEN?

The 2nd or 3rd Thursday of the month.

Door open at 6:15pm to meet and greet.

The first session starts at 6:30pm, second session finishes at 9pm with a break for refreshments in between.

ANYTHING ELSE?

Dress code: Casual

Size: Usually between 20 and 40 people

Members (679)

Photos (18)

Find us also at