(Dimitri Gielis) When developping Oracle APEX apps I like to instrument my code with APEX_DEBUG and/or Logger.
Community
Change SYS password in Data Guard environment
(Anuradha Mudgal) Today we are going have look at changing the password of SYS in the Data Guard environment.
Performing Location-Based Analysis – Live SQL Tutorial Available
(Jean Ihm) An Oracle Spatial tutorial for newbies, Performing Location-Based Analysis Using Oracle Spatial and Graph, is now available on Live SQL (thanks David Lapp)!
Pass SSIS Variable from Parent to Child Package in SQL Server Integration Services
(Bhavesh Patel) When working with SQL Server Integration Services (SSIS), we might need a package that calls another package by executing a package task.
Folder Structure In React
(Priyanka Jain) This article talks about creating React application and learning folder structure in React.
Authorizations required for Db2 utilities using FlashCopy
(Florence Dubois and Paul McWilliams) The Db2 for z/OS development SWAT team recommends using FlashCopy as a best practice for non-disruptive consistency checks with the Db2 CHECK INDEX, CHECK DATA, CHECK LOB SHRLVL CHANGE utilities.
Improving .NET Core installation in Visual Studio and on Windows
(Lee) Visual Studio 2019 version 16.3 and .NET Core 3.0 Preview 7 improve the installation experience of .NET Core on Windows.
Transparent Proxy Maintenance for MySQL, MariaDB & Percona Server
(Gilles Rayrat) When it comes to zero downtime, proxies are the first line components of a cluster.
Transforming Outliers in Oracle Data Mining
(Brendan Tierney) In previous posts I’ve shown how to use the DBMS_DATA_MINING.TRANSFORM function to transform data is various ways including, normalization and missing data.
Graceful shutdown of forked workers in Python and JavaScript running in Docker containers
(Maarten Smeets) You might encounter a situation where you want to fork a script during execution. For example if the amount of forks is dependent on user input or another specific situation.