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:
Category: How-to
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...
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...
Homemade SSIS load balancer for large data loads
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...
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.
Easy way to fetch row count for all tables in a SQL database
This is just a quick post for, with a old method for fetching the row count for a entire database – for future reference (Works in Azure – doesn’t require stored proc)
Create Application user in Azure for use in Dynamics 365
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...
SSIS Basics: Merge join
For this small how-to, I’ll go through how to use the Merge Join in SSIS. The Merge Join is used for joining data into the a single row from two different datastreams. A basic...
Open dashboards in a new window
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?...
