Apr 15, 2026 | SQL Server, Uncategorized
Author: Austin Dolezal Many businesses are wasting time and money cleaning up their data when small fixes and tweaks could optimize their processing time and storage space. Database indexes and partitions are often created and forgotten about until there is an...
Apr 12, 2021 | Uncategorized
By: Brad Harris What is Apache Airflow? Apache Airflow is an open-source platform for authoring, scheduling, and monitoring workflows. In layman’s terms, I like to think of the platform as similar to a Microsoft SQL Server SQL Agent job on...
Oct 25, 2019 | Uncategorized
By: Jason E. Bacani As one of many Key2 Consulting members attending PASS Summit 2019, this year’s trip marks my fifth time going to the Emerald City for this wonderful learning and networking event. Suffice to say, I’m not a newcomer, but...
Mar 20, 2018 | Uncategorized
By: Paul Schuliger The rise of NoSQL databases has brought about the ability to quickly and easily receive or retrieve data and store it without a predefined schema. This is great, but I would argue that although the data can be stored without a...
Jan 10, 2017 | Uncategorized
By: Matt Wollner Senior Business Intelligence Consultant at Key2 Consulting I was looking to kick off multiple SSIS packages, in parallel, from a master SSIS package. The most common way I’ve seen this done is to create several Execute Package...
