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
Category:Data Warehousing
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
Use Biml to Build a Local Copy of an Azure SQL DB – a Free Webinar
Join me 30 Aug 2018 at noon EDT for another free webinar titled Use Biml to Build a Local Copy of an Azure SQL DB. This webinar is inspired by a social media post by a friend. His company is using Azure SQL DB in Production. They want to make a copy of the Production …
Continue reading Use Biml to Build a Local Copy of an Azure SQL DB – a Free Webinar
SSIS Design Pattern: Controller Pattern
The SSIS Design Pattern known as the Controller Pattern provides a solution for executing SSIS packages in parallel – even from a serial SSIS execution framework such as SSIS Framework Community Edition (part of DILM Suite).
Experience Matters
This is a picture of Kent Bradshaw, Microsoft Certified Data Scientist. Kent and I work together at Enterprise Data & Analytics delivering data engineering, business intelligence, and data-based solutions that help businesses turn their data into actionable information. We do not do this alone, we are surrounded by an excellent team that holds diverse skills, …
Continue reading Experience Matters
Biml Case Study: Automate an Extract for Patrick LeBlanc’s K12 Solution
My friend and brother, Patrick LeBlanc (@patrickdba), built a cool Power Bi Dashboard (and database!) to help K12 education systems track students and student activities such as attendance. Better yet, he gives it away! He gives away the code and he shares a free Guy in a Cube video walking through the features. Patrick emailed and …
Continue reading Biml Case Study: Automate an Extract for Patrick LeBlanc’s K12 Solution
Data Integration Pattern: The Pessimistic Load
“What is a Pessimistic Load?” I’m glad you asked! A pessimistic load is any load pattern that incorporates a strict reconciliation process. Strict reconciliation throws an error when the reconciliation effort fails. How Does It Work? First you load some records. Then you check to see if the records you intended to load have been loaded. …
Continue reading Data Integration Pattern: The Pessimistic Load
Immersion Event on Learning SSIS – May 2018!
I am honored to partner with the awesome team at SQLSkills to deliver IESSIS1: Immersion Event on Learning SQL Server Integration Services in person in Chicago 7-11 May 2018! Click here to register! Here’s what I’ll be covering: Module 1: Introduction In the introduction we share information about the instructor, course flow, and content, and gather …
Continue reading Immersion Event on Learning SSIS – May 2018!
Expert SSIS Training 4-5 Dec 2017!
Yep, we’re doing it again. In cooperation with Brent Ozar Unlimited, the next delivery of Expert SSIS Training is 4-5 Dec 2017. I had a great time delivering this course with Brent in September and I’m excited to have the opportunity to share this material with you again! If you register soon (written 27 Sep …
Continue reading Expert SSIS Training 4-5 Dec 2017!
Available for Pre-Order – The Biml Book!
I am excited to announce The Biml Book is now available for pre-order from Amazon and Apress! I was honored to write with the inventor of Biml, Scott Currie, and an awesome team of BimlHeroes: Jacob Alley, Martin Andersson, Peter Avenant, Bill Fellows, Simon Peck, Reeves Smith, Raymond Sondak, Benjamin Weissman, and Cathrine Wilhelmsen. Chapters …
Continue reading Available for Pre-Order – The Biml Book!