Sessions & Content

Search
Content Type
Conference
Tags
Design patterns for metadata-first ETL process control Richard Swinbank
In this session we'll look at ETL metadata, use it to drive process execution, and see benefits quickly emerge. I'll show how a metadata-first approach reduces complexity, enhances resilience and allows ETL processing to become self-organising.
The video is not available to view online.
Inside SQL Server 2019 Polybase Bob Ward
SQL Server 2019 expands on the Polybase feature from SQL Server 2019 by providing a robust data virtualization solution to reduce the need for ETL and data movement. Come learn how new data connectors work with sources like Oracle, MongoDB, CosmosDB, Terradata, and HDFS.
Patterns and Best Practices in SSIS Richard Munn
Getting better performance from your ETL
The video is not available to view online.
Profiling Your Data Angela Henry
What data profiling is & why you should do it.
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!
Using Change Tracking to build a Live Data Warehouse Andrea Besozzi
How to build a Live Data Warehouse using Change Tracking capabilities
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.
Automate Your ETL with SSIS and PowerShell Allen White
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.
The video is not available to view online.
Azure Data Factory vs SSIS Reza Rad
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.
The video is not available to view online.
ETL Patterns with Clustered Columnstore Indexes Niko Neugebauer
Join me for an hour of playing with different ETL patterns by using Clustered Columnstore Indexes. Using different Hardware might lead you to different conclusions,and the size of the workload is always the paramount of your performance.Loading data first and then creating a Clustered Columnstore or creating Clustered Columnstore and than loading - join me to find the answers!
SSIS 2012 logging and monitoring Peter ter Braake
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.
DW Design With The Product Team Conor Cunningham
This talk will explain the patterns that we recommend to customers when designing data warehouses. This talk will help people learning about DW for the first time and also give insight for those who wish to learn more.
Incremental Loading of Data using CDC in SQL Server 2012 Allan Mitchell
More data, less time, storing everything. These ingredients mean it is becoming imperative we do not move the kitchen sink everytime we do our ETL Come to this session to find out how.
28 Weeks later - How to scale-out your MS Business Intelligence environment Sascha Lorenz
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.
Data Vault, An introduction to the new datawarehouse supermodel Martijn Evers
A new and fresh approach to datwarehousing that is agile, performant and easy to do. Data Vault is a new methodology that tries to overcome traditional problems that plagued traditional datawarehousing in the past.
SQL Server optimization stuff you won’t find on Google (yet) Andre Kamman
Henk van der Valk from the Unisys performance lab will be my special guest for this session. He has a test system that we all would like to have at home. The ES7000 has 96 Cores and half a Terabyte of RAM yes RAM (!). We will look at various ways to push SQL Server workloads by methodically detecting and resolving bottlenecks.Together we will show you how you can apply this approach on mid-sized and even smaller systems. (We’ll even try some of them on a laptop, and of course we will remote connect into the big machine ) In this session you will: Learn how to measure what the next bottle-neck is,using perfmon and waitstats. Hear about optimization tips that will get the most out of your hardware to speed up your processsing.
SSIS in SQL Server 2008 Allan Mitchell
A look at some of the things that make using SSIS in SQL Server 2008 a very good choice for your ETL requirements
Instrumenting, Monitoring and Auditing of SSIS ETL Solutions Davide Mauri
Come to this session to see how you can create a logging, monitoring and profiling solution for your existing or new SSIS packages overcoming all usual problems that a typical solution brings: increasing package complexity, longer development times and so on. The session will propose a standard, out-of-the-box solution for all of these challenges.
Making more of SSIS in 2008 Allan Mitchell
Making more of SSIS in 2008
The video is not available to view online.
<<1>>