Sessions & Content

Search
Content Type
Conference
Tags
Faster SSIS Andy Leonard
Learn tips and tricks to make SSIS perform better.
Azure Data Factory v2 with Data Flows capabilities Kamil Nowinski
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! Cathrine Wilhelmsen
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 Sandy Winarko
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).
How to Make Sure Your SSIS Packages Will Never Fail Guy Glantser
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.
The Self-Tuning SSIS Package Ben Weissman (he/him)
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!
Deep Dive into SSIS 2017 and Beyond Jimmy Wong
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 Steph Martin
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 Sandy Winarko
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 Prathy Kamasani
A session to understand the available functionality of SSISDB Catalog
Analysing Text with SQL Server 2014 Dejan Sarka
This session introduces SQL Server 2012 and 2014 text mining capabilities.
Building a meta-driven near realtime ETL solution with BIML Rasmus Reinholdt Nielsen
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.
Delivering Agile Analytics with Azure Machine Learning Adam Jorgensen
Does the concept of analytics make you nervous? Are you being asked to do more advanced analysis with existing tools? Come learn how to take your predictive capabilities to the next level with new azure technologies.
Going Asynchronous with Service Broker Jonathan Kehayias
This session will explain the benefits of asynchronous processing in Service Broker compared to other options like SQL Agent jobs or SSIS packages, and how to implement the basic components required.
Increase your SSIS productivity with Biml Reeves Smith
Discover the power of Business Intelligence Markup Language (Biml) and increase your Integration Services development productivity.
SSIS & HDInsight Tillmann Eitelberg
In this session, we show how SSIS and HDInsight can work together, as well as how Hadoop jobs can be executed and how data can be transferred with SSIS between HDInsight, SQL Server, and other sources or destinations.
Tools and Tips: From accidental to efficient DWH developer Cathrine Wilhelmsen
As data warehouse developers we deliver data to business users... but we don't deliver data as fast as we want. There are many things you can do to increase your own productivity and become a more efficient data warehouse developer.
Hadoop: Big Data or Big Deal? Eduard Erwee
Hadoop (Big Data) vs SQL Server. A view from a SQL Server DBA / Developer
Performance Tuning SQL Server Integration Services (SSIS) Brian Knight
In this demo-rich presentation, Brian shows you some of the common and not so common ways to tune SQL Server Integration Services (SSIS).
Practical Unit Testing for SSIS Packages John Welch
Unit and integration testing for SSIS packages can be challenging. Come to this session to learn how to leverage open-source tools to drive the testing of your packages and the resulting data.
<<123>>