Sessions & Content

Tags
Content Type
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.
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!
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.
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.
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.
Hadoop: Big Data or Big Deal?
Hadoop (Big Data) vs SQL Server. A view from a SQL Server DBA / Developer
Performance Tuning SQL Server Integration Services (SSIS)
In this demo-rich presentation, Brian shows you some of the common and not so common ways to tune SQL Server Integration Services (SSIS).
SSIS 2012 logging and monitoring
In this session we will learn about the SSISDB catalog views. We will use this info plus our own info to build a monitoring solution for SSIS using SSRS.
Loading Data Warehouse Dimensions in SSIS
This session looks at some of the different methods available to load slowly changing dimension data into a data warehouse, and compares the relative performance given different data scenarios and traditional storage compared with FusionIO
Creating a Meta Data Driven SSIS Solution with Biml
In this session you'll get a good introduction of the concepts and advantages of Biml as we walk to the creation of Meta Data Driven SSIS Solution.
Designing an SSIS Framework
In this “demo-tastic” presentation, SSIS trainer, author, and consultant Andy Leonard explains the what, why, and how of an SSIS framework that delivers metadata-driven package execution, connections management, and centralizes logging.
Handling Advanced Data Warehouse Scenarios in SSIS
Do you have complex dimensions in your data warehouse? Parent-child, late arriving, type 3 or type 6? In this session, we'll cover some SSIS patterns for handling each of these, along with tips for making them perform well.
28 Weeks later - How to scale-out your MS Business Intelligence environment
The SQL Server provides much functionality that increases the scalability and flexibility of your solution by distributing data and jobs among low-priced commodity servers.
Back to the SSIS Future
A look at the new SSIS features in SQL Server code-named Denali
SSIS Custom Components
Writing your first SSIS custom components can seem like a very steep learning curve. In this session i shall walk you through a simple skeletal one to start you on your way.
<<12>>