Jun 15, 2022 | 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....
Apr 14, 2022 | Microsoft Power BI, Microsoft PowerApps
By: Austin Gainey The Microsoft Power Apps platform offers a variety of tools and applications that can make interacting and communicating with your users or customers much more efficient. It is always in your client’s best interest if you can deliver...
Mar 30, 2022 | 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 | 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
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...
