Speaking in Europe – March 2015

image

Untitled

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).

image

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.

-Reeves

About Reeves Smith

Reeves Smith is a consultant and trainer. He holds a Bachelor’s Degree in Applied Mathematics from University of Colorado at Colorado Springs and a Microsoft Certified Master with over 17 years of experience working with SQL Server. Reeves is an independent BI consultant and teammate with Linchpin People. He is an active member of the Denver, CO, PASS chapter and delivers technical presentations at local and regional conferences and user groups. He has had the opportunity to work on various development and data warehouse projects within industries like banking, DoD, energy, entertainment, gaming, healthcare, manufacturing, oil and gas, travel, and telecommunication. You can follow him on Twitter at SQLReeves.
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s