...configuring DATA as a non-coder
As a Python developer, you’ve likely relied on the trusty print() statement for debugging and understanding your code’s execution flow. While print() is simple and convenient, it has limitations, especially in larger and more...
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.
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
