SQLBits 2014
Continuous Delivery for Data Warehouses and Marts
Continuous delivery is an approach that enables new functionality to be delivered as needed. This session will cover how this approach can be applied to data warehouses to enable faster time to value for the consumers of the data.
Most data warehouses are in a constant state of flux. There
are new requirements coming in from the business, updates and improvements to
be made to existing data and structures, and new initiatives that drive new
data requirements. How do you manage the complexity of keeping up with the
changes and delivering new features to your business users in a timely manner,
while maintaining high quality? Continuous delivery is an approach for managing
this. It focuses on automation of many steps in the process, so that time is
spent on adding new functionality, rather than repetitive steps. Attend this
session and learn how Continuous Delivery can be applied to your data projects.
Speakers
John Welch's previous sessions
Continuous Delivery for Data Warehouses and Marts
Continuous delivery is an approach that enables new functionality to be delivered as needed. This session will cover how this approach can be applied to data warehouses to enable faster time to value for the consumers of the data.
Practical Unit Testing for SSIS Packages
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.
Unit Testing SSIS Packages
Unit testing is incredibly beneficial, but is very difficult to do effectively in SSIS. If you have wanted to do this, but aren't sure how, this session will cover the options and demonstrate a free tool for unit testing packages.
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.