SQL basics: Display linenumbers in SSMS
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:
...configuring CRM as a non-coder
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...
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?...
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