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...
Category: SQL
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)