Enterprise Data Warehouse Maintenance Costs More Than Development

This post is part of a series titled Enterprise Data Warehouses: Uncomfortable Truths. There are cases where developing Enterprise Data Warehouses costs less than maintaining Enterprise Data Warehouses. Which cases? When enterprises do not maintain their Data Warehouse, EDW maintenance costs nothing (or nearly nothing). One side-effect of not maintaining an EDW is the Enterprise Data …
Continue reading Enterprise Data Warehouse Maintenance Costs More Than Development

Enterprise Data Warehouse: Uncomfortable Truths

Most enterprises recognize the need to capture, store, collect, and surface enterprise data analytics. Why, then, do most enterprise data warehouse projects disappoint or outright fail? The author proposes to share three reasons gleaned from decades of delivering and writing about data warehouse solutions: Enterprise Data Warehouse Maintenance Costs More Than Development Enterprise Data Warehouse …
Continue reading Enterprise Data Warehouse: Uncomfortable Truths

In 2020, Two Full Training Days, Two Continents

It dawned on me that I am honored to deliver two full-day conference training presentations in early 2020 on two continents! At the Difinity 2020 conference in Auckland New Zealand, Sandy Winarko and I are co-presenting Intelligent Data Integration with SSIS and Azure Data Factory 20 Feb 2020. Sandy is Principal Program Manager – Azure …
Continue reading In 2020, Two Full Training Days, Two Continents

My PASS Summit 2019 Presentations

SSIS DevOps and Azure Containers I was honored to co-present SSIS DevOps and Azure Containers with Sreeja Pullagura and Elizabeth Baron. Liz and Sreeja work for Teach for America, a really cool non-profit headquartered in NYC. This was their very first time presenting at the PASS Summit. We were even featured on PASStv! . You …
Continue reading My PASS Summit 2019 Presentations

Wrapping up the Summer o’ ADF 2019

As the 2019 Summer o’ ADF 2019 draws to a close, we look forward to shorter and cooler Autumn days (in the northern hemisphere, at least!), conference season, and the fast-approaching holidays. As always, I had an absolute blast sharing tips and tricks for using Azure Data Factory in the enterprise. I must admit that …
Continue reading Wrapping up the Summer o’ ADF 2019

Free Webinar: Using the Azure Data Factory Lookup and ForEach Activities

Join me Wednesday 05 Jun 2019 for the next free webinar from Enterprise Data & Analytics titled Using the Azure Data Factory Lookup and ForEach Activities! Abstract In this demo-tastic presentation, Microsoft Data Platform MVP and author Andy Leonard walks through loading a dataset using the Lookup Activity, followed by iterating dataset values using a …
Continue reading Free Webinar: Using the Azure Data Factory Lookup and ForEach Activities

The Recording for “A Data Science Story” by Shannon Lowder is Available

Shannon Lowder (@shannonlowder | shannonlowder.com) did a fantastic job presenting the true story of a data science project. He presented the problem he was trying to solve, the places he looked for data, issues and obstacles he encountered, and solutions he developed. Enjoy! Links Storm Events files NOAA Hail Data files Microsoft Azure Machine Learning: …
Continue reading The Recording for “A Data Science Story” by Shannon Lowder is Available

Mean Time to Identify Failure

While managing a team of 40 ETL developers, I wanted to track lots of metrics. Some of the things I wanted to track were technical, like SSIS package execution times. Some metrics were people-centric.  Andy’s First Rule of Statistics states: You can use statistics for anything about people, except people. Andy – circa 2005 It was …
Continue reading Mean Time to Identify Failure

Biml, Book Reviews, and Metadata-Driven Frameworks

I occasionally (rarely) read reviews at Amazon of books I’ve written. If I learn of a complaint regarding the book I often try to help. If a reader experiences difficulty with demos, I often offer to help, and sometimes I meet with readers to work through some difficulty related to the book (as I offered …
Continue reading Biml, Book Reviews, and Metadata-Driven Frameworks