Aug 12, 2022 | Azure, Microsoft Power BI
By: Ken Adams Over the last number of years our company, Key2 Consulting, has seen a shift in our clients’ desires to move to the cloud. We historically were a business intelligence shop that mostly architected on-premise solutions. Creating these solutions...
Mar 9, 2022 | Azure, Azure Data Factory
By: Shannon Nagy When transitioning from on-premise ETL processes with SQL Server to the cloud with Azure, you may be used to dealing with large numbers of SSIS packages in order to perform data movement operations on many tables at once. You may have even worked...
Nov 29, 2021 | Azure, Data Security, Databricks
By: Phillip Sharpless When building solutions with Azure Databricks (see my previous blog post on Databricks for a quick overview of the analytics service), it’s more than likely that the need to access secure data will arise. Access to some data may require...
Oct 12, 2021 | Azure, Azure Data Factory
By: Shannon Nagy Are you a mid-career Microsoft-based data integration or ETL/ELT professional who has not yet migrated operations to the cloud and are still trying to orient yourself in the post-on-premises data landscape? Perhaps you have spent the last...
Sep 13, 2021 | Azure, Azure Data Factory
By: Brad Harris So you’re excited – a brand new cloud data project has just come your way. The project involves designing a solution that provides a hybrid approach for moving data to the cloud. Your client wants to take a step forward in...
Feb 4, 2021 | Azure, SQL Server
By: Matt Wisor SQL Server on Azure Virtual Machines is one of Microsoft’s cloud options for customers looking to move SQL Server to the Azure platform. As the name implies, it means hosting SQL Server in the cloud on an Azure Virtual...