17th - 19th July 2014

The International Centre, Telford

Platinum Sponsor

John Welch

John Welch works at Pragmatic Works, where he manages the development of a suite of BI products that make developing, managing, and documenting BI solutions easier. John has been working with business intelligence and data warehousing technologies since 2001, with a focus on Microsoft products in heterogeneous environments. He is a Microsoft Most Valued Professional (MVP), an award given due to his commitment to sharing his knowledge with the IT community, and an SSAS Maestro.  John is an experienced speaker, having given presentations at Professional Association for SQL Server (PASS) conferences, the Microsoft Business Intelligence conference, Software Development West (SD West), Software Management Conference (ASM/SM), and others. He has also contributed to multiple books on SQL Server, including "Smart Business Intelligence Solutions with Microsoft SQL Server 2008" and the “SQL Server MVP Deep Dives” series.

John writes a blog on business intelligence and SSIS topics at http://agilebi.com/jwelch. He is active in open source projects that help ease the development process for Microsoft BI developers, including ssisUnit (http://ssisunit.codeplex.com), a unit testing framework for SSIS.

http://agilebi.com/jwelch http://agilebi.com/jwelch/rss.aspx
John Welch has submitted 6 sessions for SQLBits 12, although the agenda hasn't been chosen yet. See all submitted sessions.

Pending Sessions

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.
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.
Learn how to use SSIS, Pig, and Sqoop to move data into and out of Hadoop and Hive. This session will focus on practical examples for moving the data, and how to deal with some of the complexities of big data when integrating with SQL Server.
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.
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.
Learn how to use SSIS, Pig, and Sqoop to move data into and out of Hadoop and Hive. This session will focus on practical examples for moving the data, and how to deal with some of the complexities of big data when integrating with SQL Server.

Previous Sessions

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

Blog posts RSS