cybertalk.org cybertalk.org

Cloud security spending increasing, by how much?

EXECUTIVE SUMMARY: In 2020, worldwide public cloud revenue is expected to increase by 17%. Organizations are pouring money into cloud investments. As these investments take root, organizations are also headed towards staffing challenges and potential security issues. A large swath of organizations report a shortage of qualified employees when it comes to setting up, maintaining and securing the cloud. One-third of organizations report...

schneide.wordpress.com schneide.wordpress.com

Querying gaps between date ranges in Oracle SQL

Let’s say we have a database table with date ranges, each range designated by a RANGE_START and a RANGE_END column: CREATE TABLE date_ranges ( range_start DATE, range_end DATE ); RANGE_START RANGE_END ----------- --------- 05/02/2020 01/04/2020 02/04/2020 15/04/2020 16/04/2020 01/05/2020 01/06/2020 20/06/2020 21/06/2020 01/07/2020 02/07/2020 31/07/2020 05/08/2020 30/08/2020 We are now interested in finding the gaps between...