Sessions & Content

Tags
Search
Conference
Azure Data Factory v2 with Data Flows capabilities
We will review this new feature of ADFv2, do deep dive to understand the mentioned techniques, compare them to SSIS and/or T-SQL and learn how modelled data flow runs Scala behind the scenes.
Biml Tips and Tricks: Not just for SSIS packages!
Biml is not just for generating SSIS packages! Come and see how you can use Biml to save time and speed up other Data Warehouse development tasks like T-SQL development, test data creation, and dimension population.
Deeper Integration and New Transformation for SSIS in ADF
This session focuses on the deeper integration of SQL Server Integration Services (SSIS) in Azure Data Factory (ADF) and the broad extensibility of Azure-SSIS Integration Runtime (IR).
ETL with Azure Databricks, The Complete Introduction
We’ll take a look at how to approach making an Azure Databricks based ETL solution from start to finish. Along the way it will become clear how Azure Databricks works and we will use our SSIS knowledge to see if it can handle common use-cases
How to Make Sure Your SSIS Packages Will Never Fail
If you never have errors in your SSIS packages, then you don't need to attend this session. But if you want your packages to be reliable and safe, and to handle errors appropriately, then this session is for you.
Patterns and Best Practices in SSIS
Getting better performance from your ETL
The Self-Tuning SSIS Package
This session is about using the Business Intelligence Markup Language (Biml) to monitor and control your orchestration patterns. By automatically analyzing the results in ETL logs, we’ll be able to automate our staging orchestration!
Cloud Processing: PaaS SSIS & Advanced Patterns with ADFV2
Many existing Data Factories include large numbers of workarounds due to limitations with the service. Now that ADF V2 is available, we can restructure our Data Factories to be lean, efficient data pipelines, and this session will show you how.
Deep Dive into SSIS 2017 and Beyond
We will showcase the latest feature of SSIS 2017 such as connectors for Azure Data Lake Store (ADLS), Azure SQL Data Warehouse (SQL DW), SSIS Scale-Out at package level for the box product as well as the SSIS package execution on Azure Data Factory
Solving ETL bottlenecks with SSIS Scale Out
Do you have large-scale SSIS platforms which experience bottlenecks due to the number of packages or volumes of data that need to be processed? Yes! Then you need to explore SSIS scale out.
What’s New with SSIS in ADFv2
See the latest features of SSIS in ADFv2, e.g. ARM VNet, Enterprise Edition, Custom Setup Interface, Execute SSIS Package Activity, etc.
Deep Dive into SSIDB Catalog
A session to understand the available functionality of SSISDB Catalog
Automate Your ETL with SSIS and PowerShell
ETL Development takes time. Allen will show how PowerShell and BIML combine to make the development process seamless, consistent and reduces costly development time dramatically.
Azure Data Factory vs SSIS
Azure Data Factory and SSIS are both data movement tools, but built for different purposes. In this session you will learn pros and cons of using each technology, and best practices of using each in real world scenarios.
Biml for Beginners: Speed up your SSIS development
SSIS is a powerful tool for extracting, transforming and loading data, but creating and maintaining a large number of SSIS packages can be both tedious and time-consuming. Learn how to speed up your SSIS development by using Biml and BimlScript.
Data Warehouse load performance with SSIS and SQL Server
The typical performance bottleneck in your data warehouse is using SSIS to insert massive amount of data into SQL Server. In this session, you will learn how to improve the load performance with SSIS into SQL Server.
Essential Architecture for Bi in a Virtual Environment
Virtualization has had a major impact on computing. While data professionals have adjusted to this for database servers, many BI workloads have moved there as well. Learn about the impact of virtualization on BI.
SQL Server 2016 Business Intelligence New Features
Do you get involved in the creation of Business Intelligence solutions within your organisation? This session will show you the new features of SQL Server 2016 Business Intelligence components.
Analysing Text with SQL Server 2014
This session introduces SQL Server 2012 and 2014 text mining capabilities.
Building a meta-driven near realtime ETL solution with BIML
This all demo session build around a real life case study from one of the largest organizations in the world. will take you through a case of how to build a completely meta-driven SSIS solution relaying on BIML and MDS to do the hard-work for you.
<<1234>>