Andrew Holowaty

Blogs from this Author

Advanced Data Integration with SSIS, Part 3

This is part three in a series of extending SSIS for the enterprise with complementary Microsoft products. Different industries have standards for data such as Accord for insurance, HL7 for medical, and Eagle-PACE for finance. These standards have a defined data model that can also be used for data exchange. One of the transports for […]

Advanced Data Integration with SSIS, Part 2

This is part two in a series of extending SSIS for the enterprise with complementary Microsoft products. Specifically, we are going to look at how we can extend an SSIS solution to go through DMZs and firewalls across the Internet to reach and capture data regardless of the SQL Server schema type. In this scenario, […]

Advanced Data Integration with SSIS

Over the past few years, I have had the privilege of working with some of the world’s largest companies in a variety of industries. One thing in common with all of these engagements was using SQL Server Integration Services (SSIS) as the tool of migrating data for the companies’ business intelligence collateral. I have developed […]

The Dependency Checker Accelerator

The database centric solutions created by the National Microsoft Business Intelligence Practice often require a sequence of events that must run in a certain order. An example of a sequence of events is loading a data warehouse and there are multiple jobs to do the load that need to occur in a certain order. Often […]

ETL better and faster

Having been in consulting for over 18 years, I am often asked by business owners or senior management how they can deliver solutions that are faster and better. They also want world-class products that captivate the customer, in addition to better predictability in the solutions delivered. I have found a way to have repeatable success […]

Doing ETL right…

Have you ever been responsible for ETL and your end user(s) report that the numbers are not right?  Do you have a methodology or a process to go back and verify the numbers are what they are?  When you are building ETL, are you writing audits logs that capture metrics that are important to the […]