SSIS in the Cloud, Cassandra, Tabular Models

18:00 - Doors open / Pizza
18:15 - 19:15 - Richard Munn: Cassandra for SQL Server peeps
19:30 - 20:30 - Simon Whitely: Cloud Processing: PaaS SSIS & Advanced Patterns with ADFV2
20:40 - 21:40 - Ust Oldfield: Automating SSAS Tabular Models

This bumper event is full of upskilling for data peeps - what are your cloud options for ETL, what about this nosql stuff, and how can we automate our olap type environments in the cloud? Important upskilling information!

Cloud Processing: PaaS SSIS & Advanced Patterns with ADFV2

Simon Whitely @mrsiwhitely
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.

Cassandra for SQL Server Peeps

Richard Munn @sql_unicorn
Open source alternatives to the SQL Server data platform are becoming more and more popular in large enterprises. Today's marketplace means that your next project may be considering moving away from 'traditional' relational data stores - indeed, you may have already been involved in one. This session will help you understand the Apache Cassandra eco-system, and can help you evaluate or implement a complimentary DBMS to add to your data platform toolkit.

Tabular Automation With TMSL and PowerShell

Ust Oldfield @uoldfield
This session will explore the Tabular Model Scripting Language (TMSL); how TMSL can be used with PowerShell to automate the creation and deployment of an Analysis Services Tabular Model.