John Welch works at SentryOne, where he leads the development of a suite of data and BI products that make developing, testing, managing, and documenting data solutions faster and more efficient. John has been working with data, business intelligence, and data warehousing technologies since 2001. He was awarded as a Microsoft Most Valued Professional (MVP) 2009 - 2016 due to his commitment to sharing his knowledge with the IT community, and is 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), SQL Bits, and others. He has also contributed to multiple books on SQL Server and business intelligence.
John Welch's Training Days
Real World Big Data-Deploy, Design and Manage like a ProSQLBits 2014
This session will walk the audience through building out a real Hadoop cluster, configuring it for analysis and then walk through a number of hands-on real world workloads, focusing on app developers, DBA's, operations, analysts, and BI developers.
SSIS Performance Design PatternsSQLBits 2012
Need a fast data integration solution, but don't have the time or budget for heavy performance tuning? This session will teach you how to pick the right design so you can hit your ETL performance goals with little to no performance tuning!
John Welch's Sessions
Continuous Delivery for Data Warehouses and MartsSQLBits 2014
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 PackagesSQLBits 2014
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 PackagesSQLBits 2012
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 SSISSQLBits 2011
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.