...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...
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:
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
