Homemade SSIS load balancer for large data loads
When you need to import hundreds of thousands records, it can take a long time to import with the KingswaySoft destination. This can be a serious issue, if a large data load is part...
Category: CRM
Difference between two dates (SQL, SSIS and JavaScript)
When I work with contracts, accruals, forecasts etc, I often have to calculate the duration of the contract, or in general the difference between two dates. I have been using an ordinary datediff in Months, as this is the fastest way, to get the duration of a contract in months.
Create Application user in Azure for use in Dynamics 365
When using multifactor authentication for your Dynamics 365, it tends to cause issues with the KingswaySoft connector, as MFA is not supported by their toolkit. Therefore – as an alternative to disabling the MFA...
SSIS Basics: Merge join
For this small how-to, I’ll go through how to use the Merge Join in SSIS. The Merge Join is used for joining data into the a single row from two different datastreams. A basic...
Open dashboards in a new window
It can sometimes be a requirement, to open a dashboard in a seperat window using a URL – but what does the link look like, and where can you find the info you need?...
Fix: Dynamics 365 App for Outlook missing in navigation
I’ve run into an issue a few time, where the navigation button for the Dynamics 365 App for Outlook is missing from the Settings navigation. And there doesnt seem to be any way to...
Fix: Business Proces Flow not updating stepname
In january 2019, I started getting reports from customers, that their business process flows was not updating the stepname on opportunity records anymore. Logs showed, the fields were updated in december 2018, but suddenly...
JavaScript basics: Conditionally hide sections and tabs
I recently started looking into javascript, with the purpose of expanding my customization toolbelt for Dynamics CRM, and I wanted to share some of my small customizations here for others to use (primary for...
Dynamics 365 v9.0 with less padding
I recently fell over a blog from Andrew Butenko (link to his blog post), where he demonstrated a method, to minimize the whitespace padding in Dynamics 365 v9.0. His code works very well, but...