Using Azure Automation to Shut Down a VM only if a SQL Agent Job is Not Running.
I have a client who uses MDS (Master Data Services) and SSIS (Integration Services) in an Azure VM. Since we only need to execute the SQL Agent job that runs the SSIS packages infrequently, we shut down the VM when it is not in use in order to save costs. We wanted to make sure… Continue reading Using Azure Automation to Shut Down a VM only if a SQL Agent Job is Not Running.
My Preferences for SSIS Design
Lately, I have been using SSIS execution frameworks and Biml created by other people to populate data marts and data warehouses. It has taught me a few things and helped me clarify what I like and dislike compared to my usual framework. I’ve got the beginning of my preferences list started below. There are probably… Continue reading My Preferences for SSIS Design
Check Out the Updated Violin Plot Power BI Custom Visual
I wrote about the violin plot custom visual by Daniel Marsh-Patrick back in February. I thought it was a good visual then, but version 1.3 has recently been released with some nice enhancements. First, the violin plot is now a certified custom visual. This means that it has been tested by the Power BI team… Continue reading Check Out the Updated Violin Plot Power BI Custom Visual
Why We Don’t Truncate Dimensions and Facts During a Data Load
Every once in a while, I come across a data warehouse where the data load uses a full truncate and reload pattern to populate a fact or dimension. While it may not be the end of the world for a small table, it does concern me and I usually recommend to redesign the load. My… Continue reading Why We Don’t Truncate Dimensions and Facts During a Data Load