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:
Tagged: SQL
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...
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)
Installing Visual Studio 2017 and KingswaySoft
I have previously writting about an error I recieved when I attempted to installed SSDT for Visual Studio 2017. But with the new version of SSDT, Microsoft have seemingly fixed the bug, and you...
Split fullName into first- and lastname in SQL, Excel and SSIS
This is something I find myself doing over and over and over again, when importing data to CRM, seeing as CRM wants the contacts as Firstname and Lastname. And the data I receive is...
Error installing SSDT for VS2017: Failed to acquire payload
I recently had to install VS2017 with KingswaySoft on a computer, and I ran into some issues in regard to the installation. After I had installed the Visual Studio software, I needed to install SSDT (15.5.0).
KingswaySoft introduces their Dynamics365 toolkit
In response to the launch of Microsofts Dynamics 365, which merges their dynamics systems into one (CRM, NAV and AX), KingswaySoft is also merging their toolkit for these systems into one. And that merge...
Millions of credential validations on the Active Directory from SSIS
While monitoring the event viewer on our Domain Controller, we started seeing a ever increasing number of credential validations each second, that we could not fully understand at first. I will attempt to give...
Using the KingswaySoft Duplicate Detector
KingswaySoft recently released their version 1.0 of the Productivity Pack which has some awesome features – and I will focus on one in particular in this blog post. The Duplicate Detector. I’ve already used...