I will be speaking across the pond in Europe in March. I was fortunate enough to be picked for both PASS SQLRally-Nordic (Copenhagen, Denmark) and SQLBits (London, England). Both of the sessions will be on Biml and how it can be applied to your enterprise. These speaking engagements will take place immediately after I get back from traveling across the other pond to Australia, where I will be delivering another Biml talk with Peter Avenant and Paul Schmidt (Varigence Australia), and Warwick Rudd (SQL Masters Consulting).
At SQLRally: A New Approach to Unit and Integration Testing in SSIS
Testing is a critical part of the release process and vital to a high-quality data management lifecycle. Unfortunately, Integration Services (SSIS) does not have built-in support for testing and the tools for relational database testing are limited. As a result, most organizations forgo automated testing and focus entirely on manual user testing, which is both expensive and often occurs too late in the process to address all of the issues discovered.
In this session, a new approach to unit testing (focusing on verifying the correctness of individual packages, tasks, or dataflows) and integration testing (focusing on validating that the data produced by an entire sequence of transformations) will be discussed. This development pattern uses metadata authored by analysts to automatically generate testing logic within the corresponding packages or to automatically generate standalone test packages that contain all of the necessary validation logic.
Session details can be found here: https://sqlbits.com/Sessions/Event14/Increase_your_SSIS_productivity_with_Biml
At SQLBits: Increase your SSIS Productivity with Biml
Business Intelligence Markup Language (Biml) is an XML language for Microsoft Business Intelligence that can take your Integration Services package development to the next level. Creating template packages added productivity to your Integration Services development effort. If the template design changes after development begins, a fair amount of rework to packages could be needed. See how Biml can help create template packages that can better adapt to changing business needs and allow for more comprehensive design or redesign.
This session will be a demo based session that will inspire you to make Biml your number one integration services development tool. Learn how to use Biml scripts to create staging tables and integration services packages. Add metadata to your Biml scripts and really watch the possibilities expand.
Session details can be found here: http://www.sqlpass.org/sqlrally/2015/nordic/SessionDetails.aspx?sid=7570
Hope to see you there.