...configuring DATA as a non-coder
Ensuring Data Integrity by Identifying and Addressing Untrusted Foreign Keys Foreign keys are crucial in maintaining the integrity of relational databases by enforcing relationships between tables. However, there are instances when foreign keys become...
I’ve tried all of the sudden not being able to push or pull to git, with the error mentioned in the title. From what I found worked to fix it, was this command in...
Python and PowerShell, both renowned for their versatility, serve distinct purposes within the scripting landscape. Python, with its extensive library ecosystem and readability, is often favored for tasks like data manipulation, machine learning, and...
It happens that the linenumbers are missing in SQL Server Management Studio, and it isn’t really straight forward how to re-enable them. These are the steps to enable linenumbers in SSMS:
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...
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...
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.
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...
KingswaySoft MVP & Microsoft certified professional
My name is Thomas and I am a Senior Data Consultant at a company called netcompany A/S in Denmark. My primary focus is working with SQL, SSIS and KingswaySoft, where I perform integrations, data-transformations and data-modelling.
KingswaySoft have developed an outstanding piece of software for datamanagement to and from CRM, and I can recommend this toolkit for nearly every situation. Link to their website: kingswaysoft.com
