Dec 5, 2022 | Azure, Azure Data Factory, Azure Databricks, How To
By: Brad Harris The Problem Over the past couple of months, I have been working with Azure Data Factory (ADF) in a project where we are migrating all of our on-prem data to the cloud using a combination of Azure Data Factory and Azure Databricks....
Jun 15, 2022 | How To, Microsoft Power BI
By: Mason Prewett When creating a Power BI report, the number of measures can add up and become difficult to organize and manage. Having measures in a table with other fields can become confusing. A measure table can help, but this too begins to get cluttered....
Mar 30, 2022 | How To, SQL Server
By: Ken Adams The Problem I recently ran across an issue on a project that required a large amount of data to be removed from a table, specifically an issue with the loading of the table causing duplication of data. All non-clustered indexes had been removed...
Mar 14, 2022 | How To, SQL Server
By: Phillip Sharpless The need to export data from a database to some other format is a pretty common scenario for many data professionals. SQL Server Management Studio provides several different ways to accomplish this, some more complicated than others. If...
Mar 9, 2022 | Azure, Azure Data Factory, Cloud Technology, How To
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...
May 4, 2021 | How To, Microsoft Power BI
By: Mason Prewett What are Power BI Streaming Datasets? Power BI Streaming Datasets allow developers to create reports and dashboards that refresh in real time as a Power BI dataset is updated. These datasets can be updated by various methods, such as using...