See active sessions in PL/SQL
In my current project, we are working with PL/SQL for the client, and in that regard, it’s important to have a variety of tools and scripts at your disposal to help manage and monitor...
Tagged: Data
Extract data from Azure Data Lake CDM with KingswaySoft
This dataflow requires the KingswaySoft Productivity Pack, to get the CDM Source component. For this brief run through, I will use VS2019 and KingswaySoft ProductivityPack v22.1. Connection Manager The connection to the Data Lake...
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.
Installing Visual Studio 2017 and KingswaySoft
I have previously writting about an error I recieved when I attempted to installed SSDT for Visual Studio 2017. But with the new version of SSDT, Microsoft have seemingly fixed the bug, and you...
Dynamics 365 Storage analyzer
For a long long time, I have been looking for a tool, that could give me an overview over data usage in CRM, but I havent been able to find something, that suited my...
Split fullName into first- and lastname in SQL, Excel and SSIS
This is something I find myself doing over and over and over again, when importing data to CRM, seeing as CRM wants the contacts as Firstname and Lastname. And the data I receive is...
KingswaySoft winter release (v9.2)
KingswaySoft just pushed out their Winter release for the Dynamics 365 toolkit (version 9.2), which primarily contains fixes in their toolkit. One of the bugs it fixes, is something I ran into myself. When...
New job: Clubtimiser A/S
We have over the last few years been developing a CRM solution for sports clubs, to help them manage their sponsors, partners, and matches – and that solution have now given birth to a...
KingswaySoft introduces their Dynamics365 toolkit
In response to the launch of Microsofts Dynamics 365, which merges their dynamics systems into one (CRM, NAV and AX), KingswaySoft is also merging their toolkit for these systems into one. And that merge...
Millions of credential validations on the Active Directory from SSIS
While monitoring the event viewer on our Domain Controller, we started seeing a ever increasing number of credential validations each second, that we could not fully understand at first. I will attempt to give...